2007-12-27 (first published: 2007-10-23)
1,050 reads
Scripts
Bit Manipulation Functions (4)
Four bit manipulation functions:
1. Turn bit ON
2. Turn bit OFF
3. Check if bit is ON
4. Toggle bit ON/Off
2007-12-25 (first published: 2007-11-01)
1,116 reads
2007-12-21 (first published: 2007-10-25)
1,454 reads
Update Statistics - All Tables (No System)
This proc executing the update statistics command in all user tables (no system).
2007-12-20 (first published: 2007-10-24)
2,400 reads
2007-12-18 (first published: 2007-10-18)
2,705 reads
usp_IndexCreationStatements
(SQL 2005) Creates Index Creation statements based on info colected in system view sys.dm_db_missing_index_details, either with included columns or just In(Equality) columns.
2007-12-13 (first published: 2007-10-11)
1,036 reads
2007-12-12 (first published: 2007-10-12)
3,587 reads
Max Actual datalength
This script returns the defined rowlength and the actual datalength for the longest row in a table.
2007-12-10 (first published: 2007-10-01)
964 reads
2007-12-05 (first published: 2007-10-17)
704 reads
2005 Database Monitor RDL for Management Studio
RDL for use in MSSSQL 2005's Management Studio (custom reports).
2007-12-04 (first published: 2007-09-25)
2,711 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
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...
Forums
Alamat Telp BCA KCP Bona Indah +62 838-4945-0961
Wa:083849450961 Plaza Bona Indah Jl. Karang Tengah Raya Blk B/12, RT.1/RW.6, Lb. Bulus, Kec....
Alamat Telp BCA KCP Cirendeu +62 838-4945-0961
Wa:083849450961 Jl. Raya Cirendeu No.14, Cireundeu, Kec. Ciputat Tim., Kota Tangerang Selatan, DKI Jakarta...
Alamat BCA KCP Altira Sunter Telp 0821 6277 387
Altira Bussiness Park, Jl. Yos Sudarso Kav 85 Blok B No.1-2, RT.9/RW.11, Sunter Jaya,...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers