You're welcome...Happy to...

I guess my thought would be - why does it have to be just ONE person's issue? The business owner has all of the rules, the designer has the...

either declare @radius as a varchar (if you're not using it anywhere else), or CAST it to varchar in the set @sql statement.

either:

declare @sql nvarchar(4000)

declare @radius varchar(10)

set @radius = '6378.1'

--...

Try something like this:

declare @g datetime

declare @startdate datetime

declare @enddate datetime

select @g=cast('11/26/2007' as datetime)

select

date

from

t_date

where

date between

dateadd(day,1,cast(floor(cast(@g as money)) as datetime))

and

dateadd(day,7-(cast(floor(cast(@g as money)) as bigint)+1)%7

,cast(cast(floor(cast(@g as...

Also (for the next time):

If someone is hell-bound to keep you, then make sure that they pay for said privilege. In other words, I don't think it's at all...

Did you turn on advanced options? AFAIK - that's required.

Try this script:

use master

Go

exec sp_configure 'show advanced options', 1;

Go

RECONFIGURE;

GO

exec sp_configure 'max server memory (MB)', 700;--or whatever number you wish

GO

RECONFIGURE;

You need to set up the Maximum size in memory setting for SQL server. If you don't have >1024MB, it's entirely possible that some big process will prompt SQL...

...which yields on my system:

==============================================================================

Testing lookup for non-0 Ints in non-nullable column...

(Note: this test will always be slow on first test... no statistics built up

00:00:00:310 Duration (hh:mi:ss:mmm)

------------------------------------------------------------------------------

Testing lookup for non-Null...

CLR integration does NOT work in Visual Studio Express or any of its components. In order to use CLR integration, you need to be licensed for Visual Studio Professional,...

Why use a cursor at all? Cursors usually destroy performance. The fact that you're running 13,000 queries against ProspectResearch doesn't help either.

Using an actual set-based option - this...

Keep in mind that by allowing SQL Server to use 600MB, you've now restricted the OS to 168MB of RAM. if that's a 2003 box - that's 88MB shy...

CHAR fields set to nullable will be handled as VARCHAR if the ANSI_PADDING is turned off. If the ANSI_PADDING is NOT turned off, the same amount of space is...

Brandie Tarvin (11/28/2007)

---

Clive,

They didn't introduce just one new cert. They introduced 4 of them. @=) All new SQL Server 2005 certification information can be found at the following...

Jeff Moden (11/28/2007)

---

Once that were accomplished, then I believe there would be no need for separate tables or databases for each Location. Simply add the LocationID to most of...

Well - considering it's on their machine - I'm not sure how much of a security hole you might be worried about. After all - if the workstation isn't...