2009-06-11 (first published: 2009-05-25)
789 reads
2009-06-11 (first published: 2009-05-25)
789 reads
This script is used to print the alter statement and also partition the table with the respective partition Scheme and Partition Function.
2009-06-10 (first published: 2009-05-22)
2,420 reads
Script to convert to N Columns the rows in a table with PIVOT Operator
2009-06-05 (first published: 2009-05-15)
2,037 reads
Here is a stored procedure that start a job, and then waits until the jobs is finished
2009-06-02 (first published: 2009-05-14)
1,083 reads
Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!
2009-05-29 (first published: 2009-05-05)
957 reads
2009-05-27 (first published: 2009-04-30)
2,627 reads
2009-05-22 (first published: 2009-04-28)
3,854 reads
The function is used to find non-printable ASCII characters in an input string.
2009-05-21 (first published: 2009-04-24)
3,027 reads
Lists the Databases and their Backups status in a neatly formatted HTML Email
2009-05-19 (first published: 2009-04-23)
3,019 reads
2009-05-14 (first published: 2009-04-08)
2,019 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
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