Viewing 15 posts - 28,696 through 28,710 (of 49,552 total)
I was planning to cover all that when I rewrite the 'managing transaction logs' article. Don't have a planned time on starting that though.
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
December 30, 2010 at 2:31 pm
Indianrock (12/30/2010)
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
December 30, 2010 at 2:29 pm
Nothing unusual about the memory, SQL loves memory, it will use as much as it can get. Be sure to limit the max memory so that the OS has some...
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
December 30, 2010 at 1:16 pm
Steve Jones - SSC Editor (12/30/2010)
Steve doesn't have horses. Steve's wife has horses, Steve loves his wife, Steve has to deal with horses.
The burdens that we must bear... <martyred expression>
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
December 30, 2010 at 1:14 pm
Please post new questions in a new thread. Please include execution plans, index definitions and table definitions.
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
December 30, 2010 at 1:13 pm
Craig Farrell (12/30/2010)
GilaMonster (12/30/2010)
Craig Farrell (12/30/2010)
It appears this article caused him to *start* a blog. So, probably best to hit the dampers early on him.
I noticed. 🙁
In that case...
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
December 30, 2010 at 1:10 pm
Don't just go and implement them. DTA's a pile of junk most of the time.
Take each recommendation. Test it. See if it improves the report and does not degrade anything...
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
December 30, 2010 at 12:25 pm
Langston Montgomery (12/30/2010)
GilaMonster (12/30/2010)
Langston Montgomery (12/29/2010)
(since, as we know, the data is physically stored in the same order as the clustered index)?Myth, not true.
Care to elaborate?
Sure.
The clustered index...
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
December 30, 2010 at 12:22 pm
Stefan Krzywicki (12/30/2010)
Does this only apply to WHERE or does it also apply to ON?
Applies to both (kinda).
If I have two tables joined thusly
ON A.CafeNumber = B.CafeNumber
AND A.PosNumber = B.PosNumber
WHERE...
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
December 30, 2010 at 12:11 pm
SQL automatically runs a checkpoint on the databases on a regular basis.
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
December 30, 2010 at 12:04 pm
Restore from a clean backup, there's no repair for this.
The problem is somewhere in the IO subsystem. Something (operating system, drivers, firmware, SAN controller, etc) is damaging the file. 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
December 30, 2010 at 12:02 pm
Craig Farrell (12/30/2010)
It appears this article caused him to *start* a blog. So, probably best to hit the dampers early on him.
I noticed. 🙁
In that case maybe a polite...
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
December 30, 2010 at 11:58 am
Stefan Krzywicki (12/30/2010)
I was afraid of that about the column order. I didn't realize it was quite as drastic as that, where the second column isn't used if alone.
If...
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
December 30, 2010 at 11:54 am
GSquared (12/30/2010)
I just noticed I hit 10k "points" on SSC today. Good way to end the year, as it were.
Congrats. Where in the overall standing are you now?
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
December 30, 2010 at 11:44 am
So it's per user, per date?
If I understand you correctly...
SELECT UserID, vtrRespDate,
CASE
WHEN EXISTS (SELECT 1 FROM VTRCheckListDetails sub WHERE sub.UserID = v.UserID AND sub.vtrRespDate = v.vtrRespDate AND trans_status =...
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
December 30, 2010 at 11:44 am
Viewing 15 posts - 28,696 through 28,710 (of 49,552 total)