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,412 reads
Scripts
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,383 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,126 reads
2012-03-26 (first published: 2008-01-23)
3,259 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,697 reads
Split Function to break the Job History Message into a Table
Split Function for T-SQL Server to break the Job History Message into Table.
2012-03-22 (first published: 2012-03-05)
1,099 reads
Session complete status and estimated completion time
A small retake on the popular percent complete script which tell how much more time an executing command will take.
2012-03-21 (first published: 2012-03-07)
1,636 reads
Select the last error in the job selected
The job will send an HTML email with the latest error at specific job.
2012-03-15 (first published: 2012-03-05)
918 reads
Fix SSRS Subscription Owners
Stored procedure to update SSRS Subscription owners to avoid email errors.
2012-03-13 (first published: 2012-02-28)
1,473 reads
Get Top Queries Taxing SQL Server CPUs
Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.
2012-03-10
2,894 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Alamat BCA KCP Cilandak KKO I Telp/Wa:0821-8200-233
Telp/Wa 62 821-8200-233 Jl. Raya Cilandak KKO No.9, RT.1/RW.5, Ragunan, Ps. Minggu, Kota Jakarta...
Alamat BCA KCP Arkadia Telp/Wa:0821-8200-203
Telp/Wa 62 821-8200-203 Gedung Perkantoran Hijau Arkadia, Tower C - Ground Floor, unit C103,...
BCA KCU KUNINGAN Telp/Wa:0821-8200-174
Telp/Wa 62 821-8200-174 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
Question of the Day
Adding new column with DEFAULT
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers