Viewing 15 posts - 6,316 through 6,330 (of 6,353 total)
are the commands just simple update statements that are being executed causing the deadlocks in the dl_7.xdl file?
do you have the full query batch around the deadlocking area?
the deadlock image...
June 20, 2011 at 9:52 am
The alter database works for TempDB, model and MSDB (and manually copy the files for model and MSDB to the new drive once SQL is stopped) but we always say...
June 20, 2011 at 5:46 am
If you do it via to GUI but dont hit OK, instead at the top, there should be a script button, hit the arrow then select where you will want...
June 20, 2011 at 5:32 am
There are a number of tools out there which can translate the transaction log for you into a GUI so you can see what happened and when
My personal favourite is...
June 20, 2011 at 4:58 am
do you use DTC anywhere in the applications?
we had an issue before where there was a never terminating DTC transaction ongoing and it wouldn't terminate by killing the spid and...
June 17, 2011 at 9:40 am
From the sounds of the discussion that was had, it sounded like they wanted the same OLTP DB to be running on both nodes to which I initialy said, hold...
June 8, 2011 at 9:18 am
Thanks that was my thought as well that it couldn't be done, just someone was saying they managed to do it before to which I thought was a bit strange.
June 7, 2011 at 3:38 am
Yeah I have moved on to powershell anyway, just didnt know if there was a quick way to change between DMO and SMO
June 7, 2011 at 12:28 am
ok so scripted all tables and views from the db using SSMS and searched for *= and =* to which brought back nothing.
as SQLDMO is no longer a feature in...
June 6, 2011 at 8:04 am
No I didn't look at calculated columns, will take a look and re-post.
June 6, 2011 at 7:58 am
Managed to get what I needed.
To do this, open up the DSV in BIDS, click on VIEW, CODE, this will then bring up the XML for the DSV and then...
May 20, 2011 at 2:48 am
I have seen this a number of times in relation to MSDTC and BizTalk, with one of the instances causing quite a significant problem in the live environment.
To get the...
May 18, 2011 at 2:09 am
I would like to thank Chris for this, it is excellent.
One question I have is how do you "UNDROP" from trash can.
Say we have 3 copies of the same table
zz_RecycleBin.Table1_20110411_1125
zzz_TrashCan.Table1_20110410_1426
zzz_TrashCan.Table1_20110409_1735
The...
April 12, 2011 at 6:53 am
Hi Gail
Thanks for this, unfortunatly the application which runs is only supported up to SP2 for SQL 2005 as the vendor hasnt got round to testing on their systems for...
April 5, 2011 at 1:33 am
to get around this issue i put event handlers on all of my DFT's and Execute SQL Tasks to log to a table when the task started and finished.
i managed...
March 2, 2011 at 5:43 am
Viewing 15 posts - 6,316 through 6,330 (of 6,353 total)