Finding Unused Database Roles
This is a data quality script that locates unused Database Roles for maintenance purposes
2012-07-24 (first published: 2012-07-05)
1,370 reads
This is a data quality script that locates unused Database Roles for maintenance purposes
2012-07-24 (first published: 2012-07-05)
1,370 reads
Tells you how much the databases are using the space on disk taking in account the free space at the end of the database.
2014-01-08 (first published: 2012-05-04)
3,934 reads
Auto compression of index, if index includes > 1 million rows.
2012-04-11 (first published: 2012-03-19)
900 reads
This script lets you to know how much disk space will be left after the next database grow taking in account the free space left in the database.
2012-05-08 (first published: 2011-09-13)
999 reads
Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml).
Useful when rebuilding indexes online.
2011-08-30 (first published: 2011-08-25)
741 reads
I have a database which has several tables that have very heavy write operations. These table are very large and some are over a hundred gigabytes. I noticed performance of this database is getting slower and after some investigation we suspect that the Auto Update Statistics function is causing a performance degradation.
2011-02-25
5,231 reads
In a previous tip on creating a Function to Return Default SQL Server Backup Folder , you've seen how you can create a T-SQL function to query the registry and retrieve the default SQL Server Backup folder. Is there an easier way to do it in Windows PowerShell?
2010-04-23
2,763 reads
2015-02-12 (first published: 2010-03-12)
4,914 reads
2009-11-04
3,443 reads
2013-03-08 (first published: 2009-10-02)
3,317 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers