Code Comparison between two databases
This script compares the code (SP, Func. etc.) between two databases (say Dev and QA) and reports the objects which have differences.
2007-03-30 (first published: 2007-03-08)
637 reads
Scripts
Campare Case Insensitive CampareCaseInsensitive
Case Insensitive Camparison remains a problem for most developers since SQL Server not supports any built in function for these purpose here is one wich compares varchar strings and returns 1 is mathes and 0 other wiseselect dbo.CampareCaseInsensitive('A','a')
2007-03-29 (first published: 2007-03-08)
98 reads
SQL Server 2005: Script all Primary Keys
Since it is not possible to script only the primary keys of all tables with the SQL Server 2005 Management Studio, here a small script to get the create scripts for all existing primary keys of the current database.
2007-03-28 (first published: 2007-03-09)
4,311 reads
SQL Server 2005: Script all Indexes
Since it is not possible to script all existing indexes with the SQL Server 2005 Management Studio, here a small script to do this.
2007-03-27 (first published: 2007-03-09)
17,203 reads
Returning a Comma Delimited string
One of the small quirks of SQL is that it can add each row to a variable.In the most common case, this is used to generate a comma delimited list.The script shows how to do this wiht a scalar function, so that multiple rows are returned.The script shows calculating the column sum the hard way […]
2007-03-26 (first published: 2007-03-11)
621 reads
Generate Stored Procedure/Functions Script with SP
It will help to generate DBscript of Stored Procedure/User defined Functions in SQL server without selecting those thru Enterprise manager.Pass the name of Stored procedures/Functions as parameters to the sp_Generate_Script, it generates the scripts and displayed on screen. Choose text format for result display.
2007-03-23 (first published: 2007-03-14)
2,168 reads
List of stored procedures which refer a DB table
It used to find stored procedures where a DB has been used.
2007-03-22 (first published: 2007-03-16)
477 reads
Match Date Only
Here is a simple function to compare datepart of datetime fields , (no need to say ignores hour t,min,sec ... ) isDateMatch(@date1,@date2 ) retruns 1 if the datepart matches else returns 0regardsjohn
2007-03-21 (first published: 2007-02-24)
212 reads
Easily Kill All Users In A Database
This simple script (ran from the master database) in Query Analyser removes all the requirements of collating currently connected spids to a database and the need to systematically open a cursor to kill each spid individually by simply placing the database offline, then immediately online.
2007-03-16 (first published: 2007-02-13)
378 reads
GetDateTimeOfIsoWeek
CREATE FUNCTION [dbo].[GetDateTimeOfIsoWeek](@WeekYearNumber int, @DayNumber int)RETURNS datetime
2007-03-15 (first published: 2007-02-13)
146 reads
Blogs
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers