You can expect 3-5% higher CPU utilization.

The primary reason that the cost is so low is that...

Any chance you could tone your signature down a bit? Thanks!

I believe that the Maintenance Clean-up Task can only clean up backup files created directly by the Back...

gmamata7 (4/3/2010)

We have sql server 2005 EE x64 with SP3. For our production database, we have 1 mdf file & 7 ndf files of equal size in single Primary file...

I wonder if the server is clustered?

I seem to remember another possible cause related to domain membership, but can't pretend to be...

The record size of each row as the table is currently defined is 20 bytes.

Changing to CHAR(8) reduces the record size to 16 bytes. (20% smaller).

A...

There is a tutorial you might find useful here:

Consuming a Web Service from a SQL Server 2005 CLR Assembly[/url]

A very similar one, with pictures:

http://davidhayden.com/blog/dave/archive/2006/04/25/2924.aspx

Finally, a Microsoft sample:

http://msftengprodsamples.codeplex.com/wikipage?title=SS2005!Currency%20Web%20Service%20Sample&referringTitle=Home&ProjectName=msftengprodsamples

Personally, I am not...

I seem to recall that this might be caused by having a space after the server name in the connection string, but there might be many possible causes.

There are answers...

Pretty normal, yes. ...

DECLARE @Table

TABLE (

name SYSNAME NOT NULL,

...

[font="Verdana"]Easily resolved with[/font] OPTION (MAXRECURSION ?)

It's certainly arguable 😉

On the other hand, there is an element of "well, we...

Hmmm...nasty!

The DATEADD/DATEDIFF method (using a variable for layout purposes):

DECLARE @Base DATETIME;

SET @Base = CONVERT(DATETIME, '1900-01-01T00:00:00.000', 126);

SELECT DATEADD(DAY, (DATEDIFF(DAY, @Base, GETDATE())), @Base);

With which method Peter?

FLOAT -> INT is a truncate, so should be ok?

DATETIME -> INT...