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...
We are calling a stored procedure on a linked server B through a synonym from server A.. like this..
exec @ret = dbo.SYN1
We opened a case with MS. They said this issue will be fixed in SP3.
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 very much !
Enter the return code as 0 in the 'Execute process task'
Create table Test
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
insert into test(col1) values ('http://www.test.com/first.last')
--line2 - there is a...
Separate names with a comma.