Skip to main content
Share Your Experience: Take the 2024 Developer Survey
lifeisajourney's user avatar
lifeisajourney's user avatar
lifeisajourney's user avatar
lifeisajourney
  • Member for 2 years, 1 month
  • Last seen more than a week ago
5 votes
2 answers
4k views

Select * Order by vs Select column Order by performance

4 votes
2 answers
784 views

Poorly performing stored procedure using cached data while testing

3 votes
1 answer
2k views

Adding a new column to a table that has more than 1 billion rows

3 votes
1 answer
218 views

XML vs UDF performance in SQL Server

3 votes
6 answers
4k views

Not equal to operator is not returning NULL values in SQL Server

2 votes
1 answer
91 views

Could not locate statistics in the system catalogs error in SQL Server

2 votes
1 answer
223 views

Stored Procedure Generating Multiple Plans for Different Parameters in SQL Server

2 votes
1 answer
2k views

Modify a JSON key value based on another key's value in SQL Server

2 votes
2 answers
1k views

Write Query to get 'x' number of rows in SQL Server

1 vote
1 answer
94 views

Creating a non-clustered index on clustering key with some columns included

1 vote
1 answer
233 views

Index Seek Results in More Logical Reads in SQL Server

1 vote
2 answers
132 views

Temp table with less number of rows results in Clustered Index Seek Whereas more rows result in Clustered Index Scan - SQL Server

1 vote
1 answer
2k views

Performance considerations when adding a new column to a big table in Sql Server

1 vote
1 answer
141 views

Write a query to get hierarchical data in SQL Server 2012

1 vote
0 answers
1k views

Best way to implement Pagination in SQL Server

1 vote
2 answers
3k views

What happens to an open transaction when the session window is closed?

0 votes
1 answer
350 views

Pagination solution increases the logical reads but decreases execution time

0 votes
0 answers
77 views

Rewrite a query to sort data in sql server

0 votes
0 answers
60 views

The configuration Option for a column is not unique error - sql server

0 votes
1 answer
2k views

Find an open transaction across any session and any database in SQL Server

0 votes
1 answer
50 views

Re-write a query in SQL Server 2012

0 votes
1 answer
723 views

Modify an existing non clustered index or create a new index in SQL Server 2012

0 votes
0 answers
65 views

Improve query performance in SQL Server 2012

0 votes
1 answer
2k views

Updates to the same table in concurrent sessions in SQL Server

0 votes
1 answer
426 views

Performance benefit of dividing a frequently used stored procedure into multiple stored procedures in SQL Server

0 votes
1 answer
1k views

Convert an Int column to BigInt in a stored procedure in SQL Server 2012

0 votes
1 answer
65 views

Delete million of rows from parent and child tables in SQL Server

0 votes
0 answers
23 views

Local variables and their impact on execution plans in SQL Server Stored Procedure [duplicate]

0 votes
2 answers
261 views

Replace multiple words in a single value using SQL

0 votes
1 answer
134 views

Inserting Multiple Rows into a Table and Mapping Newly Created IDs Back to Original rownum in Another Table - SQL Server