Viewing 15 posts - 24,061 through 24,075 (of 49,552 total)
I'll tell Grant he's wrong. He'll agree with me.
The query optimiser costs were times at one point. They were benchmark times on a specific computer in the MS testing lab...
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
August 20, 2011 at 5:14 am
We don't do people's homework/exams for them.
You learn nothing if I give you the answer and I don't need a basic admin course.
For question 1, look in Book Online (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
August 20, 2011 at 4:34 am
Users can not change execution plans. An execution plan also can't fail.
Are you talking about execution plans (plans created by SQL to tell how to run a query) or maintenance...
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
August 20, 2011 at 4:29 am
RamSteve (8/19/2011)
"test to see we can add an index in a different database then the prime table...
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
August 20, 2011 at 3:35 am
If you mean execution plans, you can't do that on any version. Not that users can change plans, but SQL sure can.
Why don't you start by explaining what the problem...
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
August 20, 2011 at 3:34 am
Nope, and you definitely do not want autoshrink on ever.
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
August 20, 2011 at 3:28 am
Marios Philippopoulos (8/19/2011)
Default value is 5 sec; may be too low for most systems.
Setting it to higher values (say 15-20 sec)...
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
August 19, 2011 at 5:12 pm
Jeff Moden (8/19/2011)
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
August 19, 2011 at 5:12 pm
Leo.Miller (8/18/2011)
Can you point me to a document on this?
All I'll do is hit google. I'm sure that you can do that as well as I can.
The point to note...
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
August 19, 2011 at 5:08 pm
didier41 (8/19/2011)
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
August 19, 2011 at 12:30 pm
You don't need single user mode, and nothing in that set of steps will break the log chain.
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
August 19, 2011 at 11:50 am
Goes straight to graphical plan here, on same version of SSMS
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
August 19, 2011 at 9:28 am
Ninja's_RGR'us (8/19/2011)
(they're doing there immersion class.... I just hope she can read this DURING & in front of <the> class :-D)
Class finished yesterday. This is a 4-day one, 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
August 19, 2011 at 9:27 am
That's how SSMS 2005 behaves. Sure you're not running the wrong version by accident?
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
August 19, 2011 at 8:37 am
Something sounds broken there...
I've seen cases where the sp fails saying that the DB is not replicated, that's why I usually got the full route. Glad it worked for you.
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
August 19, 2011 at 8:34 am
Viewing 15 posts - 24,061 through 24,075 (of 49,552 total)