This script will rename all FK constraint names in your database. It will give them a user friendly name that can be used in error messages, etc. The FK contraint names will be formatted as FK_ChildTableName_ParentTableName_soid. Note: You first need to enable 'Allow modifications to be made directly to the system catalogs'. This can be […]
2003-09-19
1,225 reads
This is a comment on/modification of the Usp_FindAllDBSizes script on Sept 17th.Why use an inner loop when you can use a select stmt?
2003-09-17
137 reads
We can know how much space a database is occupied in hard disk by using sp_spaceused function. If we want to find all database sizes at a time, we have to provide use and sp_spaceused for all databases. It takes some time to write all those T-sql statments. My script will find each and every […]
2003-09-16
1,689 reads
SQL Server includes the COUNT function for counting a table's rows - however, it can be slow. Although querying the "rows" column from the sysindexes table is faster, it is not always accurate (e.g., if a bulk load process has recently taken place). In addition, you would not be able to use this method in […]
2003-09-11
472 reads
This a modification to the script given by eugene_b.It generates prime numbers to the upper bound you specify.I have done some simple modifications to speed the process
2003-09-10
173 reads
2003-09-08
607 reads
Following on from todays QOD (on xp_cmdshell permissions) I thought this might be useful.Takes a directory or UNC path and returns the contents as a table. eg:exec sp_getdir '\\mypc\c$'returns:datestring timestring directory filesize nameoffile---------- ---------- ----------- ----------- ----------------------18/07/2003 10:45 1 NULL Documents and Settings18/07/2003 11:02 […]
2003-09-04
307 reads
This query will give you the current job status of all scheduled jobs on sql server. Just by using sysJobs, and sysJobHistory table you will get to know the details about the last status of the scheduled jobs, irrespective of their status like failed, successful, or cancelled.Note: You must have admin right on MSDB database […]
2003-09-04
8,600 reads
This UDF is using in reporting where lots of durations are calculated, stored and then summed up and averaged for reports. By storing the durations as floats (which are similar to the fixed point numbers datetimes are stored as) math functions are simpler.The problem is that float-times are not human readable, and cast(@floatime as datetime) […]
2003-09-03
1,039 reads
With a dynamic sql script under 4000 chars use sp_executesql With under 8000 chars write it to a variable.For anything longer you can use this script. Use UpdateText and WriteText to write your dynamic sql to a text/ntext field in a table somewhere and then pass its location to this script.
2003-09-01
639 reads
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Pergudangan, Kw. Pergudangan Dan Industri Tunas Bitung, Jalan Kp Crewed Blok E5, Sukadamai, Kec....
Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat...
Jl. Yos Sudarso No.155, Taba Jemekeh, Kec. Lubuk Linggau Tim. I, Kota Lubuklinggau, Sumatera...
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers