2007-12-27 (first published: 2007-10-23)
1,048 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,115 reads
2007-12-21 (first published: 2007-10-25)
1,450 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,399 reads
2007-12-18 (first published: 2007-10-18)
2,702 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,586 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)
962 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
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Alamat Telp BCA KCP Palur +62 838-4945-0961
Wa:083849450961 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
Telp BCA KCP Utan Kayu +62 838-4945-0961
Wa:083849450961 Jl. Utan Kayu Raya No.94, RT.12/RW.10, Utan Kayu Utara, Kec. Matraman, Kota Jakarta...
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers