February 7, 2014 at 8:20 am
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?
Kinky??
Um no. Just got back from SQLCruise with Grant and nobody wants to see that image.:hehe:
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 7, 2014 at 8:22 am
GilaMonster (2/7/2014)
jasona.work (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?/Using my best George Takei imitation
Ooh My...
๐
At least he's not imagining us wandering around. ๐
"I was bo-oornnn under a wond -rrrrrin' star"
The 'a' and the 'o' are a long way apart on this keyboard, I really don't know how that happened. Phat phorebrain possibly.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
February 7, 2014 at 8:24 am
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?
Pfft, you wish.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 7, 2014 at 8:28 am
SQLRNNR (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?Kinky??
Um no. Just got back from SQLCruise with Grant and nobody wants to see that image.:hehe:
You do realize where you are, right?
This is the Internet.
Somewhere out there, there's someone who *really* wants to see that image...
Now, if you'll excuse me, I need to go bleach my brain to get that out...
๐
February 7, 2014 at 8:34 am
jasona.work (2/7/2014)
SQLRNNR (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?Kinky??
Um no. Just got back from SQLCruise with Grant and nobody wants to see that image.:hehe:
You do realize where you are, right?
This is the Internet.
Somewhere out there, there's someone who *really* wants to see that image...
Now, if you'll excuse me, I need to go bleach my brain to get that out...
๐
Just remember that you asked for it when you see an Image posted by Grant of himself - shirtless in a thinking man pose.
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 7, 2014 at 8:36 am
SQLRNNR (2/7/2014)
jasona.work (2/7/2014)
SQLRNNR (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?Kinky??
Um no. Just got back from SQLCruise with Grant and nobody wants to see that image.:hehe:
You do realize where you are, right?
This is the Internet.
Somewhere out there, there's someone who *really* wants to see that image...
Now, if you'll excuse me, I need to go bleach my brain to get that out...
๐
Just remember that you asked for it when you see an Image posted by Grant of himself - shirtless in a thinking man pose.
I'll wait til I'm back home and I'll get one during crossfit so I'll be all sweaty. That should truly horrify.
"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 7, 2014 at 9:05 am
Grant Fritchey (2/7/2014)
SQLRNNR (2/7/2014)
jasona.work (2/7/2014)
SQLRNNR (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?Kinky??
Um no. Just got back from SQLCruise with Grant and nobody wants to see that image.:hehe:
You do realize where you are, right?
This is the Internet.
Somewhere out there, there's someone who *really* wants to see that image...
Now, if you'll excuse me, I need to go bleach my brain to get that out...
๐
Just remember that you asked for it when you see an Image posted by Grant of himself - shirtless in a thinking man pose.
I'll wait til I'm back home and I'll get one during crossfit so I'll be all sweaty. That should truly horrify.
I'm thinking of that old adage that once you've seen something, you can't un-see it.
February 7, 2014 at 9:11 am
Grant Fritchey (2/7/2014)
SQLRNNR (2/7/2014)
jasona.work (2/7/2014)
SQLRNNR (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?Kinky??
Um no. Just got back from SQLCruise with Grant and nobody wants to see that image.:hehe:
You do realize where you are, right?
This is the Internet.
Somewhere out there, there's someone who *really* wants to see that image...
Now, if you'll excuse me, I need to go bleach my brain to get that out...
๐
Just remember that you asked for it when you see an Image posted by Grant of himself - shirtless in a thinking man pose.
I'll wait til I'm back home and I'll get one during crossfit so I'll be all sweaty. That should truly horrify.
OH GOD!!!
WHAT HAVE I DONE!!!!
I'm so very sorry everyone!
February 7, 2014 at 10:37 am
Koen Verbeeck (2/6/2014)
Koen Verbeeck (2/6/2014)
Luis Cazares (2/6/2014)
There seems to be a new feature in the forums to mark answers that worked for the OP.What do you think about this? I'm not sure if it's only possible to mark one answer or multiple answers. This seems to be common practice in other forums as I've been asked in the past about this feature.
Haven't seen it yet. Can you only do this if you started the topic? (and if yes, who is ever going to mark this thread as answered???)
I think it is a nice feature. I just hope we don't get parrots like in the MSDn forums who are just hoping to get their post marked as the answer.
I'd have to ask more questions myself in order to use this new feature more.
In all of my time on this site, I think I asked less than 10 questions.
Less than 10 - so less than 8 more than I asked, I guess.
edit: not counting questions in the middle of a thread.
Tom
February 7, 2014 at 10:51 am
Jeff Moden (2/7/2014)
Koen Verbeeck (2/6/2014)
Steve Jones - SSC Editor (2/6/2014)
However, this way they can give feedback that something worked. We are talking about how to best get other info from the "crowd" on posts.As long as this doesn't turn SSC into a dictatorship like at StackOverflow, where some arrogant twats decide everything.
(I may be overreacting a bit ๐
I like the MSDN model, where the OP or admins mark a post as answered, but the crowd can upvote a post or propose a reply as an answer.
I don't believe you're overreacting. I've had experiences there and on ASK SSC where they closed a really interesting thread or two that had some really bad answers because it didn't fit their model for not having discussions. That's why I simply avoid both most of the time now.
I like the MSDN model for the very reason you state.
Have to agree about ASK SSC - gave up on it some years ago. Never used Stack Overflow (although get quite a few hits on it with Google). Stongly inclined to agree with you and Koen. (No surprise there, I guess :-D)
Tom
February 7, 2014 at 11:01 am
Koen Verbeeck (2/7/2014)
The only problem with MSDN are some of its moderators.An example that is causing a bit of a Twitter riot right now:
Let's hope that Jamie's comment has some effect - maybe a few more upvotes for it would help. As twitter and I are unconnected (I don't possess a long enough and suffciently well insulated bargepole) I haven't seen the riot and won't jon it, but upvoting Jamie's comment was easy.
Tom
February 7, 2014 at 11:13 am
GilaMonster (2/7/2014)
jasona.work (2/7/2014)
Is it in any way, shape, or form, possible to have a functional SQL database, with its log file in an offline state. Could you somehow read / alter data in any way at all?Change definitely not.
Without the log you may (emphasis may) be able to switch the DB to emergency mode and read the data. Single user, for emergencies.
Edit: That said, there is a short interval (30 sec iirc) between when the log file disappears and when SQL declares an IO failure.
I don't think that 30 seconds interval changes anything so far as altering data is concerned- nothing can be written to database pages on disc for which the corresponding log record has not been confirmed by the IO system as written to the log, and nothing can be so confirmed once the file has "disappeared"; I guess you may be able to read some stuff during that interval.
Of course you can always read the physical data from the data file on the disc and try interpreting it; without the log file this is going to be roughly equivalent (but a bit more technically difficult) to reading data with READ UNCOMMITTED isolation level, so possible not very useful.
Tom
February 7, 2014 at 11:26 am
L' Eomot Inversรฉ (2/7/2014)
Jeff Moden (2/7/2014)
Koen Verbeeck (2/6/2014)
Steve Jones - SSC Editor (2/6/2014)
However, this way they can give feedback that something worked. We are talking about how to best get other info from the "crowd" on posts.As long as this doesn't turn SSC into a dictatorship like at StackOverflow, where some arrogant twats decide everything.
(I may be overreacting a bit ๐
I like the MSDN model, where the OP or admins mark a post as answered, but the crowd can upvote a post or propose a reply as an answer.
I don't believe you're overreacting. I've had experiences there and on ASK SSC where they closed a really interesting thread or two that had some really bad answers because it didn't fit their model for not having discussions. That's why I simply avoid both most of the time now.
I like the MSDN model for the very reason you state.
Have to agree about ASK SSC - gave up on it some years ago. Never used Stack Overflow (although get quite a few hits on it with Google). Stongly inclined to agree with you and Koen. (No surprise there, I guess :-D)
I checked ASK SSC out quite some time ago, but didn't really see the appeal. I tried answering a question once, but it wouldn't let me login. I haven't been back. Why would anyone want to use it anyway when we have SSC?
February 7, 2014 at 11:39 am
Ed Wagner (2/7/2014)
L' Eomot Inversรฉ (2/7/2014)
Jeff Moden (2/7/2014)
Koen Verbeeck (2/6/2014)
Steve Jones - SSC Editor (2/6/2014)
However, this way they can give feedback that something worked. We are talking about how to best get other info from the "crowd" on posts.As long as this doesn't turn SSC into a dictatorship like at StackOverflow, where some arrogant twats decide everything.
(I may be overreacting a bit ๐
I like the MSDN model, where the OP or admins mark a post as answered, but the crowd can upvote a post or propose a reply as an answer.
I don't believe you're overreacting. I've had experiences there and on ASK SSC where they closed a really interesting thread or two that had some really bad answers because it didn't fit their model for not having discussions. That's why I simply avoid both most of the time now.
I like the MSDN model for the very reason you state.
Have to agree about ASK SSC - gave up on it some years ago. Never used Stack Overflow (although get quite a few hits on it with Google). Stongly inclined to agree with you and Koen. (No surprise there, I guess :-D)
I checked ASK SSC out quite some time ago, but didn't really see the appeal. I tried answering a question once, but it wouldn't let me login. I haven't been back. Why would anyone want to use it anyway when we have SSC?
From what I hear, the developers are working on those login problems. I have said something about that on a few occasions.
I don't like stack. I think it is silly that you have to ask questions first and get those answered before you have enough rep to be able to answer questions.
MSDN might be ok from time to time but there are some serious attitudes over there. That has led me away from doing much over there.
SSC is just right for 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
February 7, 2014 at 11:56 am
L' Eomot Inversรฉ (2/7/2014)
I don't think that 30 seconds interval changes anything so far as altering data is concerned- nothing can be written to database pages on disc for which the corresponding log record has not been confirmed by the IO system as written to the log, and nothing can be so confirmed once the file has "disappeared"; I guess you may be able to read some stuff during that interval.
Modifications will run, the commit will hang (waiting on writelog) and the transaction will roll back as soon as SQL declares the IO failure.
Of course you can always read the physical data from the data file on the disc and try interpreting it; without the log file this is going to be roughly equivalent (but a bit more technically difficult) to reading data with READ UNCOMMITTED isolation level, so possible not very useful.
Unnecessary in most cases. Most of the time at worst an emergency mode repair will bring the DB back with some data loss.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 15 posts - 42,871 through 42,885 (of 66,688 total)
You must be logged in to reply to this topic. Login to reply