Viewing 15 posts - 14,386 through 14,400 (of 19,560 total)
Lynn Pettis (4/30/2010)
CirquedeSQLeil (4/30/2010)
Lynn Pettis (4/30/2010)
We missed the party!! When did we break the 1,250,000 member mark??About 2,215 members ago.
Was really looking for a date or at least day...
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 30, 2010 at 12:34 am
Lynn Pettis (4/30/2010)
G'nite all, I have to get up early today.
Same here - past bedtime.
Time to throw in Avatar, put it on the french track and drift to sleep.:-D
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 30, 2010 at 12:29 am
Lynn Pettis (4/30/2010)
We missed the party!! When did we break the 1,250,000 member mark??
About 2,215 members ago.
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 30, 2010 at 12:28 am
Paul White NZ (4/30/2010)
CirquedeSQLeil (4/29/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
April 30, 2010 at 12:26 am
Digs (4/30/2010)
Thanks..I thought a primary key was a clustered index ??
Is it not ??
if not whats the code for that type of index on a field combo ??
The primary key...
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 30, 2010 at 12:16 am
Lynn Pettis (4/29/2010)
CirquedeSQLeil (4/29/2010)
Lynn Pettis (4/29/2010)
Have you checked out the QotD yet?Yes.
So your response on the thread. Probably could have used more detail on the hardware to support a...
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 30, 2010 at 12:00 am
I agree with Jeff. This needs to be taken up with the folks at MS.
If you want good ammunition, find out what in MOSS is causing the growth first.
Here's...
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 29, 2010 at 11:57 pm
Look at that - we are already approaching 15K - just 42 more posts.
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 29, 2010 at 11:53 pm
Lynn Pettis (4/29/2010)
Have you checked out the QotD yet?
Yes.
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 29, 2010 at 11:44 pm
Thanks Lynn.
The part that gets me with these questions is if the hardware failure was enough to corrupt the database and the full backup - it would seem to me...
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 29, 2010 at 11:41 pm
Thanks for posting that Atif.
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 29, 2010 at 11:31 pm
Lynn Pettis (4/29/2010)
lmu92 (4/29/2010)
Lynn:See, the hippo is doing just fine!
Awesome!
By the way, did you see the latest post?
You guys have more patience than I. That series would have torqued...
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 29, 2010 at 11:29 pm
I would make sure you put a clustered index on it. I would also imagine that there should be a date comparison since that is a key part of...
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 29, 2010 at 8:55 pm
No need to shrink the t-log. The space inside the file is available for re-use once the t-log backup completes successfully.
Shrinking the file just releases the space to 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
April 29, 2010 at 8:51 pm
Henrico Bekker (4/29/2010)
confused....What was the question?
Spam?
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 29, 2010 at 8:48 pm
Viewing 15 posts - 14,386 through 14,400 (of 19,560 total)