2001-09-04
539 reads
Scripts
Handling Delimited Strings in T-SQL
There may be cases where you want to work with delimited strings in T-SQL. Following two examples will cover most of the stuff that you will face while working with strings.
2001-09-01
3,187 reads
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,222 reads
Script to obtain datadictionary from a SQL2000 db
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,136 reads
2001-08-26
1,423 reads
2001-08-22
407 reads
hx_DatabaseProperties
Displays database properties. Was this the best way of doing it? Probably not, but it works.
2001-08-22
553 reads
hx_dbMaintancePlans
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
395 reads
2001-08-22
729 reads
hx_GetPKLessTables
Returns a list of table names from the current database Which do not have primary keys assigned.
2001-08-22
431 reads
Blogs
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Forums
Alamat Kontak BCA KCP Pamulang Telp:(08218154392)
WA CS 08218154392 Jl. Pamulang Permai Blok SH 15 No.17, Pamulang Bar., Kec. Pamulang,...
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....