Hello All,I am getting a weird error. I am using SQL Server 2005 SP3.I googled it and could not find anything as it is only saying "Incorrect syntax...
Hi, In one of the query, Date/Time is converted as CONVERT(VARCHAR(11), CreateDate,101) and then compared (greater than) as below WHERE...
Hi, I just came across one scenario, In a stored procedure, where transaction isolation level is set to READ UNCOMMITTED at the beginning of the SP....
I am not sure how table valued function do well when it comes to performance. Or is there any specific performance benefit with table valued...
Approach 1: CTE ;With CT1 AS (Select A.ID AS A_ID from Tab1 A) , CT2 AS (Select B.ID AS B_ID from Tab2 B INNER JOIN CT1 ON CT1.A_ID = B.AID) , CT3 AS...
I have table, in which RTF documents are stored in Image Data type column. Now i need to convert this RTF data to plain text in readable format using...
I am just thinking if it is possible to derive multiple columns from single "SELECT CASE" statement. I mean, based one condition, can i add two...
I just came across one scenario, where JOIN was on derived table columns and two columns from this derived table query has index on it. This piece of...
When i run the cross join on huge tables, then obviously it takes time, But when i put this into UNION operation with one more query, which is...
I am working on one report problem, in which report did not come up in preview mode from visual studio 2005 and at the same time not from the...
I was just working on one performance issue and came across a strange point, which i am not aware. I got the statistics from prod environment for one...
Does it make any point to put temp table insert/update in transaction (BEGIN/COMMIT Tran)? I am not able to think of any such scenario however for...
I just came across one stored procedure, where sequence of definfing the transaction isolation level is as follows 1. Defined the transaction...
Can we re write below statement in any other different way? It is causing unnecessary Hash Match inspite of proper index. Select Tab1.Desc From...
Suppose, a temp table (#tmpCR) is created in one stored procedure and this temp table has 10 columns. Now, this temp table is referenced multiple...
Can we use Between operator with Char(1) datatype? Normally, i have used with numeric data only. Now, it is working but i think this approach is...
Assume a temp table which does not have any non clustered index on it and let's say two columns are updated multiple times in a SP, then if i define...
Hi, I came across a strang scenario, which is as below: One of the stored procedure was using table variable and referenced almost 20 times on the...
Hi, I am joining two tables on the clumns which are covered in non clustered index. Both the tables have clustered index. When i make left outer...
Assume the case below...
Separate names with a comma.
