524,258 terabytes

Let us know if that limit becomes a problem.

It would by handy if SQL Server had an enhanced IsNumeric function that you could pass a specific target data type to, but that's the way it is for now.

Are you asking for help optimizing code you did not post?

The first condition will allow use of an index on the Date_Column, and the second will compare the combined date and time columns to 24 hours before current time for...

Joe Celko (7/22/2010)

---

Actually, using the proprietary MONEY is a huge problem. It does not divide or multiply correctly. It does...

Adam Haines (7/21/2010)

---

No need for a computer column here. You should use the like operator.

DECLARE @t TABLE(

col VARCHAR(10)

);

INSERT INTO @t VALUES ('13abc');

INSERT INTO @t VALUES ('1abcde');

SELECT *

FROM @t

where col...

TravisDBA (7/21/2010)

---

Really? I find that...

PaulB-TheOneAndOnly (7/20/2010)

---

Yes indeed but - always a "but" huh? - the other "more complex" way is...

Vaghasiya Nilesh (7/19/2010)

---

Thank u guys...

and one more thing my week is strat from saturday to friday

and im enter today's date that giving me output will be like this:

(dd/mm/yyyy)

10/7/2010 -...

Wouldn't this be a simpler calculation?

COST = [Total Pageviews] * 0.000005

Sounds like no one read his follow-up post on the blog:

"...However, in this case we had been on a couple calls with EMC about this and even had their top...

select

a.DT,

Date_Only = dateadd(dd,datediff(dd,0,a.DT),0),

Time_Only = a.DT-dateadd(dd,datediff(dd,0,a.DT),0)

from

( -- Test Data

select DT = convert(datetime,'1753-01-01 00:00:00.003')

union all

select DT = convert(datetime,'1753-01-01 07:21:09.997')

union all

select DT = convert(datetime,'1753-01-01 23:59:59.997')

union all

select DT = getdate()

union all

select DT =...

If you have another server available that is running a 32-bit OS, you could schedule jobs that require 32-bit ODBC drivers to run on that server.

Jobs normally run in the context of the SQL Server Agent service.

Edit:

Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service

http://support.microsoft.com/kb/942176

Google is your...

That may be of...