Viewing 15 posts - 6,496 through 6,510 (of 19,560 total)
Stefan Krzywicki (4/5/2012)
Lynn Pettis (4/5/2012)
Grant Fritchey (4/5/2012)
Lynn Pettis (4/5/2012)
I'm sorry, but I started laughing to myself when I read this one.
Look at it as a complement. To many people, we're...
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 5, 2012 at 10:01 am
In addition to what Lynn said, yes your disk fragmentation can play a part in 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
April 5, 2012 at 9:59 am
lottery
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 5, 2012 at 9:35 am
Koen Verbeeck (4/5/2012)
Grant Fritchey (4/5/2012)
Yeah, I feel for him. I've had WAY too many arguments with people demanding that I rearrange the laws of physics because they said so.
If I...
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 5, 2012 at 9:15 am
For starters - post the exact code that are currently trying to troubleshoot. Based on the error you submitted and the code there, you would get a syntax error...
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 4, 2012 at 9:40 pm
I like it - keep em coming.
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 4, 2012 at 9:35 pm
Lynn Pettis (4/4/2012)
SQLRNNR (4/4/2012)
GilaMonster (4/4/2012)
Who feels like doing the impossible? http://www.sqlservercentral.com/Forums/Topic1278455-391-1.aspxA lot of attitude on that one.
Well, apparently we can't accept the restrictions he has to work under on this...
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 4, 2012 at 9:29 pm
rupes0610 (4/4/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
April 4, 2012 at 9:15 pm
GilaMonster (4/4/2012)
Who feels like doing the impossible? http://www.sqlservercentral.com/Forums/Topic1278455-391-1.aspx
A lot of attitude on that one.
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 4, 2012 at 9:13 pm
mrdenny (4/4/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
April 4, 2012 at 9:13 pm
rupes0610 (4/4/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
April 4, 2012 at 9:08 pm
george sibbald (4/4/2012)
a heap table can also be fragmented, so thats not 'index' fragmentation
If you look at it in the regard that a heap is index type of 0, then...
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 4, 2012 at 9:05 pm
I think the PoSH button should be made available.
Since I noticed the Script button back in previous versions, I have begun using that button liberally myself. It just makes...
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 4, 2012 at 11:19 am
Most people will be talking about Index fragmentation when planning for DB maintenance. I typically try to include the disk fragmentation as well because that can have an 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
April 4, 2012 at 11:08 am
L' Eomot Inversé (4/4/2012)
Lynn Pettis (4/4/2012)
Sean Lange (4/4/2012)
Lynn Pettis (4/4/2012)
capn.hector (4/4/2012)
Lynn Pettis (4/4/2012)
Or when they address you by that descriptor. That's good as well.Thanks Coach!!!
No, no, no. 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
April 4, 2012 at 9:43 am
Viewing 15 posts - 6,496 through 6,510 (of 19,560 total)