Can you please clarify? What are you saying "works among whom"?

Here is how you would select rows from a table where a column named date_column had a value...

Is this a trick question? Input/Output, meaning disk activity?

No problem. Happy something I said was useful 🙂

I am curious...I am not sure what you mean. Maybe it would help if I knew your standard for OS-dependent,...

You highlight a sad but true fact about technical managers.

I have found that for the most part...

This thread seems to have hit a stopping point and I have no specific technical information to lend but this looked weird so I thought I would call it out:

INSERT...

Performance? I gotta go with a "maybe" (or at least IMHO :-P). On another link, you said it was only about a 10% gain in performance (which isn't...

Whisper9999 (6/27/2011)

---

I've got a large table (70+G) with an identity column. I want to rebuild the table using paritioning but don't want to lose the identity or the existing...

You beat me to it Tom...I was just testing the theory of having all 10 in a Sequence Container (concurrent execution) with the 11th package connected to it with a...

Like it matters...its referencing query optimizations for Sybase 11.0 (the current version is 15.5) and the article was written around the time when MSSQL 6.5 was coming out...years after the...

I don't think you'll be able to go directly from Service Broker to the Windows Service but please let us know if you find a way to do that because...

Hmmm, something must be out of order on your side. I tested the technique before I posted. Here is my POC code:

USE tempdb

GO

CREATE PROC dbo.proc_a

AS

BEGIN

SELECT...

steveb. (6/28/2011)

---

Jayanth_Kurup (6/28/2011)

---

I found the below article on the usage of greater than vs greater than or equal to

http://www.lcard.ru/~nail/sybase/perf/18295.htm

The logic seems sound but i doubt if i will...

Very true, I knew and should have mentioned that the proc was dropped from the product in 2008.