Viewing 15 posts - 2,461 through 2,475 (of 5,685 total)
patrickmcginnis59 (10/13/2011)
Not sure what a thread abduction is. Ready to learn though!
Must admit, that's kind of funny, considering your later comment about things being common on the internet. Definately...
October 13, 2011 at 6:14 pm
patrickmcginnis59 (10/13/2011)
I was just offering an honest opinion of what I saw as an area of improvement.
Ah, nothing like a good thread abduction to attempt to make a statement....
October 13, 2011 at 4:32 pm
ryanchill (10/13/2011)
I've looked at table partitioning but not exactly sure how to implement it because all the examples I've seen is by range, not...
October 13, 2011 at 4:09 pm
mmmm....
I must admit Miss Friday is an excellent choice Brad. Definately a pleasant distraction.
October 13, 2011 at 3:47 pm
SQLRNNR (10/12/2011)
Ninja's_RGR'us (10/12/2011)
Roy Ernest (10/12/2011)
Redgate is sending a DBA to space. And somebody just tweeted asking if it was Grant "The Mon***" who was going to space. 🙂
That's got to...
October 12, 2011 at 3:37 pm
Amanda Bates-348384 (10/12/2011)
I'm wondering how other DBA team leads use their time.
When I do it, it resembles something about headless poultry, however, I'll attempt to assist... 😀
Recurring Management Meetings ...
October 12, 2011 at 3:29 pm
SQL Stud (10/11/2011)
IT depends... lol! If you can afford to read data that may not be commited yet, in favor of not locking the table and thus improving performance, then...
October 11, 2011 at 12:35 pm
There's only one scenario I can think of that using NOLOCK is 'safe'. A warehouse that has once a day updating and nothing is run during the update times,...
October 11, 2011 at 12:27 pm
As Lowell mentioned, you need an explicit transaction. Start with BEGIN TRANSACTION in Books Online to get an idea of what he's referring to. OUTPUT clause will help...
October 11, 2011 at 12:19 pm
Going to need a bit more to be able to help you understand why you're getting NULLS in Column A.
For starters,the query you're using. If you can turn that...
October 11, 2011 at 12:16 pm
Gah, there's no way I'm letting that loose on one of my development servers to test it. 🙂 Almost all my instances are overwhelmed.
What's the actual error you're getting?
October 10, 2011 at 5:32 pm
Perry Whittle (10/10/2011)
What horrifies me is that general users are able to backup and retrieve the companies data :w00t:
That shouldn't horrify you. In most places you can download reports...
October 10, 2011 at 5:30 pm
Fal (10/10/2011)
But wait! There is a logic bug in Craig's code: "SELECT AwakeStat FROM tblTargets WHERE fname = 'Sean'" might return NULL.
Oh, yeah, that one. That's in case...
October 10, 2011 at 5:08 pm
tgarland (10/10/2011)
Hey Craig,I would be more than happy to try and answer your question.
Thank you very much.
I agree with you completely about the importance of the relationship between the engine...
October 10, 2011 at 4:56 pm
banerji.uddipto (10/10/2011)
October 10, 2011 at 4:35 pm
Viewing 15 posts - 2,461 through 2,475 (of 5,685 total)