Viewing 15 posts - 12,721 through 12,735 (of 19,560 total)
RBarryYoung (8/28/2010)
CirquedeSQLeil (8/27/2010)
Trey Staker (8/27/2010)
The executive assistant to our CIO ...
Ha - I first read that as "Execution Assistant..."
That would have been funny.:-D Would go really well with 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
August 28, 2010 at 8:43 am
I would start with finding where the pain points in the app and database are. Once those have been identified, I would optimize the database (indexes, keys, constraints) 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
August 28, 2010 at 8:42 am
It is possible to make it run faster by splitting the db into three.
It is also possible to make it run faster by optimizing it and leaving it running within...
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
August 28, 2010 at 12:03 am
Typically I have seen them be about 1Gb. No real recommendation either.
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
August 27, 2010 at 4:50 pm
Tough pick between two of my favorites - THOR and FLASH.
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
August 27, 2010 at 1:16 pm
crookj (8/27/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
August 27, 2010 at 12:08 pm
Brandie Tarvin (8/27/2010)
At least you're not on a plane, Steve. @=)
Or on a train with Green eggs and ham
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
August 27, 2010 at 11:59 am
Thanks - we have another reason for ensuring specificity on our conversions.
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
August 27, 2010 at 11:49 am
Kit G (8/27/2010)
Steve Jones - Editor (8/27/2010)
Shotgun (don't like snakes)Mongoose
I prefer the snakes over the moles / groundhogs
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
August 27, 2010 at 11:43 am
Steve Jones - Editor (8/27/2010)
Shotgun (don't like snakes)
Dynamite is better
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
August 27, 2010 at 11:41 am
LutzM (8/27/2010)
WayneS (8/27/2010)
... Now, if you want to send me via PayPal $250, I'll be happy to waste up to 3 hours helping you out.
😀 SOM 😀 Gorgeous!
In fact, considering...
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
August 27, 2010 at 11:36 am
Trey Staker (8/27/2010)
The executive assistant to our CIO ...
Ha - I first read that as "Execution Assistant..."
That would have been funny.:-D Would go really well with the #inappropriatePASSSessions tag...
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
August 27, 2010 at 11:03 am
Alvin Ramard (8/27/2010)
WayneS (8/27/2010)
Sigh. (Bang head on desk).How to troubleshoot in 3 easy steps:
1 - Load gun
2 - Aim at trouble
3 - Shoot :w00t:
😛
You have...
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
August 27, 2010 at 10:58 am
parthi-1705 (8/27/2010)
CirquedeSQLeil (8/27/2010)
There are multiple ways to add disk space and have the data use the new space. One method is to extend your partition.
Even for partition we need...
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
August 27, 2010 at 10:55 am
parthi-1705 (8/27/2010)
pankushmehta (8/26/2010)
If you add...
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
August 27, 2010 at 9:14 am
Viewing 15 posts - 12,721 through 12,735 (of 19,560 total)