2011-11-18 (first published: 2008-01-29)
2,907 reads
T-SQL
2008-03-14 (first published: 2008-01-29)
1,274 reads
Importance of UPSERT
A simple UPSERT can reduce reads on tables. This in turn will increase the performance of a DB.
2008-01-29
12,339 reads
Identify Unique Columns
Tool to automatically query combinations of columns in your table to determine candidate for unique key.
2012-08-21 (first published: 2008-01-28)
2,880 reads
2012-03-26 (first published: 2008-01-23)
3,241 reads
2008-01-23
3,118 reads
2008-01-17
2,671 reads
2008-01-15
3,432 reads
Evaluating How Filtering Options Affect T-SQL Performance
The many popular rules concerning T-SQL filtering operators can't be trusted implicitly; instead, you should evaluate your options explicitly.
2008-01-14
2,792 reads
2011-09-20 (first published: 2008-01-11)
2,493 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers