2015-10-16 (first published: 2013-05-30)
5,749 reads
Scripts
Figure out the Blocking issue
This script will help you to get the culprit along with IP address and User name which helps us to determine the Blocking root cause.
2015-10-14 (first published: 2013-12-08)
4,443 reads
List all tables and their respective information.
List all tables in a SQL Server database with the details of them.
2015-10-13 (first published: 2013-02-20)
4,588 reads
Get IP Addresses of all Hostnames using SQL Server
To get the IP addresses of Multiple hostnames from below stored procedure.
2015-10-12 (first published: 2013-04-17)
5,825 reads
2015-10-09 (first published: 2014-03-21)
5,023 reads
2015-10-08 (first published: 2015-07-02)
1,113 reads
2015-10-07 (first published: 2015-09-18)
1,641 reads
Migrate existing DB Mail Exchange Configuration with New
Sometime due to the heavy load in Exchange servers we received configuration alerts notifications and report delay and that time it is require to move to some other exchange servers to full fill the requirement during the critical periods.
2015-10-06 (first published: 2014-12-19)
1,123 reads
Capture the tasks performed in a text file
Creates a record of all or part of a Windows PowerShell session in a text file.
2015-10-02 (first published: 2015-09-17)
1,147 reads
2015-10-01 (first published: 2015-09-13)
1,942 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