Viewing 15 posts - 16 through 30 (of 314 total)
Yes the courses should give you insight into things that you do not work with on a daily basis, however if you do not continue to use these new skills...
March 31, 2011 at 11:11 am
TheSQLGuru (3/31/2011)
2) do a waitstats analysis during the run to find out which waits are causing slowness
3) do a...
March 31, 2011 at 8:27 am
Ninja's_RGR'us (3/30/2011)
... and Gail is the one I would call to save my life with a problem like this. Can't ask for a better consultant.Good luck!
+1
March 30, 2011 at 7:53 am
I agree with the statements about the catch-all query...
From past experience, we had a couple of search queries that were created with a generator of some sorts that basically...
March 23, 2011 at 8:48 am
Let us know how you get on and the chosen solution... I never got to implement the negative numbers option, was never given the time to do it.
March 23, 2011 at 8:26 am
Do you have any experience on the DBA side?
Which do you prefer?
If no experience, its normally relatively difficult to get your first full DBA position. Most companies only...
March 23, 2011 at 8:21 am
and try this instead:
and AH.DESCRIPTION LIKE '%' + 'Found software item ' + S.DISPLAY_NAME + ' ' + S.DISPLAY_VERSION + '%'
March 23, 2011 at 7:54 am
If you re-write the query and move the WHERE clauses up to the JOIN statement (like they should be in SQL :-)) it might make it a lot easier to...
March 23, 2011 at 7:50 am
Depending on what unique keys you use, we used to use identities, there is the option of using a range of numbers that would never be used... like negative numbers....
March 23, 2011 at 3:37 am
we used to have "refreshes" of test environments scheduled by the PM (and test team) well in advance so that they were aware of the change that was coming.
IT...
March 22, 2011 at 10:54 am
We could suggest 100 things, but they could all be for nothing on your system. You need to give us a LOT more detail about what is not performing, how...
March 22, 2011 at 4:24 am
trstringer (3/21/2011)
March 22, 2011 at 4:13 am
Ninja's_RGR'us (3/21/2011)
grahamc (3/21/2011)
I have worked in South Africa,...
March 22, 2011 at 4:06 am
Sort of along the original lines of the thread topic, but whats the contract job market in Toronto like for SQL DBAs?
I have worked in South Africa, England and...
March 21, 2011 at 9:52 am
There is something fundaMENTALLY wrong, if the best (most enjoyable) way to keep your mind active, is SQL Server :hehe:
Given the chance, I would be out in the mountains,...
March 21, 2011 at 8:18 am
Viewing 15 posts - 16 through 30 (of 314 total)