Get a summarized report of all DataBases options
This SELECT will give you a summarized report for the options selected for ALL the databases on your SQL Server. It's compatible with versions 7 and 2000.
2002-07-11
649 reads
This SELECT will give you a summarized report for the options selected for ALL the databases on your SQL Server. It's compatible with versions 7 and 2000.
2002-07-11
649 reads
Here's a script that will read a text file from the Windows system into SQL Server
2002-07-11
1,115 reads
This procedure gets a tablename, column and an integer number N as parameters and finds the Nth maximum value of the column's value in a table for example : running it with 'products', 'UnitPrice' , 13 , @reswill get the 13TH largest value of unitprice from products is no such N exist an error message […]
2002-07-10
246 reads
PROCEDURE used to find the server's default collation not shown in EM in servers properties
2002-07-10
1,114 reads
Here's a simple SQL to give you locking information.The SQL tells you what resource type you are using, the object name, lock request mode, lock status, and also the calling program's name.And all this from a simple query on sysprocesses, and syslockinfo!
2002-07-10
671 reads
This SQL Server stored procedure generates more readable output from the system sp_lock procedureinstead of getting object ids and session ids it returns the object name and user name
2002-07-10
1,042 reads
this procedure is an interface to bcp it gets database name,table name , file and path,,mode E/I for export/import and seperator character user and password and exports/imports text files from / to SQLSERVER
2002-07-10
1,422 reads
this script describes the steps neccessary to implement full text indexing in TSQL on your SQL SERVER systemCan be used programatically in tsql code
2002-07-10
727 reads
This is a very simple and small stored procedure which will help you identify repeated rows on any given table. This is specially useful for situations when you want to clean up a table and add a primary key on it, but you cannot until all duplication is eliminated. Only two parameter are necessary; table […]
2002-07-08
1,082 reads
Deletes the duplicates from a table based upon any fields in the table leaving a single copy of the record in the table.
2002-07-04
924 reads
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Hej, I'm not facing this issue but as I was working another parameter sniffing...
Hi everyone I have a 1000 line SQL query that is too long to...
hi, now and then i want one connection in my ssis pkgs to use...