Detect and Alert DBA of Blocking SPIDS
This script will detect and alert the DBA of blocking processes. The DBA can adjust the length of time the block has exisited before sending the net send message.
2001-08-29
5,187 reads
This script will detect and alert the DBA of blocking processes. The DBA can adjust the length of time the block has exisited before sending the net send message.
2001-08-29
5,187 reads
This script creates a stored procedure that, when executed, queries the system tables of any SQL2000 database to return a complete, ordered datadictionary. *Warning**This script only works on tables which have the description property filled out as my main purpose was to query the extended property description feature new to SQL2000. If you have not […]
2001-08-27
3,111 reads
2001-08-26
1,396 reads
2001-08-22
393 reads
Displays database properties. Was this the best way of doing it? Probably not, but it works.
2001-08-22
535 reads
Displays Maintance plan history if any. I used distinct to filter out and return only what is relevent to what I need. You may not wish this for your purposes. Feel free to make changes
2001-08-22
363 reads
2001-08-22
716 reads
Returns a list of table names from the current database Which do not have primary keys assigned.
2001-08-22
413 reads
2001-08-22
549 reads
2001-08-22
705 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...
Hello All, I have recently joined a project, where main, core tables with millions...
How many table hints can I include in a query?
See possible answers