 | The SQLTeam.com Newsletter |
If you have trouble viewing this message we have an HTML version online. You can subscribe by visiting SQLTeam.com.
Sponsor's Message
| SQL Source Control - Eric's in. Are you? | |
 | Eric Sink SourceGear | |
 |  |
Recent Blog Posts
Use PowerShell to Add a Login to a Database Role in all Databases [sqlblog.com/blogs/allen_white/]
NOSQL- A Quick Overview [kevinekline.com]
SQL Server Locking and You! [www.brentozar.com]
Scale out SQL Server by using Reliable Messaging [rusanu.com]
Performance issues from wasted buffer pool memory [www.sqlskills.com/BLOGS/PAUL/]
Optimizer Timeouts with XQuery [www.sqlservercentral.com/blogs/scarydba/]
Top 10 Keys to Deploying SQL Server on VMware [www.brentozar.com]
Normalization and How to Know When You Are Done… The short version… [sqlblog.com/blogs/louis_davidson/]
Oh ****! [www.sqlservercentral.com/blogs/scarydba/]
SSRS 2008 R2: How to dynamically size your INDICATORS [www.sqlservercentral.com/blogs/sqldownsouth/]
No Shrink-y Tempdb [www.sqlservercentral.com/blogs/steve_jones/]
Moving the standby database to another server [sqlcat.com]
The "Balanced Data Distributor" for SSIS [sqlcat.com]
Be Careful Installing Windows Features [www.englishtosql.com]
Export to CSV from SSMS via PowerShell [billfellows.blogspot.com]
Pssdiag/Sqldiag Configuration Manager released to codeplex [blogs.msdn.com/b/psssql/]
SQL Q&A: Dynamic Data and Disaster Recovery [technet.microsoft.com]
SQL Server Magazine: feature article on advanced BACKUP and RESTORE options [www.sqlskills.com/BLOGS/PAUL/]
Benchmarking: Multiple data files on SSDs (plus the latest Fusion-io driver) [www.sqlskills.com/BLOGS/PAUL/]
Note: If you'd like to see these as I post them you can visit my SQL Server Links page.
New Forum Topics
How to rename column name!!
How to rename column name in a table without effecting existing data!! Regards
Unclosed quotation
Hi,. In the below query what is wrong with the unclosed quotation declare @sqlstr as nvarchar(1000) declare @dbname varchar(30) set @dbname = @empowerdbname set @sqlstr = 'SELECT e.ID, e.date_modified, e.modified_by, e.product_ID, e.logger_ID, e.enquiry_category_ID, e.consumer_ID, e.HCP_ID, emp.NameGiven '+" " +' emp.NameFamily
Archiving
HI All, I want to archive some of the data from tables in SQL server Management Studio. All that i need to do is Archive the data to another table,Drop the Indexes,Then delete the data from main table and Recreate
charindex,unicode
I want: dbo.bodau('Lê T?n') -> Le Tan dbo.bodau('Ð?c') -> Duc dbo.bodau('Hoàng')-> Hoang CREATE FUNCTION dbo.bodau ( @sstring nvarchar(max) ) RETURNS varchar(max) AS BEGIN if len(@sstring)=0 return'' declare @str As table ([vn] nvarchar(max),[vnU] nvarchar(max),[vn1] char(1)) insert into @str ([vn],[VNU],[vn1]) values ('áà?ã?a?????â?????','ÁÀ?Ã?A?????Â?????','a')
Order hint in bcp for auto-generated fields
I have a table with a clustered key that has 3 columns, where the three of them are generated with default values (they have to do with date and hour and minute in int values :)). I got files that
DTS 2000 Packages Fail after Admin Password Change
We have DTS 2000 packages we've been executing remotely using xp_cmdshell in stored procedures in the master db. Last week we had to change the Administrator password and since then, the stored procedures have returned an OLE DB Provider error
Textcopy equivalent??
Is there anything in SQL 2008 that functions as the TextCopy utility from SQL 2000 days did? I know how to use OPENROWSET BULK, but that requires specific permissions on the server be set. Textcopy was simple in that you
SQL Server Management studio
Hi All, Can any body tell me regarding INdex in SQL server 2005 management studio. I want archive some Data from table. Then I need to drop the index,delete the data and recreate the index. Is this correct,,..?? If so
Restoring a database
what does this error mean TITLE: Microsoft SQL Server Management Studio ------------------------------ Specified cast is not valid. (SqlManagerUI) ------------------------------ BUTTONS: OK ------------------------------
Checkpointing taking lot of time
Guys..I am developing a package in which m using checkpointing..but dnt know why..checkopint update is taking aweful long time..it is actually behaving like following..n m using the same checkpoint settings in other packages..but not havin any probs there.. Information: Checkpoint
Newsletter Information
You are subscribed as penny-stocks@gmx.com. You can unsubscribe here: Unsubscribe Link
SQLTeam Publishing, LLC
PMB 270
4741 Central
Kansas City, MO 64112
If you would like to advertise in this newsletter please contact us.
Copyright (c) 2011 SQLTeam Publishing, LLC
0 comments:
Post a Comment