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...
SP2..3042 We opened a case with MS. They said this issue will be fixed in SP3.
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...
Tran log growth is cool since I'm using simple recovery model. CUP util / memory availability all looks good. I ran into different kind of errors:...
package logging didn't help.
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 changed NOT EXISTS used in the query to LEFT JOIN. It works in less than a minute. Thanks for your help!
Allright..here are the results<br /><br />DEV<br />***<br />Table 'one'. Scan count 1, logical reads 20, physical reads 0, read-ahead reads 20.<br...
That shouldn't be a factor since I tested both the DEV & STAGING backups in the same local box.
I did check that..same no of rows. <img src='/community/emoticons/emotion-6.gif' alt=':(' />
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...
Thanks !
Thanks very much !
Enter the return code as 0 in the 'Execute process task'
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.
