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
Reorganize
RE: Can't Debug a Stored Proc
NO, it's actually being started under the domain Administrator's login.
2003-12-11
2 reads
RE: Login exists, member of role, access to database
Well im not writing it for you ... but check these objects out: mydb..sysmembers: contains a row for each member of a database role master..syslogins: hooks to mydb..sysusers over the sid column master..sysdatabases: loop for all these Cheers Ck Chris Kempster www.chriskempster.com Author of "SQL Server 2k for the Oracle DBA"
2003-07-10
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