2012-10-12 (first published: 2012-09-10)
1,808 reads
Scripts
Job Summary
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,123 reads
Tables, Queues, and Indices as a Percent of DB Size
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,099 reads
Get a range of numbers
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,507 reads
2012-10-04 (first published: 2012-04-10)
2,041 reads
Find Primary Column of all tables in database
This code helps in finding Primary Keys for all tables in a database.
2012-10-02 (first published: 2012-09-04)
1,446 reads
2012-10-01 (first published: 2012-09-05)
2,606 reads
SQL Server Uptime
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,451 reads
Find all actual words from Dictionary Table using jumbled word
How to get all actual word from a table,if I pass a jumbled word
2012-09-27 (first published: 2012-09-05)
845 reads
Index Defragmentation
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.
2012-09-26 (first published: 2009-11-18)
12,469 reads
Blogs
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers