SQL Server & Data

I found some interesting article to share in regards of joining the UDF into your join which ends up in executing the UDF as many as number of records being joined to. The solution is to…

The default template in SQL profiler doesn’t trace the dynamic SQL executed by the stored procedure. In order to trace the Dynamic SQL, you need to turn on these 2 options in your tracing profile SP:stmtstarting…

Below is the sample in how to reproduce a recursive parent-child relationship and how to find out which records are the troublesome one CREATE TABLE RecursiveSample ( REF INT NOT NULL, PARENT_REF INT NOT NULL, NAME…

How to simulate Deadlock in SQL Server, pretty simple 1. Create a table CREATE TABLE MyDeadlockTable ( REF INT PRIMARY KEY NOT NULL, NAME VARCHAR(255) ) GO 2. Populate a table with the record INSERT INTO…

I have a web app that recently timing out and the timing out exception is actually coming from the SQL Server. When I run the execution plan I found that there is one item called Table…

This is just an information for the users that might not know this feature in SQL Server Management Studio, eventhough I’m sure most of people should have known this feature Basically SQL Server stores all the…

The usage of PIVOT keyword In SQL Server we can transform a horizontal rows to be vertically represented by using Pivot Keyword Run this query to have sample data CREATE TABLE OrderItems(Order_No INT, ProductName VARCHAR(255), TotalQty…