How important it is to defrag Non Clustered indexes?
Me and my colleague were discussing the defrag activity and I was of the opinion that we...
I have a simple update statement like
Set Col1 = val1, col2 = val2, col3 = val3
where TablePK = Val
The table in question has...
I have a select statement in which I use table variable(with a PK) inner Join a table inner join a materialized view inner join a table left...
Can you please tell me if there's a way to debug a user defined data type code (.vb or .cs).
I have gone through this MS post...
i have a query like
Select Col1 , col2 , dbo.func1(col3), dbo.func2(col4)
from table1 t1 inner join table2 t2 on t1.col = t2.col
I'm plannig to...
I have a made a full text index on column in a table having only 2 cols in all(one phrase(varchar(4000)) and second Id).
Now i want to change...
I have a table with 35 columns and i have to maintain an audit trail of a couple of columns out of those.so i made a AFTER UPDATE,INSERT trigger...
i have a procedure with a query havin 3 inner joins in which i have used the syntax
table1 tbl1 inner join table2 tbl2 on tbl1.col1 = tbl2.col1...
Separate names with a comma.