Viewing 15 posts - 25,921 through 25,935 (of 49,552 total)
Open it up and read through the code
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 26, 2011 at 4:17 am
Leave it Ninja. When it breaks in a week's time because the update stats job wasn't added we'll be back here anyway.
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 25, 2011 at 3:25 pm
There's no more info I can give you. Error 50000 is NOT a SQL built in error. It comes from a RAISERROR somewhere in the job code or code 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 25, 2011 at 3:24 pm
SQLRNNR (5/25/2011)
GilaMonster (5/25/2011)
Grant and I are talking Execution plans for a whole day at PASS Summit this year.You are all coming? Right?
Are these the extra breakout sessions that cost...
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 25, 2011 at 2:06 pm
Grant and I are talking Execution plans for a whole day at PASS Summit this year.
You are all coming? Right?
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 25, 2011 at 1:57 pm
Error 50000 is a custom error. Somewhere in the job code a RAISERROR ran. Look through the code, see where it's run and why.
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 25, 2011 at 1:30 pm
NM. Quoted instead of edit
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 25, 2011 at 1:09 pm
http://sqlinthewild.co.za/index.php/2009/04/14/on-counts/
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 25, 2011 at 12:00 pm
river1 (5/25/2011)
and in 2000? the behavior was the same? or it was neded less chages to fire the trigger?
There were subtle differences that you can easily find if you do...
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 25, 2011 at 11:56 am
SkyBox (5/25/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
May 25, 2011 at 11:47 am
Yes.
Please in future post new questions in a new thread.
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 25, 2011 at 11:41 am
river1 (5/25/2011)
A DESC index is what you call on your archical as a ascending column?
No, not at all. I explained it in the blog post. An ascending column 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
May 25, 2011 at 11:39 am
sqlnaive (5/24/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
May 25, 2011 at 11:38 am
river1 (5/25/2011)
Do you mean that this auto update statistics trigger only updates tables that have 20% more rows that the lest time they were updated by this trigger?
No. 20% changes,...
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 25, 2011 at 11:37 am
Partition is not higher than a table lock, it's a lower level (tables are made of one or more partitions), and if the table allows lock escalation to partition level,...
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 25, 2011 at 8:03 am
Viewing 15 posts - 25,921 through 25,935 (of 49,552 total)