Execute at source, and will generate an output with TSQL commands to create temp tables filled with top 50 long lasting queries from all databases.
Then execute output at destination and will do the same and show comparison of matching queries!!
2016-12-19 (first published: 2016-12-06)
875 reads
A column level check constraint may be used to prevent insertion of data containing characters within a specific ASCII range.
2016-12-12 (first published: 2016-11-30)
2,349 reads
Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpUnloadSelect.sql
Quick export to flat file.
Before use please enable xp_cmdshell.
2016-12-09 (first published: 2015-05-12)
2,372 reads
Stored procedure to transform a 'select' result set such that each column value is presented on a separate row.
2016-12-08 (first published: 2015-01-26)
2,425 reads
select top * from table by highlighting the fully qualified, including database, table, using a keyboard shortcut.
2016-12-07 (first published: 2015-05-07)
2,913 reads
2016-12-06 (first published: 2015-07-27)
2,525 reads
Will take a stored procedure and email the results in a dynamically generated embedded HTML table or as an attachment.
2016-12-05 (first published: 2015-05-29)
2,830 reads
Here's a script, for killing a SPIDs against a particular database, here am using BIN as the database.
2016-12-02 (first published: 2008-07-17)
1,818 reads
Truncating tables with constraints always had been a pain, since we have to drop and recreate all the FKs. I created a script that takes care of dropping and recreating the foreign keys while truncating. Please use with caution! and always respect your Data !
2016-12-01 (first published: 2016-11-28)
1,391 reads
2016-11-30 (first published: 2016-11-22)
812 reads
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Telp/Wa 62 821-8200-233 Jl. Raya Cilandak KKO No.9, RT.1/RW.5, Ragunan, Ps. Minggu, Kota Jakarta...
Telp/Wa 62 821-8200-203 Gedung Perkantoran Hijau Arkadia, Tower C - Ground Floor, unit C103,...
Telp/Wa 62 821-8200-174 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
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