July 23, 2014 at 7:35 am
Steve Jones - SSC Editor (7/22/2014)
That first one is great, Gail. And that was a great costume.
Having never been to SQLBits, what is the deal with the costumes there?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
July 23, 2014 at 8:42 am
WayneS (7/23/2014)
Steve Jones - SSC Editor (7/22/2014)
That first one is great, Gail. And that was a great costume.Having never been to SQLBits, what is the deal with the costumes there?
They have a themed party on Friday night. Optionally, you wear a costume. It's great fun.
"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
July 23, 2014 at 9:03 am
Crystal ball in the repair shop, ESP network down, what can one do?😛
😎
July 24, 2014 at 7:46 am
Grant Fritchey (7/23/2014)
WayneS (7/23/2014)
Steve Jones - SSC Editor (7/22/2014)
That first one is great, Gail. And that was a great costume.Having never been to SQLBits, what is the deal with the costumes there?
They have a themed party on Friday night. Optionally, you wear a costume. It's great fun.
Sounds like fun. I'll have to get there sometime.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
July 25, 2014 at 12:34 pm
WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate to use NOLOCK.
Most banking applications can safely use nolock because they are transactional in the business sense. You only write new rows, you never update them.
_______________________________________________________________
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/
July 25, 2014 at 12:42 pm
Sean Lange (7/25/2014)
WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate to use NOLOCK.Most banking applications can safely use nolock because they are transactional in the business sense. You only write new rows, you never update them.
Then why do you even need it?
July 25, 2014 at 12:45 pm
Sean Lange (7/25/2014)
WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate to use NOLOCK.Most banking applications can safely use nolock because they are transactional in the business sense. You only write new rows, you never update them.
Sorry for my ignorance... what is "SO"?
--Jeff Moden
Change is inevitable... Change for the better is not.
July 25, 2014 at 12:49 pm
Jeff Moden (7/25/2014)
Sean Lange (7/25/2014)
WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate to use NOLOCK.Most banking applications can safely use nolock because they are transactional in the business sense. You only write new rows, you never update them.
Sorry for my ignorance... what is "SO"?
Stack Overflow....
I am just shocked at the response. Now if it was something somebody posted and others corrected them it would be one thing. But it has tons of approvals and lots of people stating how accurate that is. :w00t:
It has been awfully quite around here lately so I figured I would venture into other realms. That place is scary. Lots of interesting opinions there for sure. There are some bright folks there but the general sense of it pretty much just sucks.
_______________________________________________________________
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/
July 25, 2014 at 12:53 pm
Jeff Moden (7/25/2014)
Sean Lange (7/25/2014)
WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate to use NOLOCK.Most banking applications can safely use nolock because they are transactional in the business sense. You only write new rows, you never update them.
Sorry for my ignorance... what is "SO"?
I thought that was Shockingly Obvious....
😎
July 25, 2014 at 1:18 pm
Eirikur Eiriksson (7/25/2014)
Jeff Moden (7/25/2014)
Sean Lange (7/25/2014)
WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate to use NOLOCK.Most banking applications can safely use nolock because they are transactional in the business sense. You only write new rows, you never update them.
Sorry for my ignorance... what is "SO"?
I thought that was Shockingly Obvious....
😎
Or Seriously Overrated.
_______________________________________________________________
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/
July 25, 2014 at 1:25 pm
Sean Lange (7/25/2014)
Eirikur Eiriksson (7/25/2014)
Jeff Moden (7/25/2014)
Sean Lange (7/25/2014)
WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate to use NOLOCK.Most banking applications can safely use nolock because they are transactional in the business sense. You only write new rows, you never update them.
Sorry for my ignorance... what is "SO"?
I thought that was Shockingly Obvious....
😎
Or Seriously Overrated.
Seriously.....doesn't even begin to grasp it. There are of course some very good contributors there but (excuse the pun) seriously, the level of noise and animal dropping like substance answers is far too high.
😎
July 25, 2014 at 1:31 pm
Eirikur Eiriksson (7/25/2014)
Sean Lange (7/25/2014)
Eirikur Eiriksson (7/25/2014)
Jeff Moden (7/25/2014)
Sean Lange (7/25/2014)
WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate to use NOLOCK.Most banking applications can safely use nolock because they are transactional in the business sense. You only write new rows, you never update them.
Sorry for my ignorance... what is "SO"?
I thought that was Shockingly Obvious....
😎
Or Seriously Overrated.
Seriously.....doesn't even begin to grasp it. There are of course some very good contributors there but (excuse the pun) seriously, the level of noise and animal dropping like substance answers is far too high.
😎
No kidding. I figured I would setup an account and venture around a bit but wow. I never realized how shockingly bad most sql people are. My SSC shaded glasses have led me to believe that most people have a clue...wow!!!
_______________________________________________________________
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/
July 25, 2014 at 2:34 pm
Sean Lange (7/25/2014)
Eirikur Eiriksson (7/25/2014)
Sean Lange (7/25/2014)
Eirikur Eiriksson (7/25/2014)
Jeff Moden (7/25/2014)
Sean Lange (7/25/2014)
WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate to use NOLOCK.Most banking applications can safely use nolock because they are transactional in the business sense. You only write new rows, you never update them.
Sorry for my ignorance... what is "SO"?
I thought that was Shockingly Obvious....
😎
Or Seriously Overrated.
Seriously.....doesn't even begin to grasp it. There are of course some very good contributors there but (excuse the pun) seriously, the level of noise and animal dropping like substance answers is far too high.
😎
No kidding. I figured I would setup an account and venture around a bit but wow. I never realized how shockingly bad most sql people are. My SSC shaded glasses have led me to believe that most people have a clue...wow!!!
The thread had posters talking about page splitting, reading through transactions, etc. The fellow even said you could get erroneous reads.
I like SO, its got a wide range of topics, and they crowdsource the nuts out.
July 25, 2014 at 2:39 pm
patrickmcginnis59 10839 (7/25/2014)
Sean Lange (7/25/2014)
Eirikur Eiriksson (7/25/2014)
Sean Lange (7/25/2014)
Eirikur Eiriksson (7/25/2014)
Jeff Moden (7/25/2014)
Sean Lange (7/25/2014)
WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate to use NOLOCK.Most banking applications can safely use nolock because they are transactional in the business sense. You only write new rows, you never update them.
Sorry for my ignorance... what is "SO"?
I thought that was Shockingly Obvious....
😎
Or Seriously Overrated.
Seriously.....doesn't even begin to grasp it. There are of course some very good contributors there but (excuse the pun) seriously, the level of noise and animal dropping like substance answers is far too high.
😎
No kidding. I figured I would setup an account and venture around a bit but wow. I never realized how shockingly bad most sql people are. My SSC shaded glasses have led me to believe that most people have a clue...wow!!!
The thread had posters talking about page splitting, reading through transactions, etc. The fellow even said you could get erroneous reads.
I like SO, its got a wide range of topics, and they crowdsource the nuts out.
This might be from the objectionable post (just guessing, no links were posted)
Getting the account balance temporarily wrong isn't a big deal, that is what the end of day reconciliation is for. And an overdraft from an account is far more likely to occur because two ATMs are being used at once than because of a uncommitted read from a database.
He might have a point here, isn't that what folks talk about regarding partitioned mode? Granted, he doesn't take into consideration page splits but that was also mentioned in the thread, so folks are covering the topic at least.
July 25, 2014 at 2:44 pm
patrickmcginnis59 10839 (7/25/2014)
Sean Lange (7/25/2014)
Eirikur Eiriksson (7/25/2014)
Sean Lange (7/25/2014)
Eirikur Eiriksson (7/25/2014)
Jeff Moden (7/25/2014)
Sean Lange (7/25/2014)
WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate to use NOLOCK.Most banking applications can safely use nolock because they are transactional in the business sense. You only write new rows, you never update them.
Sorry for my ignorance... what is "SO"?
I thought that was Shockingly Obvious....
😎
Or Seriously Overrated.
Seriously.....doesn't even begin to grasp it. There are of course some very good contributors there but (excuse the pun) seriously, the level of noise and animal dropping like substance answers is far too high.
😎
No kidding. I figured I would setup an account and venture around a bit but wow. I never realized how shockingly bad most sql people are. My SSC shaded glasses have led me to believe that most people have a clue...wow!!!
The thread had posters talking about page splitting, reading through transactions, etc. The fellow even said you could get erroneous reads.
I like SO, its got a wide range of topics, and they crowdsource the nuts out.
Yes but him suggesting that NOLOCK is acceptable for banking applications is plain and simply wrong. It make no difference that there are only inserts. When dealing with money it is unacceptable and unethical (assuming you understand the ramifications). That kind of thing continues the myths of that hint. That particular hint is a sort topic for me because I first hand had to deal with real world issues based on its overuse in a financial application.
I am probably jaded towards SSC but SO just seems to lack a lot of the professionalism that I have come to expect from here. I was chastised on there when I provided a set based solution to somebody using a cursor when there was no reason because "that wasn't part of the question". Seems that sharing knowledge is frowned upon unless the OP asks. Meh!
_______________________________________________________________
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/
Viewing 15 posts - 44,761 through 44,775 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply