2015-09-10 (first published: 2014-05-08)
4,871 reads
Scripts
Physical Server or a Virtual Machine?
Simple T-SQL Script to know whether your SQL Server is running on a Physical box or a VM.
Note: This Script works only on 2008R2 SP1 and above.
2015-09-09 (first published: 2014-05-22)
4,809 reads
Create MERGE statements with data!
A script to create MERGE statements with data for specific tables.
2015-09-03 (first published: 2014-05-19)
5,204 reads
SQL Server Performance Base Line Script
Performance Base Line Report from SQL Server DMVs and Perfmon counters
2015-09-02 (first published: 2013-02-04)
17,228 reads
Block altering indexed views.
Altering an indexed view will drop all indexes on it without warning, even if nothing is changed.
This will prevent accidental alters.
Script is divided into 4 parts, included testing and cleanup scripts.
2015-09-01 (first published: 2015-08-13)
995 reads
Registered server documenter
Returns server and instance information via a registered server query, regardless of SQL version.
This script is more of how to get the data, and not so much about the data returned by my choice of columns.
Tested on 2008+
2015-08-28 (first published: 2015-08-07)
1,369 reads
Retrieving XML data to Table from dm_os_ring_buffers
Retrieving XML data to Table from dm_os_ring_buffers for better readable purpose
2015-08-27 (first published: 2015-08-03)
995 reads
Generate Login Script(2008R2 And Older)
Generate Script from Logins of Sql Server to recreate in another instance
2015-08-25 (first published: 2015-08-10)
1,751 reads
Cleanup Older than 30 days of Files & Folder through SQL Job
Using Powershell, Cleanup Older than 30 days of Files & Folder through SQL Job
2015-08-24 (first published: 2015-08-04)
2,624 reads
Query to Delete all Folders, Sub-Folders and Files located in a Path
A script to help you cleanup Files/Folders & Sub-folders.
2015-08-20 (first published: 2015-07-30)
79 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Alamat BCA KCP Menara Imperium Telp:0821-8200-233
Telp/Wa 62 821-8200-233 Jl. H. R. Rasuna Said No.Kav. 01, RW.6, Guntur, Kecamatan Setiabudi,...
Alamat BCA KCP Sejati Mulia Telp:0821-8200-203
Telp/Wa 62 821-8200-203 Koperasi Sejati Mulia, Jl. Raya Ragunan B 1, RT.3/RW.3, Jati Padang,...
Alamat BCA KCP Graha Inti Fauzi Telp:0821-8200-174
Telp/Wa 62 821-8200-174 Gd. Graha Inti Fauzi, Jl. Buncit Raya No.22 Lt. Dasar, RT.2/RW.7,...
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