Viewing 15 posts - 6,031 through 6,045 (of 49,571 total)
Boot camps aren't about training. They're about cramming enough knowledge to pass the cert exam at the end. Retaining knowledge afterwards is not required.
If you want week long training courses,...
May 7, 2015 at 2:25 am
RonKyle (5/6/2015)
May 6, 2015 at 7:53 am
RonKyle (5/6/2015)
Can't this be overcome by explicitly dropping the temp tables in the connection.
Why do you want to bypass a feature that's designed to reduce contention on the TempDB...
May 6, 2015 at 7:35 am
And this is a few days too early for me to reference an editorial on using the scientific method when writing blog posts, so I'll just make comments instead.
LIKE Operator:...
May 6, 2015 at 6:28 am
Unless you had some form of auditing in place at the time the insert was done, you're probably not going to be able to find anything out. The default trace...
May 6, 2015 at 3:32 am
Restore from a backup, I don't think that's fixable.
If you don't have a backup, script out what you can (with the DB in emergency mode), export what you can and...
May 6, 2015 at 3:16 am
SQL will try to grow the log file. If it can't any data modification that runs will get error 9002 and fail.
You've probably got a tiny autogrow set, so the...
May 5, 2015 at 9:33 am
Steve Jones - SSC Editor (5/5/2015)
May 5, 2015 at 9:27 am
RonKyle (5/5/2015)
May 5, 2015 at 8:55 am
RonKyle (5/5/2015)
Running a CHECKDB is only possible when the backup is restored to the test environment. Less than optimum.
Personally that's my preferred way of doing it on large,...
May 5, 2015 at 8:37 am
RonKyle (5/5/2015)
As a minimum it can allow for the separation of tables and indexes to separate disks and doesn't prevent using standard backup and restore procedures.
Yes, you can do that....
May 5, 2015 at 8:06 am
User-defined functions.
http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan/
Or, looking at the duration stats...
Could be different plans. Management studio uses different set options to what most apps use, so running the query from SSMS may have generated...
May 5, 2015 at 7:49 am
RonKyle (5/4/2015)
But if the filegroup would become corrupt, I've made it harder to recover.
Not necessarily. Depends on the type of corruption. If the system tables get hit, that's a full...
May 5, 2015 at 7:36 am
SimonH (5/5/2015)
"not whether someone thinks their crystal ball is better than yours"I'm thinking its more of a case of this.
It is (I have a couple of those types of devs...
May 5, 2015 at 7:10 am
Grant Fritchey (5/5/2015)
May 5, 2015 at 7:06 am
Viewing 15 posts - 6,031 through 6,045 (of 49,571 total)