Viewing 15 posts - 8,761 through 8,775 (of 22,214 total)
Abu Dina (3/6/2014)
March 6, 2014 at 11:09 am
Abu Dina (3/6/2014)
March 6, 2014 at 9:14 am
Just backing up what's been said. You can get extremely granular on the security, and I'd get as granular as possible. If you can, limit all access to the data...
March 6, 2014 at 7:58 am
Usually, but not always, ASYNC_IO_COMPLETION is caused by client side slow downs. The secondary cause is from network processes. But, in this case, it sounds like an issue with the...
March 6, 2014 at 7:55 am
Ed Wagner (3/6/2014)
MysteryJimbo (3/6/2014)
Ed Wagner (3/6/2014)If you've ever driven in the Great Smokey Mountains or especially the Rocky Mountains, it is absolutely beautiful, but it is anything but straight and...
March 6, 2014 at 6:55 am
Deadlocks are fundamentally a performance problem. So, yes, indexing may help. It's hard to say without all the specifics of your code and structures, but it's pretty likely. You'll also...
March 6, 2014 at 4:47 am
We had a situation where we needed to provide a database for testing and development that matched production, but, didn't have sensitive data (trust me, you want to clean up...
March 6, 2014 at 4:45 am
It's not about what the 'sa' account has access to. It's about what the account that SQL Server is running under has access to. That account determines what can be...
March 6, 2014 at 4:36 am
MysteryJimbo (3/6/2014)
Koen Verbeeck (3/6/2014)
MysteryJimbo (3/6/2014)
Koen Verbeeck (3/5/2014)
Pfff, than you have never been in Belgium before 😀
If we wouldn't be having the most traffic jam congested cities in the world, you...
March 6, 2014 at 4:31 am
Ran into this again, 6 years later. Glad I asked this question online so I could find the answer again.
March 5, 2014 at 12:21 pm
Jacob Pressures (3/5/2014)
So you guys suggest I should avoid that syntax? OkI got it from doing debug on the following statement:
EXEC sp_help;
GO
Ha! Awesome. That would explain why it's not...
March 5, 2014 at 12:05 pm
It's a non-standard use though. I don't know that I'd actively rewrite everything I found that way, but I'd certainly discourage any new code being written like that.
March 5, 2014 at 10:23 am
I'm pretty sure it has the same requirements as distributed replay. You can see the events and columns you'll need to capture here.
March 5, 2014 at 10:22 am
yuvipoy (3/5/2014)
So u mean to sayDelete from main_table where id=some_input;
Delete from Child_table1 where id=some_input;
Delete from Child_table2 where id=some_input;
Delete from Child_table3 where id=some_input;
Commit tran;
Nope, you have to do it the...
March 5, 2014 at 10:12 am
hlsc1983 (3/5/2014)
Sean Lange (3/5/2014)
hlsc1983 (3/5/2014)
In my database i wanted to include a...
March 5, 2014 at 8:33 am
Viewing 15 posts - 8,761 through 8,775 (of 22,214 total)