2012-10-16 (first published: 2012-09-21)
2,578 reads
2012-10-16 (first published: 2012-09-21)
2,578 reads
2012-10-12 (first published: 2012-09-10)
1,821 reads
This script lists the name, running and success status, last executed/currently executing step name, Average and Last duration, next run time and other related information about Jobs.
2012-10-10 (first published: 2011-11-02)
2,134 reads
Two views that give you a variety of stats, sortable as a percent of DB size, for tables, indiceses, XML indices, and Service Broker Queues.
2012-10-09 (first published: 2008-06-16)
3,128 reads
If you need to get a range sequence of numbers this script can help you to acomplish it. For example : the sequency of numbers between -5 and 5 or 1 and 200, etc..
2012-10-05 (first published: 2012-04-23)
1,528 reads
2012-10-04 (first published: 2012-04-10)
2,063 reads
This code helps in finding Primary Keys for all tables in a database.
2012-10-02 (first published: 2012-09-04)
1,456 reads
2012-10-01 (first published: 2012-09-05)
2,615 reads
This script is used to get uptime for the SQL Server. (Supports SQL2005 and onwards only)
2012-09-28 (first published: 2012-09-07)
1,461 reads
How to get all actual word from a table,if I pass a jumbled word
2012-09-27 (first published: 2012-09-05)
858 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