Viewing 15 posts - 16,186 through 16,200 (of 19,560 total)
homebrew01 (3/19/2010)
CirquedeSQLeil (3/19/2010)
homebrew01 (3/19/2010)
I have several SQL 2000 Administration, DTS, Programming & Reporting Services books.PM me if you want some.
That's awfully generous of you.:cool:
Ain't it though. 😀
I thought...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 12:23 pm
You say the execution plans are the same. Is that the estimated or the actual exec plans?
How many rows difference is there between the environments?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 12:22 pm
Two quick suggestions without having seen the table defs.
1. Move the derived table to a cte and perform your left outer join on that.
or
2. Change the table alias...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 12:17 pm
GSquared (3/19/2010)
Jason Shadonix (3/19/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 12:08 pm
homebrew01 (3/19/2010)
I have several SQL 2000 Administration, DTS, Programming & Reporting Services books.PM me if you want some.
That's awfully generous of you.:cool:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 12:03 pm
balasach82 (3/19/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 12:01 pm
Nice article thanks. I like the compare and contrast between 2k5 and 2k8 that you demonstrated.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 11:56 am
Steve Jones - Editor (3/19/2010)
This is a learning tool, and I could see that Microsoft bears some blame here since we try to use BOL as a reference. To that...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 11:13 am
jcrawf02 (3/19/2010)
What about being able to eat your neighbors when it's too cold?
There are too many of those stories that are true.
One time at band camp...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 10:58 am
Paul White NZ (3/19/2010)
CirquedeSQLeil (3/18/2010)
This may be of use as well
SELECT SERVERPROPERTY ('edition'),serverproperty('productversion')
Also:
SELECT CONVERT(INTEGER, SERVERPROPERTY('EngineEdition'));
This returns a value of 4 for Express (all variations). The 'edition' version distinguishes...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 10:44 am
Paul White NZ (3/19/2010)
CirquedeSQLeil (3/19/2010)
I actually disagree with the correct answer.
Me too, but it's not terribly important. There could have been another option..."it depends".
For the record, I ticked Steve,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 10:40 am
2 Tim 3:16 (3/19/2010)
I've used Apex SQL Log and Apex SQL Recover
Glad to hear somebody was able to get it to work. I tried these in a couple...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 10:33 am
Brandie Tarvin (3/19/2010)
It isn't a silly question. Developers should not have that ability on Production. In fact, there should be a tight throttle on the # of people who do...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 10:31 am
Starry Night
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 10:29 am
Blustery
and elated (my team finally won a game in the tournament)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 19, 2010 at 9:38 am
Viewing 15 posts - 16,186 through 16,200 (of 19,560 total)