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
245 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,037 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,421 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
This script allows you to dynamically alter all the tables in your database. In the script i am building up an alter statement that adds a 'TimeStamp' column a table.If anyone knows a better way to do this kind of thing, feel free to drop me a mail (jamie.moffat@infographics.co.uk)
2002-07-04
754 reads
Returns the key fields of all duplicate rows in a table based upon any fields in the table.
2002-07-04
742 reads
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
As a data & AI strategist who’s seen countless projects succeed and fail, I...
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Comments posted to this topic are about the item Changing the Recovery Time
Comments posted to this topic are about the item Getting More Time from AI
Comments posted to this topic are about the item When Page Prefetching Takes a...
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers