Viewing 15 posts - 5,341 through 5,355 (of 9,722 total)
Kurt W. Zimmerman (8/12/2011)
Brandie Tarvin (8/12/2011)
Any OS service packs? Any SQL Server hot fixes / SPs? Any...
August 15, 2011 at 5:52 am
Kiara (8/15/2011)
SQL Kidd (8/12/2011)
I totally get you and agree with you! Let me be even more brutally honest with you. I loathe technology! At best my heart can be...
August 15, 2011 at 5:49 am
To ditto everything everyone else has been saying to you...
Two months to get a cert?? You do realize how many exams are involved in getting certification, right? It's not just...
August 15, 2011 at 5:44 am
Kurt W. Zimmerman (8/12/2011)
Any script I run through DTA comes back with the same results.... IE no recommendations and yet Estimated Improvement: 99%.
And being totally snarky (forgive the humor during...
August 12, 2011 at 12:16 pm
What changed between the time it was providing results and the time it stopped?
Any OS service packs? Any SQL Server hot fixes / SPs? Any major issues with your database(s)?
August 12, 2011 at 12:14 pm
Is some other process going in and clearing off space from that location by deleting files it thinks are archived?
Are your older logs in the same location as the current...
August 12, 2011 at 11:30 am
To add a note on the current answers, REPLICATE() is a wonderful function. So is STUFF(), though STUFF() will actually replace an existing character, so be careful.
You can use them...
August 12, 2011 at 11:23 am
Another place to check is the usual assortment of certification books. They often have tutorials you can walk through yourself in how to use the various tools in SQL Server.
August 12, 2011 at 11:19 am
You're correct. The definition in BOL is pretty much identical, word for word, except for a final statement in the Insensitive part:
When ISO syntax is used, if INSENSITIVE is omitted,...
August 12, 2011 at 11:18 am
Ditto on the SSIS package. You can create it easily enough (aside from the learning curve), then schedule it with a job to run automatically.
If the other system is behind...
August 12, 2011 at 11:14 am
I'm a little confused by your post. Have you run other procs through DTA and gotten different results or do all your attempts to use DTA end up with no...
August 12, 2011 at 11:11 am
Steve Jones - SSC Editor (8/12/2011)
- work in a complex development environment that does automated builds at high volumes (> 1x day)
-...
August 12, 2011 at 10:33 am
Have you checked SP_WHO2 while this is going on to see what the SPID of the blocking process is?
Here's the code I use to see what the details of a...
August 12, 2011 at 8:16 am
That's definitely one approach. Not knowing what your environment is like, I can't say for certain that it will help you narrow down the problem, but it's a good idea...
August 12, 2011 at 8:10 am
Stefan Krzywicki (8/12/2011)
Funny, we've been going to Worldcon for years, but we skipped last year because Australia was too expensive and we're not going this year because it is in...
August 12, 2011 at 7:56 am
Viewing 15 posts - 5,341 through 5,355 (of 9,722 total)