It is a tiny query in size but can play a crucial role to avoid overhead, caused due to missing SET NOCOUNT ON definition in the stored procedures and triggers. Read more about SET NOCOUNT here. Here are few useful articles talking about why it's important to add SET NOCOUNT ON. SET NOCOUNT ON Improves … Continue reading Query to list all the procedures and triggers not having SET NOCOUNT ON defined
Author: Brahmanand Shukla
T-SQL query to find the list of objects referring Linked Servers
T-SQL query to find the list of objects referring Linked Servers
T-SQL script to find hierarchy of tables – Row-wise result
As I promised in my previous post T-SQL script to find hierarchy of tables – Columnar result – SQL Server Carpenter, here is another version of the query to get the hierarchy of tables in the form of rows. ; WITH cte_Hierarchy_Of_Tables AS ( SELECT A.[name] AS [Parent] , A.[object_id] AS [Parent_Object_ID] , A.[name] AS … Continue reading T-SQL script to find hierarchy of tables – Row-wise result
T-SQL script to find hierarchy of tables – Columnar result
One of my LinkedIn connection reached out to me for help, to find the hierarchy of all the tables in a database. He was in dire need of some help, since there are around 250 tables in his database, and he need to write delete script to delete data requested by his team. As we … Continue reading T-SQL script to find hierarchy of tables – Columnar result
Game changer settings # MAXDOP and Cost threshold for parallelism
I got a performance tuning assignment for an esteemed customer in the Financial Services domain. I went through the wait stats of SQL Server using the built-in SQL Server Report, called Performance Dashboard. I found CPU – Parallelism referred to as CXPACKET was leading the list, followed by Buffer IO, Lock, and Latch. Parallelism in SQL Server refers to two settings – MAXDOP and Cost threshold … Continue reading Game changer settings # MAXDOP and Cost threshold for parallelism