Viewing 15 posts - 8,731 through 8,745 (of 19,560 total)
Good to see that the culprit was found.
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
September 14, 2011 at 1:03 pm
crookj (9/14/2011)
Ray K (9/14/2011)
Daniel Bowlin (9/14/2011)
Pressurecooker
Rice Steamer
Jasmine
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
September 14, 2011 at 1:01 pm
The server from which it is disappearing, is it involved in replication?
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
September 13, 2011 at 5:19 pm
Sean Lange (9/12/2011)
select MAX(number) from
(
select top 95 percent number from PS_TestForOnline order by number
) MyAlias
You probably want a bit more sample data to prove this but it should be...
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
September 13, 2011 at 5:16 pm
THE-FHA (9/13/2011)
My question is how often should one reorganize indexes? daily, weekly or monthly or just on demand?
It largely depends on your environment. Baseline your system, check the info...
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
September 13, 2011 at 5:06 pm
TheSQLGuru (9/12/2011)
Here is a blog post from Jonathan Kehayias with some interesting testing: http://sqlskills.com/blogs/jonathan/post/Does-Index-Fragmentation-Matter-with-SSDe28099s.aspx
Excellent reference - same one I would have used had I not seen your post first.
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
September 13, 2011 at 5:04 pm
When things are slow:
Find a process that is running slow and tune it
Create a process to help fill a need
Research something of interest -test it out
Write an article (SSC or...
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
September 13, 2011 at 4:55 pm
Evil Kraig F (9/13/2011)
We try to take over the WORLD!
Honestly, I'm here on SSC when it's slow, or I'm off trying to research...
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
September 13, 2011 at 4:52 pm
Place your condition in the data flow arrow leading up to your derived columns. If column > 0 then one path, else send it a different path.
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
September 13, 2011 at 3:21 pm
See if this is of any help.
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
September 13, 2011 at 2:47 pm
Yes. You would run the service packs again to make sure the client tools are patched.
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
September 13, 2011 at 2:43 pm
Lowell (9/13/2011)
this query featuring a CTE lists all foreign keys, and if there is an index with the leading column on the child table or not.
if...
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
September 13, 2011 at 1:29 pm
bcsims 90437 (9/13/2011)
Ray K (9/13/2011)
crookj (9/13/2011)
Daniel Bowlin (9/13/2011)
Evil Kraig F (9/12/2011)
eccentricDBA (9/12/2011)
Revenant (9/12/2011)
SQLRNNR (9/12/2011)
flameold
retirement
Old flame's retirement home.
Some fires never quite burn out, do they?
Just like old DBAs never burn out?
Finish...
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
September 13, 2011 at 1:26 pm
Ninja's_RGR'us (9/13/2011)
Guy asks a question but wants a different answer than mine. Hopefully srength in numbers might save him months of work with absolutely no valid reason : http://www.sqlservercentral.com/Forums/Topic1174322-373-1.aspx
maybe...
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
September 13, 2011 at 1:23 pm
Nice question.
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
September 13, 2011 at 1:21 pm
Viewing 15 posts - 8,731 through 8,745 (of 19,560 total)