Finding the first day of the Month
This script derives the first day of the month and the last day of the previous month...
2002-04-04
450 reads
Miscellaneous
Get the Latest Currency Rate as at a date
Have you faced a situation where you want to have the latest currency rates available upto a particular date. Normally you may have to run sub queries but derived tables is the easiest way to do.
2002-04-04
297 reads
LastDayPreviousMonth / FirstDayCurrentMonth
The fastest way of getting LastDayPreviousMonth / FirstDayCurrentMonth
2002-04-04
201 reads
Pass several sets of parameters to run stored proc
This procedure will let you execute existing stored procedure with several sets of multiple parameters like: exec _ParamSplit_SP 'ColorSP', "258,'RED';367,'BLUE';125,'GREEN'",";" it will be the same as exec ColorSP 258,'RED' exec ColorSP 367,'BLUE' exec ColorSP 125,'GREEN'Created for SQL 7
2002-04-03
867 reads
Calculate End/Beginning of Last/Current/Next Month
The script calculates the end and the beginning of the last, the current and the next months.
2002-04-01
1,000 reads
spAuditPasswords
This script is actually part of an article written about performing a simple password audit on SQL Server logins when you start to administor a new SQL Environment. The script will scan the sysxlogins table located in the master database for SQL Server logins with no passwords, passwords that are the same as the login […]
2002-03-27
1,560 reads
2002-03-27
2,869 reads
Use DELETE On Many Tables With Foreign Keys
When deleting data from many tables, foreign key constraints can force you to specifically order your DELETE commands. This can take tons of time, especially if you have many tables. Here's a technique I use to delete data in the correct order during the restaging of test databases.It makes use of the system stored procedure […]
2002-03-22
1,626 reads
Compare the structure & code of 2 databases
We often make changes in the test databases. But failure in making even the smallest change in the production database may lead to unwanted situations.This utility compares 2 databases.Parameters to be passed @DB1 Database 1 (SysName) @DB2 Databse 2 (SysName) @ShowDifferentOnly see later (Bit) Parameters 1, 2 may include server name as well. […]
2002-03-22
524 reads
Double Metaphone (phonitic name matcher)
Soundex is not particularly good, So here is a better name matching algorithm.Add an: ALTER TABLE Contacts ADD DoubleMetaphone AS dbo.DoubleMetaPhone(Contacts.Surname)and then you can use this for de-duplicating contact data.
2002-03-21
1,613 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Google – NotebookLM on ThakurVinay blog
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers