You will probably need to use the image data type for mp3s.

--Jonathan

The difference between decimal and numeric is part of the ANSI SQL spec and doesn't pertain to SQL Server. It basically states that the precision of a decimal data...

It's the Text property of the DMO column object's DRIDefault property.

--Jonathan

Probably more than you want to know, but there's a paper (Automating Statistics Management for Query Optimizers) on this from the developers of the Index Tuning Wizard.

--Jonathan

The SQLServer:Cache Manager counters, including Cache Hit Ratio are for cached objects, not data pages. The SQLServer:Buffer Manager|Buffer cache hit ratio counter is for cached data pages, as are...

Good article, Frank.

But I think you're mistakenly mixing data atomicity into Codd's Information Rule. I didn't check your sources, but decomposition is a function...

Insert the exceptions into a temporary table and then delete the rows that don't have IDs in the temporary table.

--Jonathan

FLOOR(SUM(DATEPART(hh,TimeCol))+SUM(DATEPART(n,TimeCol))/60)+(SUM(DATEPART(n,TimeCol))%60)/100.

--Jonathan

quote:

---

quote:

---

If you're bottlenecked on I/O (typical of writes in an OLTP environment), then you've...

quote:

---

The only real answer is "test", but my two cents --

The biggest issue in how this works is what they are...

quote:

---

I bet Jonathan will post PARSENAME stuff.

Frank

---

No, Noel's way is better than PARSENAME for this...

Why not just use an associative table with the payment PK and debit instruction PK?

--Jonathan

Can't you use your report writer for this?

SELECT RIGHT(CONVERT(char(10),GETDATE(),103),7)

--Jonathan

I'm guessing it's this.

--Jonathan

quote:

---

Yes, and here are my test cases.

---

Interesting; I stand corrected with data like this....