Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

WAITFOR Expand / Collapse
Author
Message
Posted Thursday, December 23, 2010 5:21 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:37 PM
Points: 5,471, Visits: 23,521
Tom.Thomson (12/23/2010)
Mauve (6/17/2008)
I somewhat disagree that a TIMEOUT can be used to end a WAITFOR. It cannot be used independently and is only an optional modifier of the Service Broker message.

I agree with Mauve, you can wait for a message or you can wait for whichever comes first, a message of a timeout, but you can't wait for just a timeout.


Bored, not enough to do?

visiting these QODs almost a year and a half after they were original posted..

Suggestion .. put your vast knowledge of SQL to a useful purpose for the community ... write a couple of articles .... pass some of your vast knowledge to others.



If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1038979
Posted Friday, December 24, 2010 3:47 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 8:37 AM
Points: 8,287, Visits: 8,738
bitbucket-25253 (12/23/2010)
[Bored, not enough to do?

visiting these QODs almost a year and a half after they were original posted..

Just working backwards through all questions because it helps me learn about the new things that have happened since SQLServer 2000. I have a little experience playing with SQL 2008 (as that's where I decided out system would go) but not much as the transition was at the experiment and verify stage (experiment because I wanted to be sure any relevant and useful new features got used, the port would involve rework) but none of SQL 2005 (I decided we would skip it - platform upgrades were an absolute nightmare in our business, because our customer contracts didn't allow us to force customers to take new releases of third party software that would require new licenses - I could install service packs and bug-fixes and free upgrades to my heart's content and with pretty minimal notice to the customer, and of course push out new releases of our software provided the upgrade was seamless and I wasn't demanding extra money on top of our monthly fees, but not new versions of SQL Server or Win Server or the Win Clients unless we could find the license money ourselves - we had badly drawn up contracts).

Suggestion .. put your vast knowledge of SQL to a useful purpose for the community ... write a couple of articles .... pass some of your vast knowledge to others.


I doubt if articles about my views on normalisation or on how to build nearly secure systems with SQL 2000 (obsolete and not interesting), or deadlock detection algorithms (where I was state-of-the-art about 20 years ago, but decidedly past my sell-by date now) or relational theory would be much help to anyone, these things probably are relevant in short comments in response to material that turns up in various SQLC forums but aren't the right material for articles. I intend to put together some more QoTDs when I get around to it, and maybe some articles when I feel more competent on some form of SQL Server that's more relevant to the modern world (SQLS 2008 R2 Express, or SQL 2008 R2 generally and maybe Denali when I've upgraded my toys to Win 7 and had some time using them). Anyway, I'd probably feel absolutely stupid writing articles for a forum supported by people like Jeff and Paul and Gail and Barry and Gus and various others, who know vastly more than I do.


Tom
Post #1039076
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse