Viewing 15 posts - 9,556 through 9,570 (of 49,552 total)
Fragmentation has nothing to do with whether you get a seek or a scan. A seek requires that you have a where clause, something to search on. If you are...
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
March 24, 2014 at 3:18 pm
No, freeproccache is not a substitute for updating statistics, but the stats needed updating when you actually upgraded the database to SQL 2012, i.e. when it was first attached to...
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
March 24, 2014 at 3:16 pm
Ed Wagner (3/24/2014)
Lynn Pettis (3/24/2014)
I don't know why, but this sort of thing scares me.
WOW! Now that's enough to scare anyone. Just think...he has access to the server....
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
March 24, 2014 at 3:14 pm
Lynn Pettis (3/24/2014)
I don't know why, but this sort of thing scares me.
And he sent me a PM asking if I'd assist with getting the system back up and running....
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
March 24, 2014 at 3:11 pm
hwp (3/24/2014)
Thank you for the reply. The hard drive that crashed was actually the DATA drive.
If you've lost the data drive and you have no usable backups, you're pretty...
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
March 24, 2014 at 3:06 pm
Please post table definitions, index definitions and execution plan.
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
March 24, 2014 at 8:19 am
It's not something that has 'small' examples. Spend some time reading up on resource governor (Books Online has a fair bit, there's a whitepaper iirc as well), test out in...
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
March 24, 2014 at 5:50 am
You're mixing up ANDs and ORs without having any brackets to specify the precedence of the operators. Unless otherwise specified (by brackets) AND takes precedence over OR
Without brackets, this is...
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
March 24, 2014 at 4:51 am
Because sp_recompile does not cause a recompile (when run against a procedure). It removes the plan entirely from cache so that it has to be compiled from scratch on 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
March 24, 2014 at 3:48 am
MysteryJimbo (3/24/2014)
You can use something like this and check the usage count, it will reset if recompiled.
It'll reset if the plan is removed from cache and compiled again from scratch,...
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
March 24, 2014 at 3:14 am
Just bear in mind that OPTION(RECOMPILE) has other effects as well. It allows 'parameter sniffing' on variables, it can result in a row estimate for table variables which is not...
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
March 24, 2014 at 2:56 am
Not directly.
You can configure Resource Governor and create pools and resource groups and set limits, but it's far from perfect.
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
March 24, 2014 at 2:30 am
Please post table definitions, index definitions and execution plans as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
March 24, 2014 at 2:22 am
Go to the page on the Microsoft Learning site for the exam, check the skills measured. That's the official list of what they can test you on in that test.
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
March 23, 2014 at 6:55 am
What exactly is the issue?
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
March 22, 2014 at 2:02 pm
Viewing 15 posts - 9,556 through 9,570 (of 49,552 total)