Viewing 15 posts - 271 through 285 (of 2,840 total)
Both the test server and the production server is on the same version? Check if you can set the query timeout to some higher value.
BTW, looking forward to next...
October 19, 2011 at 10:21 am
Having everything going through the same IO controller is not the best way to go into it. If you could, you should try to give different IO path for Data,...
October 19, 2011 at 10:00 am
Cant we please leave the pants alone?
The Thread is not going to like all the pants.
October 18, 2011 at 1:50 pm
The only method that comes to my mind is a Server side trace that watches for the objectID. But that can also be manipulated by a SysAdmin.
October 18, 2011 at 12:07 pm
The only way I know of to get the Audit information into DB is to import it manually into a DB.
October 18, 2011 at 12:04 pm
Dealing with a third party is a tricky business. They might have a clause stating that if you do any change on the DB, they will not support the product....
October 18, 2011 at 11:58 am
Merge I do not think will work with LinkedServer. Thats what I know
October 18, 2011 at 11:43 am
You could always try using the Upsert method. That is Update first and check if @@rowcount is zero. If it is 0 then do the insert. This will help if...
October 18, 2011 at 9:14 am
It wont throw any error on any log if it is in any pending state. The advice provided by MSDN is to make sure that the Distribution agent and log...
October 18, 2011 at 8:57 am
Jeff Moden (10/18/2011)
bitbucket-25253 (10/17/2011)
Thanks for all you have done to...
October 18, 2011 at 8:39 am
Take a look at SQLStress. That can do quite a bit of stuff.
SQLIOSim from Microsoft is also good as Geoff mentioned.
October 18, 2011 at 8:02 am
Jack Corbett (10/17/2011)
SQLRNNR (10/17/2011)
Evil Kraig F (10/17/2011)
October 17, 2011 at 2:20 pm
Back to work after the summit. It was a pleasure to meet everyone there. I had a blast. Once again Jeff, Johan and me did some sight seeing together on...
October 17, 2011 at 7:13 am
I am at the Presentation of Steve jones for the sql pass. MS supported event and guess what laptop Steve is using? An Apple.. 😀
October 13, 2011 at 11:04 am
Redgate is sending a DBA to space. And somebody just tweeted asking if it was Grant "The Mon***" who was going to space. 🙂
October 12, 2011 at 11:15 am
Viewing 15 posts - 271 through 285 (of 2,840 total)