SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 Twit List
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 88

russell
Pyro-ma-ni-yak

USA
5071 Posts

Posted - 05/06/2011 :  08:01:26  Show Profile  Visit russell's Homepage  Reply with Quote
Wow
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 05/25/2011 :  01:52:09  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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"
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 05/25/2011 :  05:47:50  Show Profile  Reply with Quote
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
Go to Top of Page

elwoos
Flowing Fount of Yak Knowledge

United Kingdom
2048 Posts

Posted - 05/26/2011 :  06:14:38  Show Profile  Reply with Quote
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.
Go to Top of Page

uberman
Posting Yak Master

158 Posts

Posted - 05/26/2011 :  10:48:30  Show Profile  Reply with Quote
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?


Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 05/26/2011 :  11:05:46  Show Profile  Reply with Quote
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
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3603 Posts

Posted - 05/27/2011 :  04:09:13  Show Profile  Reply with Quote
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.
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 05/27/2011 :  08:25:48  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 05/28/2011 :  03:19:31  Show Profile  Reply with Quote
The article is actually deleted now...what was the deal about it? Was it claiming that order by was only necessary if nolock was used?

- Lumbago
My blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 05/28/2011 :  03:35:34  Show Profile  Visit SwePeso's Homepage  Reply with Quote
www.sql-server-performance.com/2011/order-by-nolock/+site:sql-server-performance.com+order+by+nolock&cd=1&hl=sv&ct=clnk&gl=se&source=www.google.se" target="_blank">http://webcache.googleusercontent.com/search?q=cache:qn3tn_8vG90J:www.sql-server-performance.com/2011/order-by-nolock/+site:sql-server-performance.com+order+by+nolock&cd=1&hl=sv&ct=clnk&gl=se&source=www.google.se



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 05/28/2011 :  06:14:58  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 06/23/2011 :  01:55:46  Show Profile  Reply with Quote
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
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 06/23/2011 :  02:52:04  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Yes.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 06/23/2011 :  03:14:26  Show Profile  Reply with Quote
I think my comments in this thread reveals my opinion quite clearly:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=160993

- Lumbago
My blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 06/23/2011 :  03:21:51  Show Profile  Reply with Quote
How about one of the mod's run an update in the sqlteam database replacing his signature with "**spam**" or something? Seriously. It pisses me off *every single time* I see him replying to something.

- Lumbago
My blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3603 Posts

Posted - 06/23/2011 :  06:14:08  Show Profile  Reply with Quote
Lumbago, if only there was a like button.
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 06/23/2011 :  09:53:28  Show Profile  Reply with Quote
quote:
Originally posted by Lumbago

I think my comments in this thread reveals my opinion quite clearly:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=160993

- Lumbago
My blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/


"...You suck Joe, go retire or something."







CODO ERGO SUM
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 06/23/2011 :  12:57:38  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
I feel the same way, you can look at some of my recent replies to Joe to see that.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

webfred
Flowing Fount of Yak Knowledge

Germany
8679 Posts

Posted - 06/23/2011 :  13:08:12  Show Profile  Visit webfred's Homepage  Reply with Quote
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.
Go to Top of Page

Transact Charlie
Flowing Fount of Yak Knowledge

United Kingdom
3451 Posts

Posted - 06/23/2011 :  13:50:44  Show Profile  Visit Transact Charlie's Homepage  Reply with Quote
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
Go to Top of Page
Page: of 88 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000