2012-04-13 (first published: 2007-10-19)
3,401 reads
Scripts
Restore Server/Database users/roles
Restore server/database users and roles from another server when we are restoring databases to another server.
2012-04-12 (first published: 2007-10-23)
3,115 reads
Auto compression all indexs on all online db
Auto compression of index, if index includes > 1 million rows.
2012-04-11 (first published: 2012-03-19)
928 reads
Remove Logins Script
Generates a script to remove logins from a SQL Instance. Handles cases where logins own schemas.
2012-04-05 (first published: 2012-03-26)
1,363 reads
2012-03-30 (first published: 2008-04-21)
3,222 reads
Generate index on foreign key columns
Script find all foreign key without index in database and create new one for them.
2012-03-29 (first published: 2008-01-25)
3,401 reads
Select, Update, Delete, Insert etc.. in many servers using 1 query
Query Servers using 1 sql statement. Will make your job easy!!!
2012-03-28 (first published: 2008-01-16)
3,362 reads
DBCC Reindex with Statistics Information and table name optional
Reindex all tables, showing statistics before and after reindexing, table name optional.
2012-03-27 (first published: 2008-01-30)
3,116 reads
2012-03-26 (first published: 2008-01-23)
3,246 reads
Different Date Formats
You Can Find Some Date Functions and extracting the different Date Formats using the Convert and Cast
2012-03-23 (first published: 2007-10-26)
3,689 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
ALAMAT BANK BCA KCU PEMATANG SIANTAR TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
ALAMAT KANTOR BCA KCU WISMA ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers