Viewing 15 posts - 7,186 through 7,200 (of 19,560 total)
Perry Whittle (1/11/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
January 11, 2012 at 5:41 pm
I really don't like the questions about "best" practices for storage from MS. There is seldom enough information presented to properly answer those questions.
Sure, RAID10 offers better protection. ...
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
January 11, 2012 at 5:03 pm
Any way you can attach the exec plan for the one that is taking a long time to run?
I think the clues to improving will be found there.
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
January 11, 2012 at 4:55 pm
GilaMonster (1/11/2012)
Errrrr... Someone(s) want to tackle this? http://www.sqlservercentral.com/Forums/Topic1234441-61-1.aspx
Hope that helps.
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
January 11, 2012 at 4:51 pm
DeanORenO
you people on this forum are always complaining about the questions that are asked on the forums, either you complain that they are too simple, and that the poster should...
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
January 11, 2012 at 4:49 pm
mtillman-921105 (1/11/2012)
Wasn't there a band named the Sex Pixels?
haha
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
January 11, 2012 at 4:35 pm
john.arnott (1/11/2012)
SQLRNNR (1/11/2012)
Evil Kraig F (1/11/2012)
GilaMonster (1/11/2012)
I want this one: http://www.thinkgeek.com/tshirts-apparel/unisex/frustrations/e718/?srp=2
Is it bad I originally misread the link and thought it said 'sex frustrations' as the folder?
😀 I've been...
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
January 11, 2012 at 3:21 pm
shrink
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
January 11, 2012 at 2:12 pm
Evil Kraig F (1/11/2012)
GilaMonster (1/11/2012)
I want this one: http://www.thinkgeek.com/tshirts-apparel/unisex/frustrations/e718/?srp=2
Is it bad I originally misread the link and thought it said 'sex frustrations' as the folder?
😀 I've been tempted to...
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
January 11, 2012 at 2:08 pm
Eshika (1/11/2012)
The trigger should be fired on an update, there are no recursive triggers...
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
January 11, 2012 at 2:03 pm
3graces (1/11/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
January 11, 2012 at 10:15 am
Has the on-site dba been able to successfully run the package from BIDS?
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
January 11, 2012 at 10:03 am
If you want to recreate the exact schema, script the current table and then rename the table to a "backup" table.
Then use insert into in order to copy the data.
Doing...
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
January 10, 2012 at 10:21 pm
Jason Selburg (1/10/2012)
But more clearly stated here. 😀
😀
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
January 10, 2012 at 9:25 pm
Nice - 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
January 10, 2012 at 8:51 pm
Viewing 15 posts - 7,186 through 7,200 (of 19,560 total)