Viewing 15 posts - 5,446 through 5,460 (of 19,560 total)
And which plan is it that you want to use?
Which plan is performing better?
Did you clear the cache before running your tests on both servers?
Both servers have same number of...
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
December 20, 2012 at 12:39 am
Stewart "Arturius" Campbell (12/20/2012)
It depends on whether filtered indexes are utilised or not, etc.
However, it could be that the...
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
December 20, 2012 at 12:35 am
Based on the question:
Is it possible to create a table with unique constraint that allows multiple NULL values from SQL Server 2008 onwards?
I don't disagree with the correct answer. ...
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
December 20, 2012 at 12:33 am
Lynn Pettis (12/20/2012)
JeffRush (12/19/2012)
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
December 20, 2012 at 12:14 am
And the server settings, are they the same?
Max Degree of parallelism and Cost Threshold for Parallelism for starters.
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
December 20, 2012 at 12:10 am
The reasons can be related to available resources, number of records and/or server settings.
Are bother environments exactly the same? If not, then the same execution plan could happen but...
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
December 19, 2012 at 11:48 pm
When you say windows service list, are you referring to the Services control panel?
In the Services Control panel you will want to look for SQL Server as the name and...
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
December 19, 2012 at 11:41 pm
Are these the only considerations for this script? Or do you also want to adhere to BP recommendations as can be found here[/url]?
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
December 19, 2012 at 9:24 pm
KWymore (12/19/2012)
Steve Jones - SSC Editor (12/19/2012)
Chris Metzger (12/19/2012)
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
December 19, 2012 at 9:17 pm
Ray K (12/19/2012)
L' Eomot Inversé (12/19/2012)
SQLRNNR (12/19/2012)
TalonHawk(e)
Hawkeye
Pierce
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
December 19, 2012 at 5:15 pm
The Dixie Flatline (12/19/2012)
Merry Christmas and/or Happy Holidays to everybody who survives.
And Merry Christmas to you too!!
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
December 19, 2012 at 2:49 pm
Stefan Krzywicki (12/19/2012)
SQLRNNR (12/19/2012)
Stefan Krzywicki (12/19/2012)
Lowell (12/19/2012)
If the Mayans were so good at predicting the future, wouldn't there still be Mayans left?
Since there are, does that convince you they were...
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
December 19, 2012 at 12:09 pm
Stefan Krzywicki (12/19/2012)
Lowell (12/19/2012)
If the Mayans were so good at predicting the future, wouldn't there still be Mayans left?
Since there are, does that convince you they were good at predicting...
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
December 19, 2012 at 11:39 am
Brandie Tarvin (12/19/2012)
Steve Jones - SSC Editor (12/19/2012)
Gianluca Sartori (12/18/2012)
Merry Christmas everybody if the Mayans are wrong.
Otherwise... oh,...
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
December 19, 2012 at 11:17 am
Talon
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
December 19, 2012 at 10:09 am
Viewing 15 posts - 5,446 through 5,460 (of 19,560 total)