|
|
-
Roji Thomas Commented 9 Months ago through Blogs
Thanks.
Couple of points need clarification.
1. Using the sys.dm__tran__locks to inspect the lock requirements may not yield the desired result since the DMV only gives a point in time snapshot of the locks. To see and understand what locks are ...
|
-
Roji Thomas Liked 9 Months ago through Just Learned
In SQL Server 2008, We have a feature to select multiple lines with specific characters.
In SQL Server 2012, we can append the same text to multiple lines.
Below images will give the clear picture to understand this feature.
Some times we need to ad...
|
-
Roji Thomas Learned 9 Months ago through Just Learned
In SQL Server 2008, We have a feature to select multiple lines with specific characters.
In SQL Server 2012, we can append the same text to multiple lines.
Below images will give the clear picture to understand this feature.
Some times we need to ad...
|
-
Roji Thomas Liked 9 Months ago through Just Learned
In SQL Server 2008, We have a feature to select multiple lines with specific characters.
In SQL Server 2012, we can append the same text to multiple lines.
Below images will give the clear picture to understand this feature.
Some times we need to ad...
|
-
Roji Thomas Learned 9 Months ago through Just Learned
In SQL Server 2008, We have a feature to select multiple lines with specific characters.
In SQL Server 2012, we can append the same text to multiple lines.
Below images will give the clear picture to understand this feature.
Some times we need to ad...
|
-
Roji Thomas Commented 9 Months ago through Blogs
Below is the (incomplete) list of locks required to run a REORGANIZE on a Non Clustered index. Apart from the locks listed, there may be other METADATA lock requirement based on the security context of the executing user and features like Auditing and t...
|
|
|
-
Roji Thomas Posted 9 Months ago through Syndicated Blogs
Jes Schultz Borland (b|t) from Brent Ozar PLF recently blogged about Identifying and Correcting SQL Server Implicit Conversion. Jes’s post discuss about how data type mismatches on the join and filter predicates cause performance issues and how to resol...
|
-
Roji Thomas Commented 9 Months ago through Blogs
Thanks Madhi. Trying to be bit more active these days.
I'll also offer couple of solutions.
DECLARE @i INT = 987654321
DECLARE @c VARCHAR(250) = CONVERT(VARCHAR, @i)
SELECT @c = REPLACE(@c,n,REPLICATE('*',n))
FROM (SELECT TOP 10 ROW_NUMBER() ...
|
-
Roji Thomas Liked 10 Months ago through Tutorials
This tutorial will help you learning SQL Server Profiler...
|