2014-05-01 (first published: 2014-04-09)
1,491 reads
reorganize indexes
Defrag All Indexes On a Database
Script to list out all fragmented indexes for a given database, with options to only view them, reorganize them, or rebuild them in one fell swoop.
2012-05-25 (first published: 2012-05-15)
2,726 reads
RE: Restoring 6.5 databases
Jeff W,Be sure you *practice* the master and msdb restores on a test server somewhere. There is nothing like real life experience for these two potential problems. Problems tend to creep up on them sometimes.
2004-03-30
RE: Can't Debug a Stored Proc
NO, it's actually being started under the domain Administrator's login.
2003-12-11
2 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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