2011-02-03
2,884 reads
Indexing
Query to get tables with no clustered indexes
Query to get tables with no clustered indexes(2K5,2K8,2K8 R2)
2011-02-14 (first published: 2011-01-28)
1,835 reads
Effective Clustered Indexes
As a guideline, clustered Indexes should be Narrow, Unique, Static and Ever Increasing (NUSE). Michelle Ufford Explains why.
2011-01-17
4,641 reads
2013-07-05 (first published: 2010-11-23)
20,796 reads
2010-10-05
3,099 reads
2011-03-18 (first published: 2010-09-21)
2,818 reads
Mid September Free Training from PASS
There's going to be over 30 hours of free online SQL Server training in the upcoming week and you're not going to want to miss out!
2010-09-13
1,800 reads
2010-09-10
3,457 reads
2010-07-22
3,536 reads
2010-07-08 (first published: 2010-06-17)
1,430 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Advice I Like: Praise
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
Forums
Is there a way to have dynamic table headers?
Hi everyone I have a SP which compares two tables and outputs mismatching entries:...
Learning a New Language
Comments posted to this topic are about the item Learning a New Language
is there a way to "detect" schema like changes on a server?
Hi, we have a few people who like to experiment on our prod sql...
Question of the Day
Copying Production Schema
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers