Viewing 15 posts - 3,001 through 3,015 (of 19,560 total)
tshad (5/28/2014)
I created a dummy database (TomsTest) and then I try to restore my other database "DEV"...
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
May 28, 2014 at 10:38 pm
Thanks for the question Steve.
I'd like to see Resource Governor someday be extended to include those other options.
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
May 28, 2014 at 10:32 pm
WayneS (5/28/2014)
rodjkidd (5/28/2014)
Koen go to Karaoke with him - then he's scary! :w00t:Rodders...
Just thinking of Grant singing is scary!;-)
Yeah it is
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
May 28, 2014 at 9:12 pm
I have seen both of those methods used successfully in performance tuning exercises.
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
May 28, 2014 at 8:44 pm
Check out the Code sample I have in this article http://jasonbrimhall.info/2014/05/23/can-you-partition-a-temporary-table/
You'll see that I drop the temp table at the beginning if it exists. I run this code over...
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
May 28, 2014 at 8:35 pm
Here is an interesting article on the effects of a rebuild vs. reorg. The effects of the article seem pretty consistent whether clustering on a GUID or Int 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
May 28, 2014 at 8:02 pm
Jason Selburg (5/28/2014)
SQLRNNR (5/28/2014)
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
Another vote for the RedGate SQL Compare tools.Nice license plate Jason S.
Another vote for Red-Gate SQL Compare. There are a 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
May 28, 2014 at 7:36 pm
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
Another vote for the RedGate SQL Compare tools.Nice license plate Jason S.
Another vote for Red-Gate SQL Compare. There are a number of other options from...
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
May 28, 2014 at 4:56 pm
I'm of the opinion that tables should have clustered indexes.
With an index scan versus a table scan, the index being smaller (if just on the ID) could be less impact....
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
May 28, 2014 at 4:00 pm
Is ID going to be your most commonly queried field in that table?
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
May 28, 2014 at 12:58 pm
The Dixie Flatline (5/28/2014)
Wow. Talk about a blast from the past..... 🙂
The thread looks very interesting. Too bad it got hit with payday loan spam.
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
May 28, 2014 at 10:37 am
abhijit.shrikhande (5/28/2014)
This is happening for SqlServerCentral's newsletters.
I lumped that in to my "notifications."
I only receive one newsletter. Maybe Steve can have somebody look deeper into your account. 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
May 28, 2014 at 9:21 am
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
Another vote for the RedGate SQL Compare tools.Nice license plate Jason S.
Another vote for Red-Gate SQL Compare. There are a number of other options from third parties...
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
May 28, 2014 at 9:20 am
For a rebuild, you generally want to have enough free space to cover your largest index and then add some for breathing room.
If you decide to do a reorg instead...
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
May 28, 2014 at 9:19 am
It doesn't appear to be a global issue. I am only receiving one email for each notification.
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
May 28, 2014 at 9:10 am
Viewing 15 posts - 3,001 through 3,015 (of 19,560 total)