Why not just ask it?

SELECT max_workers_count
FROM sys.dm_os_sys_info;

"I don't know why they made this decision instead of structuring things like this..."
Because ANSI SQL.

Much better article at http://rusanu.com/2010/03/26/using-tables-as-queues/

DELETE t

FROM dbo.mt_fact_scanned t JOIN

(SELECT recipient_id, time_id, sender_id, sender_ip, MAX(msg_count) MaxCount

FROM dbo.mt_fact_scanned

GROUP BY recipient_id, time_id, sender_id, sender_ip)x

ON t.recipient_id = x.recipient_id AND t.time_id = x.time_id

AND t.sender_id = x.sender_id AND...

Or you can wrap the param in the dynamic code.

Set @sql = 'SET @ss...

This is an interesting sequence of questions... :Whistling:

EXEC sp_helpdb;

You are on your own to break the sa password.

UPDATE t SET yield = b.yield + DATEDIFF(d,b.date,t.date)*1. / DATEDIFF(d,b.date,a.date) * (a.yield - b.yield)

FROM

dbo.mytable t JOIN

(SELECT id,

(SELECT TOP 1 id

FROM dbo.mytable

WHERE service = m.service AND...

Jeff Moden (9/16/2009)

---

The major problem with sequence tables of this nature is that no one considers what happens if you need to "reserve" more than one ID. When I...

SQL Server takes care of concurrency issues for you, which is reason to try and use it instead of write your own. As I write, one statement is an atomic...

You do not need most of that code. You can do it in one statement, and one statement is an atomic transaction.

CREATE PROCEDURE dbo.usp_GetNextNumber @pNumberRange AS nvarchar(20), @pNextValue AS int...

I guess the...

DC (8/19/2009)

---

A quick comment on the "4 tinyints" idea. It does depend on your situation, but having it predivided into octets can actually make subnet handling more difficult, or at...

rja.carnegie (8/19/2009)

---

lhowe (8/19/2009)

---

Darn it HansVE, you beat me to the punch! I was going to say exactly the same thing. I don't see why someone would go to...

nimdil (8/19/2009)

The idea with four columns - while not bad - has some flaws:

1. There is no merits with 1NF as IP address is a complete being. Would you store...

I store these as four tinyint columns. Also uses just four bytes but is human-readable, does not require all your conversions, has implicit validation, and better meets the 1NF...