Get concatenated value for a column without cursor
This script provides comma separated values of one column for each value of another column. It provides it in SQL 2005 without using cursor.
2010-07-06 (first published: 2010-06-14)
2,329 reads
Scripts
How to output datafiles location using sp_helpdb?
This is a quick way of outputting the location of your database files/dbsize/date created on your instance.
2010-07-02 (first published: 2010-06-06)
1,391 reads
Restore All Backups
SCRIPT TO RESTORE BACKUP FOR ALL DATABASES, PLACED IN FOLDER CALLED
ORIGIN_FOLDER, WITH THE INITIALS 'DBVF' AND EXTENSION '.BAK'
2010-06-30 (first published: 2010-06-08)
2,853 reads
2010-06-29 (first published: 2010-06-09)
1,194 reads
Finding Ratio between two numbers
This function finds the ratio betwen two numbers.Just plug into your SP and enjoy.
2010-06-23 (first published: 2010-06-01)
2,275 reads
Get default values of parameters in stored procedures
Helps to get the default value of parameters from stored procedures and functions.
2010-06-22 (first published: 2010-05-26)
3,455 reads
Another way to get a table list from a string
I prepared this version (my original did not used XML)
By being helped by forums feedback from SQL central
Forward it to yours peers.
2010-06-15 (first published: 2010-05-13)
1,912 reads
fn_getfiledetails - a replacement for xp_getfiledetails
As the undocumented SQL Server 2000 function xp_getfiledetails is not existent any more in 2005 or later i needed a replacement...
2010-06-14 (first published: 2010-05-07)
3,651 reads
IsNumber fails cast while IsBigInt passes cast
IsNumber does weak checking and fails cast to BigInt so I wrote IsBigInt to replace it.
2010-06-11 (first published: 2010-05-05)
3,543 reads
A quick way to find recently entered datetime entries in tables
Sometimes you need to scan a large number of datetime columns for most recent access.
2010-06-08 (first published: 2010-05-04)
1,889 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Alamat Telp BCA KCP Jamblang +62 838-4945-0961
Wa:083849450961 Jl. Jamblang Raya No.51, RT.2/RW.1, Duri Sel., Kec. Tambora, Kota Jakarta Barat, Daerah...
Telp BCA KCP Mandala Raya +62 838-4945-0961
Wa:083849450961 Jl. Mandala Raya No.14, RT.13/RW.5, Tomang, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers