Viewing 15 posts - 5,341 through 5,355 (of 9,726 total)
You're welcome. Let us know if you have any additional questions on this subject.
Or other subjects, which can be posted as other threads. @=)
August 15, 2011 at 6:10 am
Sqlsavy (8/15/2011)
Is it possible to backup log on Principle server? will that not break the Mirror?
Because I thought in high-safety method...
August 15, 2011 at 6:09 am
Knowing the blocked query doesn't help you. Any query could be blocked. What you need to know is the details of the blocking query (the one that is stopping the...
August 15, 2011 at 6:04 am
Calm down. We're trying to help. Panic doesn't do anything for you but enable you to ignore what we're saying.
Yes, error logs cycle on their own without a restart. It's...
August 15, 2011 at 6:00 am
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
Viewing 15 posts - 5,341 through 5,355 (of 9,726 total)