Viewing 15 posts - 6,031 through 6,045 (of 49,552 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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 7, 2015 at 2:25 am
RonKyle (5/6/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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:...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2015 at 9:33 am
Steve Jones - SSC Editor (5/5/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2015 at 9:27 am
RonKyle (5/5/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2015 at 7:10 am
Grant Fritchey (5/5/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2015 at 7:06 am
Viewing 15 posts - 6,031 through 6,045 (of 49,552 total)