February 5, 2010 at 8:56 am
Jack Corbett (2/5/2010)
Steve Jones - Editor (2/5/2010)
just an FYI. A great networking story for you folks out there: http://www.sqlservercentral.com/blogs/tim_mitchell/archive/2010/02/05/A-New-Season-_2D00_-A-Networking-Success-Story.aspxI'll second that. It's a great post and a great story. Stories like that are definitely an encouragement to me to keep trying.
I read that. Great example to follow.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 5, 2010 at 9:01 am
Steve Jones - Editor (2/5/2010)
just an FYI. A great networking story for you folks out there: http://www.sqlservercentral.com/blogs/tim_mitchell/archive/2010/02/05/A-New-Season-_2D00_-A-Networking-Success-Story.aspx
A good example to follow. It's in my 2010 goals.
-- Gianluca Sartori
February 5, 2010 at 9:18 am
GilaMonster (2/5/2010)
BrainDonor (2/5/2010)
Gail,How do you find them?
Do you use divining rods? I admire your determination.
Somedays I think they're finding me. If my divining rods worked, I'd use them to avoid some posters.
I'm contemplating a blog post on the recovering historically deleted data with DBCC TimeWarp (with all 137 non-optional parameters). Maybe for the beginning of April...
Made my Friday.:-P:-P:-P
1st Thursday in April should be interesting if people are already planning ahead.
Greg E
February 5, 2010 at 9:24 am
Greg Edwards-268690 (2/5/2010)
GilaMonster (2/5/2010)
BrainDonor (2/5/2010)
Gail,How do you find them?
Do you use divining rods? I admire your determination.
Somedays I think they're finding me. If my divining rods worked, I'd use them to avoid some posters.
I'm contemplating a blog post on the recovering historically deleted data with DBCC TimeWarp (with all 137 non-optional parameters). Maybe for the beginning of April...
Made my Friday.:-P:-P:-P
1st Thursday in April should be interesting if people are already planning ahead.
Greg E
Maybe we could turn this into an April Fool question of the day.
Which of these methods can be used to restore a damaged database to the state it was before the damage using a backup taken after the damage occurred? (Choose all that apply)
1 -
2 -
3 -
4 -
5 - All of the above
6 - 1, 2, 3, 4, but not 5
7 - None of the above
8 - 5 and 7
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 5, 2010 at 9:37 am
I couldn't see options 1 thru 4, so I took a guess at what might seem logical.
1. - Run backwards. Necessary speed would depend on whether the Turbo button was depressed on the server.
2. - Inspect each table and dleete any suspect records.
3. - Pray a lot.
4. - If 1 does not work, restore from a prior backup, but make sure the Turbo button is pressed while performing.
Greg E
February 5, 2010 at 9:47 am
lol cracking myself up. My bookmark to The Thread was back a couple pages, and I got greedy and clicked before the page was done loading. I ended up clicking on the Report button on Paul's post where he said:
Please don't flame me.
Paul
I backed out, so I don't *think* I reported him, but was sorely tempted to continue for pure entertainment value.
I'll try not to let my addiction to The Thread get the best of me in the future...(clickclickclickclickclick)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 5, 2010 at 9:51 am
Greg Edwards-268690 (2/5/2010)
I couldn't see options 1 thru 4, so I took a guess at what might seem logical.1. - Run backwards. Necessary speed would depend on whether the Turbo button was depressed on the server.
2. - Inspect each table and dleete any suspect records.
3. - Pray a lot.
4. - If 1 does not work, restore from a prior backup, but make sure the Turbo button is pressed while performing.
Greg E
I thought the turbo button was for short bursts...
And don't we have to get to 88mph for the backwards/future compatible forward-ups?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 5, 2010 at 10:06 am
jcrawf02 (2/5/2010)
Jason, keep meaning to ask you how you liked the other Olympians books, I read the Lightning Thief, but not the rest yet.
I liked all of them. I did think that the story got better in the middle books. The writing got better too. However, I started with the first book and it got me hooked. I wonder if there will be a new series along the same lines.
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
February 5, 2010 at 10:07 am
GilaMonster (2/5/2010)
BrainDonor (2/5/2010)
Gail,How do you find them?
Do you use divining rods? I admire your determination.
Somedays I think they're finding me. If my divining rods worked, I'd use them to avoid some posters.
I'm contemplating a blog post on the recovering historically deleted data with DBCC TimeWarp (with all 137 non-optional parameters). Maybe for the beginning of April...
That would be funny. I wonder how many would take it serious? Especially if we just referred them to your blog.
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
February 5, 2010 at 10:10 am
CirquedeSQLeil (2/5/2010)
GilaMonster (2/5/2010)
BrainDonor (2/5/2010)
Gail,How do you find them?
Do you use divining rods? I admire your determination.
Somedays I think they're finding me. If my divining rods worked, I'd use them to avoid some posters.
I'm contemplating a blog post on the recovering historically deleted data with DBCC TimeWarp (with all 137 non-optional parameters). Maybe for the beginning of April...
That would be funny. I wonder how many would take it serious? Especially if we just referred them to your blog.
I can't use DBCC TimeWarp. Our network administrator won't allow it on any machine. He says it screws up the system clocks. 🙁
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 5, 2010 at 10:14 am
Greg Edwards-268690 (2/5/2010)
GilaMonster (2/5/2010)
BrainDonor (2/5/2010)
Gail,How do you find them?
Do you use divining rods? I admire your determination.
Somedays I think they're finding me. If my divining rods worked, I'd use them to avoid some posters.
I'm contemplating a blog post on the recovering historically deleted data with DBCC TimeWarp (with all 137 non-optional parameters). Maybe for the beginning of April...
Made my Friday.:-P:-P:-P
1st Thursday in April should be interesting if people are already planning ahead.
Greg E
I'll start planning now. No wait, I have real projects due that Thursday - dang it.
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
February 5, 2010 at 10:16 am
Grant Fritchey (2/5/2010)
Greg Edwards-268690 (2/5/2010)
I couldn't see options 1 thru 4, so I took a guess at what might seem logical.1. - Run backwards. Necessary speed would depend on whether the Turbo button was depressed on the server.
2. - Inspect each table and dleete any suspect records.
3. - Pray a lot.
4. - If 1 does not work, restore from a prior backup, but make sure the Turbo button is pressed while performing.
Greg E
I thought the turbo button was for short bursts...
And don't we have to get to 88mph for the backwards/future compatible forward-ups?
Not in a DELLorian. We only truly need the turbo button.
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
February 5, 2010 at 10:18 am
Alvin Ramard (2/5/2010)
I can't use DBCC TimeWarp. Our network administrator won't allow it on any machine. He says it screws up the system clocks. 🙁
If you change the spaceTime continuum sufficiently, you'll never have to tell him, since it won't be in the log...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 5, 2010 at 10:24 am
jcrawf02 (2/5/2010)
I'll try not to let my addiction to The Thread get the best of me in the future...(clickclickclickclickclick)
If you don't, and get more than a couple of hours behind, it'll take days to catch up. Admit it, The Thread has us all right where she (he??) wants us.
-- You can't be late until you show up.
February 5, 2010 at 10:27 am
Anybody notice that the Thread has surpassed 11,000 posts?
No countdown this time around.
Will the Thread seek vengeance?
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 - 11,146 through 11,160 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply