Viewing 15 posts - 47,821 through 47,835 (of 49,552 total)
Jeff Moden (1/3/2008)
Hi Gail,I guess my point was that the execution plans aren't always going to show the number of rows touched
No, they won't. At best an exec 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
January 3, 2008 at 11:01 pm
Not that I've ever heard of. That's why skilled DBAs/sql developers are still needed.
What kind of problems? Logic? Exceptions? Performance? Invalid data?
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
January 3, 2008 at 1:39 pm
Or if you feel like been less verbose (and slightly more cryptic)
IF DB_ID(''?'') > 4
All user dbs have DatabaseIDs greater than 4
Then in your sp_reindexing proc, use the objectproperty 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
January 3, 2008 at 1:29 pm
I don't think that's stored anywhere in the index DMVs. I have seen missing index information included in the xml showplan, so if you dig through the plan cache 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
January 3, 2008 at 1:25 pm
How many pages do the tables have?
Re org doesn't touch the non-leaf levels of the index, whereas rebuild does. That could be the cause of some of your differences.
Oh, 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
January 3, 2008 at 1:22 pm
I think it depends on the company. The attitude the company has, the way they do business, the way they treat staff, the management, ...)
I've been an in-house 'programmer' (/admin/troubleshooter/GDB)...
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
January 3, 2008 at 1:20 pm
Mine or Adam's?
The DateMonthStarts I pointed you at will take a date and return the 1st day of that month.
Write the code into a user defined function, so 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
January 3, 2008 at 1:13 pm
Could you be a bit more specific please?
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
January 3, 2008 at 1:10 pm
One small piece of advice. Know management studio backwards. The simulations in that exam catch a lot of people. A colleague of mine got 100% on the questions, yet failed...
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
January 3, 2008 at 1:08 pm
Buy the suggested books and study for the exam. Brain dumps are cheating, plain and simple (and to boot, often incorrect)
I, and a lot of other people on this site,...
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
January 3, 2008 at 1:04 pm
Nice article, and a nice informal tone.
I am going to argue one point though. You say
Even the estimated and actual execution plans lie! Both say that we're only processing (touching)...
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
January 3, 2008 at 1:00 pm
Grab the datemonthstarts function from here[/url] and use that instead of MONTH.
Since you'll then be comparing datetimes, 1 Dec 2007 is < 1 Jan 2008
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
January 3, 2008 at 12:40 pm
Woot! :w00t: :w00t: :w00t: :w00t:
Congrats. It's most deservedly given.
So, where and when's the party?
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
January 3, 2008 at 6:05 am
MarkusB (1/3/2008)
Kevin is right about the IO messages which take too long, but in my experience these messages don't automatically lead to a stack dump.
They don't. The stack dump...
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
January 3, 2008 at 5:43 am
For completeness, and so no one gets the wrong idea about how to write triggers.
A trigger fires once for a statement. The inserted and/or deleted tables will contain as many...
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
January 3, 2008 at 5:36 am
Viewing 15 posts - 47,821 through 47,835 (of 49,552 total)