Finding The Last Date of a Month
Select dateadd(month, 1 ,getdate()) gives the exact date of next month , then find the day of that date. Now back to that days i.e exactly last date of the given month.
2001-10-14
547 reads
Scripts
2001-10-11
8,567 reads
Find Longstanding Open Transactions
Ever forget to commit a transaction and then find out hours later that there is deadlocked transactions all over your database server? Worse yet has one of your coworkers done this to your database server? Never again, this stored procedure will net send the machine that has an open transaction, and send you (The DBA) […]
2001-10-08
9,151 reads
Find strings in a stored procedure
Really simple... it returns a list of stored procedure names that contain the passed in string. Useful for finding all stored procedures that call another specified stored procedure. Call with the following command: exec usp_functions_findinUSP @str='sp_lastmodified'
2001-10-08
2,209 reads
Kill spids that are idle
Ever wanted to get rid of users who are sitting idle for long periods of time? Here's a script that removes spids idle for a variable period of time.
2001-10-03
4,511 reads
Transfer Logins and Passwords Between SQL Server 7.0 Servers
The SQL Server 7.0 Data Transformation Services (DTS) Object Transfer feature transfers logins and users between two servers, but it does not transfer the passwords for SQL Server authenticated logins. (DTS in Microsoft SQL Server 2000 does transfer passwords.)
2001-10-01
1,662 reads
The Log Watcher
A fast way to get a quick look at all the log sizes and space used in a real time fashion.
2001-09-25
2,549 reads
Script to Attach Multiple MDF
Copies mdf files located in a directory on a client and attaches them to the connected server. This is the winning solution to the contest that was presented in an article posted at http://www.sqlservercentral.com/columnists/awarren/reattachingdatabases-somecodeandacontest!.asp. That article shows how to do the same thing using DMO. Wynn Muse is the author of this stored procedure.
2001-09-23
3,595 reads
Disable and Enable Keys (with some validation)
Here are two stored procedures for enabling and disabling all keys (primary and foreign) for a specified database. It makes sure the database specified is not the system databases and the users session is at the DB to have its keys enables/disabled.
2001-09-19
847 reads
Trim Backup Files
This script runs within a DTS package. It searches the backup directory stored as a global variable in the script and trims all backup files older than some number of days. the script includes logging to the C: drive so you can trace the effects of the script. You need to create the global variables […]
2001-09-12
1,519 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers