Read SQL Server Logs with TSQL
This is a small script designed to read the Contents of the SQL Server log based on None or more criteria.
2016-12-30 (first published: 2016-12-13)
926 reads
Scripts
T-SQL implementation of FizzBuzz
A T-SQL implementation of FizzBuzz consisting of a single SELECT statement.
2016-12-28 (first published: 2016-12-15)
961 reads
Query Performance comparison between instances
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)
881 reads
Check constraint to prevent insertion of invalid characters.
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,352 reads
Dynamic sql for convert SQL statement to txt/csv file
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,379 reads
Unpivot SQL Select Data
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,432 reads
Keyboard shortcut to select top 1000
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,918 reads
2016-12-06 (first published: 2015-07-27)
2,525 reads
Email SP Results
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,837 reads
Kill SPIDs through automated job(while restore)
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,820 reads
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Forums
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers