February 7, 2014 at 7:28 am
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?
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 7:29 am
Grant Fritchey (2/7/2014)
Koen Verbeeck (2/7/2014)
GilaMonster (2/7/2014)
Koen Verbeeck (2/7/2014)
Ed Wagner (2/7/2014)
That's one thing I really enjoy about SSC. The people here aren't paid to answer questions. We do it because we enjoy doing it, which improves the quality of the answers.You only get paid here if you're above 10,000 points.
Paid in T-shirts.
I don't have a T-shirt...
Whoa, wait. Hang on. T-shirt(s) with a plural? I haven't even received one. I demand my back pay.
STRIKE! STRIKE!
Keep talking like that and you'll have to send Steve a T-Shirt. 😉
February 7, 2014 at 7:31 am
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?
Word is that there are photos of a shirtless Grant from SQL Cruise, so you don't necessarily have to imagine that part.
Jason Wolfkill
February 7, 2014 at 7:34 am
Ed Wagner (2/7/2014)
I like the new "mark as answer" functionality. The green threw me at first, but it sure did draw attention to the post, which is the intent. I was relieved to see that the code blocks kept the white background. Having SQL code against the green background would have been rough. There sure is a lot of green on Sean's thread. Maybe it would be better to just make the background green on the header of the post. Then again, I have only one voice of many and I'm not even sure how it would look. Maybe it's distracting because it's still new. Either way, nice job on new functionality.
I think the reason the entire post is green is because it seems that some people can't quite figure out which post is which. At least that seems the case given how many people refer to other posters by their "points title".
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 7, 2014 at 7:38 am
GilaMonster (2/7/2014)
Paid in T-shirts.
That's how Experts Exchange used to work--you'd get free shirts if you got enough points for answering questions! No idea if they still do that, been a while since I was active over there.
February 7, 2014 at 7:38 am
Sean Lange (2/7/2014)
Ed Wagner (2/7/2014)
I like the new "mark as answer" functionality. The green threw me at first, but it sure did draw attention to the post, which is the intent. I was relieved to see that the code blocks kept the white background. Having SQL code against the green background would have been rough. There sure is a lot of green on Sean's thread. Maybe it would be better to just make the background green on the header of the post. Then again, I have only one voice of many and I'm not even sure how it would look. Maybe it's distracting because it's still new. Either way, nice job on new functionality.I think the reason the entire post is green is because it seems that some people can't quite figure out which post is which. At least that seems the case given how many people refer to other posters by their "points title".
Good point. I didn't consider that, probably because I'm familiar with the site. I do think it's a positive addition to the site. I'm still glad the quoted SQL isn't on a green background.
February 7, 2014 at 7:39 am
Sean Lange (2/7/2014)
Ed Wagner (2/7/2014)
I like the new "mark as answer" functionality. The green threw me at first, but it sure did draw attention to the post, which is the intent. I was relieved to see that the code blocks kept the white background. Having SQL code against the green background would have been rough. There sure is a lot of green on Sean's thread. Maybe it would be better to just make the background green on the header of the post. Then again, I have only one voice of many and I'm not even sure how it would look. Maybe it's distracting because it's still new. Either way, nice job on new functionality.I think the reason the entire post is green is because it seems that some people can't quite figure out which post is which. At least that seems the case given how many people refer to other posters by their "points title".
They still do that 🙂 They also have polo's.
MSSQLTips.com also gives away T-Shirts. I have them in all sorts of sizes.
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 7:40 am
wolfkillj (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?Word is that there are photos of a shirtless Grant from SQL Cruise, so you don't necessarily have to imagine that part.
I don't think so. I even wore a shirt swimming so I could hide my tender white New England flesh from the sun. But hey, I'll take one and post it if you guys want.
"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 7:48 am
Grant Fritchey (2/7/2014)
wolfkillj (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?Word is that there are photos of a shirtless Grant from SQL Cruise, so you don't necessarily have to imagine that part.
I don't think so. I even wore a shirt swimming so I could hide my tender white New England flesh from the sun. But hey, I'll take one and post it if you guys want.
No no that's ok. We are fine writhing pain just imagining it. :w00t:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 7, 2014 at 7:49 am
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...
😉
February 7, 2014 at 7:51 am
So, I have to ask a really, really, really dumb question, that I'm 99.99999% sure I know the answer too...
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?
February 7, 2014 at 7:55 am
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.
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
February 7, 2014 at 7:58 am
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. 🙂
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
February 7, 2014 at 8:00 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.
Gotta love working someplace where a nearly extreme edge-case scenario like that then, needs to be treated as if it were as likely as Jimmy-Joe-Bob in Accounting getting his boss' password to the accounting system...
February 7, 2014 at 8:18 am
GilaMonster (2/7/2014)
Koen Verbeeck (2/7/2014)
GilaMonster (2/7/2014)
Koen Verbeeck (2/7/2014)
Ed Wagner (2/7/2014)
That's one thing I really enjoy about SSC. The people here aren't paid to answer questions. We do it because we enjoy doing it, which improves the quality of the answers.You only get paid here if you're above 10,000 points.
Paid in T-shirts.
I don't have a T-shirt...
Neither do I. We should complain to management.
Uprising coming. Get the pitch forks.
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 - 42,856 through 42,870 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply