The Ultimate Object Searcher
Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.
2009-10-06 (first published: 2009-09-22)
1,255 reads
Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.
2009-10-06 (first published: 2009-09-22)
1,255 reads
2009-10-05 (first published: 2009-09-21)
2,293 reads
Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.
2009-10-02 (first published: 2008-11-05)
1,207 reads
This script export data into excel/CSV file using BCP comnand with column headers
2009-10-01 (first published: 2009-09-22)
3,608 reads
Ever tried to simulate a production environment in a development one but realized that you couldn't easily start 500 executions simultaneously ? This script will help you out.
2009-09-30 (first published: 2009-09-16)
2,107 reads
2009-09-29 (first published: 2009-09-17)
948 reads
Be alerted or take custom actions when specified jobs are in the "Running" state for a length of time.
2009-09-25 (first published: 2009-09-15)
941 reads
2009-09-24 (first published: 2009-09-15)
719 reads
Performs a checkpoint or a transaction log backup followed by a DBCC SHRINKFILE on the transaction log to the target percentage specified relative to the total data file(s) size.
2009-09-23 (first published: 2009-08-27)
2,571 reads
This script takes a table as parameter and generate its data script (INSERT INTO TABLE).
2009-09-21 (first published: 2009-09-13)
2,291 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers