Are the posted questions getting worse?
-
CirquedeSQLeil (4/29/2010)
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 me off pretty good.
Have you checked out the QotD yet?
-
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 -
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 -
CirquedeSQLeil (4/29/2010)
Lynn Pettis (4/29/2010)
Have you checked out the QotD yet?Yes.
Saw your response on the thread. Probably could have used more detail on the hardware to support a failure corrupting the mdf and backup file only, but how much detail do yo really what to write? I thought I gave enough, mdf file corrupt, able to do a tail log backup. Discover when attempt to restore the latest full backup the the file was corrupt. What do you do now? Will the scenerio provided work to bring you back to the the time of the failure.
Several people obviously didn't read the question saying the right answer would use the Teusday full backup and the 8 am wednesday diff backup and then all subsequent t-log backups.
Another said the most recent diff was stll the one taken at 8 am Wednesday. hope they weren't DBA's.
-
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 failure corrupting the mdf and backup file only, but how much detail do yo really what to write? I thought I gave enough, mdf file corrupt, able to do a tail log backup. Discover when attempt to restore the latest full backup the the file was corrupt. What do you do now? Will the scenerio provided work to bring you back to the the time of the failure.
Several people obviously didn't read the question saying the right answer would use the Teusday full backup and the 8 am wednesday diff backup and then all subsequent t-log backups.
Another said the most recent diff was stll the one taken at 8 am Wednesday. hope they weren't DBA's.
I thought the question had adequate information, was well thought out and is obviously difficult. And since you said the tail backup was successful - then it should be understood that the failure wasn't too severe. I was just thinking out loud.
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 -
CirquedeSQLeil (4/29/2010)
You guys have more patience than I. That series would have torqued me off pretty good.Yep, glad I missed that thread.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi -
We missed the party!! When did we break the 1,250,000 member mark??
-
G'nite all, I have to get up early today.
-
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 -
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 -
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 when this event occurred. 😉
-
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 when this event occurred. 😉
I couldn't resist.
Probably about a month ago.
Steve will have to run the numbers.
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 -
Odd question just occurred to me.
Has anybody here ever tried setting their sa account password to contain emoticons? Or any sql logon password for that matter.
sa password = :-D;-):w00t::cool::hehe::-):-D:doze::crying::(:-P:-):-D:-P
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 -
CirquedeSQLeil (4/30/2010)
Odd question just occurred to me.Has anybody here ever tried setting their sa account password to contain emoticons? Or any sql logon password for that matter.
sa password = :-D;-):w00t::cool::hehe::-):-D:doze::crying::(:-P:-):-D:-P
I think the only emoticon I'd want to actually use at work would be 🙁
But a password full of these would be interesting. With the occasional ROFL, LOL or SOM!
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2 -
WayneS (4/30/2010)
CirquedeSQLeil (4/30/2010)
Odd question just occurred to me.Has anybody here ever tried setting their sa account password to contain emoticons? Or any sql logon password for that matter.
sa password = :-D;-):w00t::cool::hehe::-):-D:doze::crying::(:-P:-):-D:-P
I think the only emoticon I'd want to actually use at work would be 🙁
But a password full of these would be interesting. With the occasional ROFL, LOL or SOM!
Those would be great to include in a password.
The use of ascii characters (symbols) would also be good.
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
Viewing 15 posts - 14,956 through 14,970 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply