Ways to minimize sort operations
In this article Brian Ellul explorea how it's possible to eliminate the SORT operator (and its performance cost) on performing SELECTS statements.
2010-09-15
10,904 reads
DBCC FREEPROCCACHE
RE: Using IDENTITY_INSERT with linked servers
I do all my procs thru script files. Compile into dev, test and if all OK compile into uat and live. I still only have one script but different environments. Makes changing and testing easier.
2003-07-29
2 reads
RE: Clustered Indexes
Hi acudlip, quote: 1) drop the non-clustered indexes (takes seconds) - to avoid their rebuild when the clustered index is dropped. 2) drop the clustered index - takes 6 hours!! This is approx equal to the time it takes to build the clustered index - its a big table. how do you drop the indexes? […]
2003-07-15
Blogs
Updating dbatools–Fixing the Certificate Failure
By Steve Jones
I was trying to update my dbatools install to test something and go this...
Classifications and sensitivity labels in Microsoft Purview
By James Serra
I see a lot of confusion on how classifications and sensitivity labels work in...
PASS Data Community Summit: A Personal Journey
By Chris Yates
As someone attending the event since 2011, I would like to share my personal...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers