Viewing 15 posts - 3,271 through 3,285 (of 19,560 total)
bread
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
April 1, 2014 at 10:56 am
jasona.work (4/1/2014)
SQLRNNR (4/1/2014)
jasona.work (4/1/2014)
SQLRNNR (4/1/2014)
Ed Wagner (4/1/2014)
Lynn Pettis (4/1/2014)
jasona.work (4/1/2014)
...OK, old man rant off (crap, 44 is just 3.5 weeks away!)
You're not old!
Personally, I really hope you're not old at...
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
April 1, 2014 at 10:18 am
Thanks for the script. This is very helpful.
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
April 1, 2014 at 9:18 am
jasona.work (4/1/2014)
SQLRNNR (4/1/2014)
Ed Wagner (4/1/2014)
Lynn Pettis (4/1/2014)
jasona.work (4/1/2014)
...OK, old man rant off (crap, 44 is just 3.5 weeks away!)
You're not old!
Personally, I really hope you're not old at 44. 😉
Personally...
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
April 1, 2014 at 8:46 am
jcrawf02 (4/1/2014)
Sean Lange (3/31/2014)
Ed Wagner (3/31/2014)
rodjkidd (3/31/2014)
Got an email from friend who was stuck on working out how many days old a debt is at...
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
April 1, 2014 at 8:00 am
Thanks 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
April 1, 2014 at 7:44 am
Ed Wagner (4/1/2014)
Lynn Pettis (4/1/2014)
jasona.work (4/1/2014)
...OK, old man rant off (crap, 44 is just 3.5 weeks away!)
You're not old!
Personally, I really hope you're not old at 44. 😉
Personally I hope...
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
April 1, 2014 at 7:39 am
GilaMonster (4/1/2014)
Ok..."The language is expressive, easily readable and values explicitness. Abbreviations and corrupted spelling should be avoided in variable names"
and the string data type is 'str'
snigger
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
April 1, 2014 at 7:37 am
Grant Fritchey (3/31/2014)
New Born DBA (3/31/2014)
Thanks everybody for replying. Can I use import export utility? Just asking.
This will put more load on the production system than using the backup 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
March 31, 2014 at 12:50 pm
An index in that case can occasionally help. It's worth the try.
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 31, 2014 at 9:32 am
You can try this
http://www.red-gate.com/products/dba/sql-monitor/
There are plenty of custom metrics that can be installed with it.
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 31, 2014 at 9:30 am
BWFC (3/31/2014)
Kurt W. Zimmerman (3/31/2014)
knucklehead
DrummerCaveman
Knuckledragger
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 31, 2014 at 9:24 am
Do you need to have an isolation level in use that causes row-versioning and thus causes use of the VS in tempdb?
If not, try changing the isolation level.
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 31, 2014 at 8:55 am
JAZZ Master (3/31/2014)
SQLRNNR (3/31/2014)
spitballfastball
knuckleball
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 31, 2014 at 8:48 am
Eric M Russell (3/31/2014)
SQLRNNR (3/31/2014)
Eric M Russell (3/31/2014)
If one of my daughters expressed a desire to pursue a career in technology, I would encourage her with no reservations.
I would...
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 31, 2014 at 8:48 am
Viewing 15 posts - 3,271 through 3,285 (of 19,560 total)