2008-01-28 (first published: 2007-12-03)
1,706 reads
Scripts
Server Login/Role And DB User/Role Script
This script will produce the server login/role and db user/role in all databases in the server.It is best advised that you first delete/recreate orphaned users for best results
2008-01-25 (first published: 2007-11-27)
3,794 reads
2008-01-24
1,238 reads
Locate specific columns used in procs
SP to find object and line number that references column(s) of interest.
2008-01-24 (first published: 2007-11-21)
1,030 reads
Check Availability Window - SQL2k
This script allows you to check the several availability windows for the current day.
2008-01-18 (first published: 2007-10-29)
1,086 reads
Making a table out of a list
Sometimes you are given a list of values in a stored procedure that you want to use in an "IN" clause. This is a common in Reporting Services multi value parameters.
2008-01-15 (first published: 2007-11-15)
1,008 reads
2008-01-14
990 reads
Generating number sequences
Two queries below show one of many ways how You can generate a sequence of numbers.
2008-01-14
929 reads
Check Availability Window - SQL2k5
This script allows you to check the several availability windows for the current day.
2008-01-11 (first published: 2007-10-29)
1,387 reads
SMS Script
This script will modify INI file on destops through SMS push to point server connection from A to B.
2008-01-09 (first published: 2007-10-29)
1,312 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
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...
Forums
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....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...