Hi I was running a Index reorg at the partition level on a table with 300GB data and that caused blocking issue since the lock got escalated to the...
Hi - We are calling a stored procedure on a linked server B through a synonym from server A.. like this.. exec @ret = dbo.SYN1 synonym...
hi - I have a very large partitioned table which i want to reindex on a weekly basis. It has got 20 partitions .....i want to reindex only those...
I want to know what the duration column on the SQL Profiler means. We are noticing a sp_executesql statement (which accepts a XML parameter) takes...
I'm trying to load data for a table from DB1 to DB2 using Transform Data task in DTS no of rows to be exported = 8 million Database recovery model is...
I have a sql server 2005 database with tables of varying size..from million rows to hundred rows. I want to reduce the maintanence window needed for...
I have this one stored proc which runs for a long time (10 min) in Staging environment but takes less than 5 minutes in Dev. Both these envionments...
Create table Test ( id1 int, col1 varchar(100) ) insert into test(id1,col1) values (1,'http://www.test.com/first.last') --there is a space at the...
Create table Test ( col1 varchar(100) primary key ) --line1 insert into test(col1) values ('http://www.test.com/first.last') --line2 - there is a...
Separate names with a comma.
