| Author |
 Topic  |
|
russell
Pyro-ma-ni-yak
USA
5037 Posts |
 Posted - 05/06/2011 : 08:01:26
|
| Wow |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29156 Posts |
Posted - 05/25/2011 : 01:52:09
|
I found a new article written in the future. Today is May 25 and the article is written June 1 so perhaps the writer knowns things not yet public?quote:
If the server and the database properly configured and maintained, the DBA or developer doesn't have to worry about locking or at least very, very rarely.
Source here.
N 56°04'39.26"
E 12°55'05.63" |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
7007 Posts |
Posted - 05/25/2011 : 05:47:50
|
quote:
Originally posted by Peso
I found a new article written in the future. Today is May 25 and the article is written June 1 so perhaps the writer knowns things not yet public?quote:
If the server and the database properly configured and maintained, the DBA or developer doesn't have to worry about locking or at least very, very rarely.
Source here.
N 56°04'39.26"
E 12°55'05.63"
That's all explained if you Order SQL 2008 GRAND SLAM Today!
CODO ERGO SUM |
|
|
|
elwoos
Flowing Fount of Yak Knowledge
United Kingdom
2040 Posts |
Posted - 05/26/2011 : 06:14:38
|
quote:
Originally posted by Peso
I found a new article written in the future. Today is May 25 and the article is written June 1 so perhaps the writer knowns things not yet public?quote:
If the server and the database properly configured and maintained, the DBA or developer doesn't have to worry about locking or at least very, very rarely.
Source here.
N 56°04'39.26"
E 12°55'05.63"
Pity he doesn't give next weeks lottery numbers
-----------
If debugging is the process of removing software bugs, then programming must be the process of putting them in. |
|
|
|
uberman
Posting Yak Master
153 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
7007 Posts |
Posted - 05/26/2011 : 11:05:46
|
quote:
Originally posted by uberman
I'm not sure, does this qualify for inclusion?
http://www.sql-server-performance.com/2011/order-by-nolock/
Twit Summary: I rely on things being ordered without relying on orderby?
Exec Summary: sometimes things aren't ordered how you like if you don't use orderby?
This:
"You need to have an explicit ORDER BY clause if you need the data to be ordered according to clustered index with the NOLOCK hint."
should really just be:
"You need to have an explicit ORDER BY clause if you need the data to be ordered."
CODO ERGO SUM |
|
|
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
Posted - 05/27/2011 : 04:09:13
|
quote:
Originally posted by uberman
I'm not sure, does this qualify for inclusion?
http://www.sql-server-performance.com/2011/order-by-nolock/
Twit Summary: I rely on things being ordered without relying on orderby?
Exec Summary: sometimes things aren't ordered how you like if you don't use orderby?
Felt the need to comment.  |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 05/27/2011 : 08:25:48
|
I commented yesterday. Comment is still sitting 'waiting moderation'.
At a guess, this is another author who doesn't tolerate dissenting opinions
--
Gail Shaw
SQL Server MVP |
Edited by - GilaMonster on 05/27/2011 08:27:45 |
|
|
|
Lumbago
Norsk Yak Master
Norway
3246 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29156 Posts |
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 05/28/2011 : 06:14:58
|
It was claiming that if you wanted order by the clustering index key then you only needed order by if nolock was used.
--
Gail Shaw
SQL Server MVP |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
7007 Posts |
Posted - 06/23/2011 : 01:55:46
|
Does Celko just drop by to insult a random poster as an excuse to post signature spam for his books?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=162155
How is this load of BS helpful to any one, except as a spam vector?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=162162
"I had posted a history of the infixed notation from my ANSI X3H2 days and I don't feel like looking for it right now. The difference is "syntactic sugar" and they will both compile to the same plan. We had to define the [LEFT | FULL | RIGHT] OUTER JOIN as an infixed operator for mathematical reasons. It then became easy to define INNER JOIN, OUTER UNION and a bunch of other features in the same paper. So we did! Committee are like that ..
Weaker SQL programmers use INNER JOIN, since it is sequential and a familiar, procedural infix binary operator. Stronger SQL programmers use the WHERE syntax because it is set-oriented, obeys the law of proximity and is an n-ary operator. Again, I have the details but basically, it is the mindset of someone who write with a + and someone who writes with a Capital Sigma when they add sets of values."
CODO ERGO SUM |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 06/23/2011 : 02:52:04
|
Yes.
--
Gail Shaw
SQL Server MVP |
|
|
|
Lumbago
Norsk Yak Master
Norway
3246 Posts |
|
|
Lumbago
Norsk Yak Master
Norway
3246 Posts |
|
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
Posted - 06/23/2011 : 06:14:08
|
| Lumbago, if only there was a like button. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
7007 Posts |
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 06/23/2011 : 12:57:38
|
I feel the same way, you can look at some of my recent replies to Joe to see that.
--
Gail Shaw
SQL Server MVP |
|
|
|
webfred
Flowing Fount of Yak Knowledge
Germany
8529 Posts |
Posted - 06/23/2011 : 13:08:12
|
Isn't that blasphemy? Isn't Joe a kind of god?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Transact Charlie
Flowing Fount of Yak Knowledge
United Kingdom
3448 Posts |
Posted - 06/23/2011 : 13:50:44
|
quote:
Originally posted by webfred
Isn't that blasphemy? Isn't Joe a kind of god?
He's not the Messiah - he's a Very Naughty Boy
Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
Edited by - Transact Charlie on 06/23/2011 13:51:06 |
|
|
|
Topic |
|
Twit List
