Viewing 15 posts - 17,866 through 17,880 (of 19,560 total)
jameslester78-958147 (1/25/2010)
Thank you for the clarification, it was interesting to read about how the cattle are fed beer and massaged daily.
You're welcome.
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 26, 2010 at 11:39 am
John McC (1/26/2010)
Just what the doctordidn'tordered
I thought that was Dr. Pepper with a KISS of cherry?
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 26, 2010 at 11:38 am
espanolanthony (1/26/2010)
...But I heard that one cannot move table, but one has to move the indexes and that will move the table.
A clustered index is the data for 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
January 26, 2010 at 11:34 am
This is good information from Jack and Jayakumar.
Without the tools mentioned by Jack and Jayakumar, you would only be able to restore the table as described in Jack's first post.
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 26, 2010 at 11:21 am
Nice editorial. I too have seen this apply to other areas beyond IT. From my experience, I think it is more prevalent in I.T. I also think...
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 26, 2010 at 11:10 am
That is a good blog entry on the topic. I would add that there are other scenarios where an SP may need to be decrypted. I ran into...
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 26, 2010 at 10:53 am
Yes good find indeed. I haven't seen that root cause for many moons.
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 26, 2010 at 10:47 am
crookj (1/26/2010)
CirquedeSQLeil (1/25/2010)
crookj (1/25/2010)
CirquedeSQLeil (1/23/2010)
D.Oc (1/23/2010)
CirquedeSQLeil (1/23/2010)
Jeff Moden (1/23/2010)
Detroit. We have Lions here, too, but they have no teeth. 😉
There's a lot more than just teeth that your lions...
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 26, 2010 at 10:37 am
Here's an article that seems like it would help:
http://cvakumar.com/msdynamics/?p=100
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 26, 2010 at 12:27 am
Thanks for the update.
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 26, 2010 at 12:19 am
Jeff Moden (1/25/2010)
WayneS (1/25/2010)
CirquedeSQLeil (1/25/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
January 25, 2010 at 7:03 pm
Check out this thread for an alternative method at helping to figure out what caused tempdb growth.
Opentran will work great - if the transaction is still running.
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 25, 2010 at 5:01 pm
Is your com+ service running in services.msc?
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 25, 2010 at 4:20 pm
Check this out - should give you an idea of how to use the command.
http://msdn.microsoft.com/en-us/library/ms189493(SQL.90).aspx
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 25, 2010 at 4:18 pm
I have never encountered any of these issues outlined in the reference articles. Thus, we have never pursued disabling the chimney. Since we still don't experience the problems,...
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 25, 2010 at 4:15 pm
Viewing 15 posts - 17,866 through 17,880 (of 19,560 total)