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
443 reads
This script derives the first day of the month and the last day of the previous month...
2002-04-04
443 reads
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
286 reads
The fastest way of getting LastDayPreviousMonth / FirstDayCurrentMonth
2002-04-04
194 reads
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
858 reads
The script calculates the end and the beginning of the last, the current and the next months.
2002-04-01
987 reads
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,553 reads
2002-03-27
2,855 reads
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,610 reads
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
510 reads
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,588 reads
By gbargsley
Are you diversifying your DBA skillset? My recent job search made one thing clear:...
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Comments posted to this topic are about the item Vector Datatype
Comments posted to this topic are about the item PRs Are Like Trouble Tickets
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers