I can’t believe that no one has mentioned having Microsoft implement true clustering for SQL Server. In other words, have a database active and processing requests on multiple active...

They certainly can...

You can just use the ROUND function to round the age up or down.

select

a.*,

RoundedAge = round(a.Age,-1)

from

( -- Test Data

select Age = 65 union all

select Age = 64 union all

select Age...

Ask them to explain exactly how those databases are a security risk.

They may just be taking some old-wives tale at face value.

I think I heard the same thing from our...

Not to rain on Colins parade, but the benefit that you get from compression of a Sharepoint content database backup may not be very much, because compression is highly dependant...

update MyTable

set

StartDate = dateadd(dd,datediff(dd,0,StartDate),'07:00:00.000')

where

StartDate = dateadd(dd,datediff(dd,0,StartDate),0)

If there is someone else with all the servers registered in SSMS 2008, you can have them export their server list, and you can import it.

The export file is XML,...

declare @emp table

(empid int identity(1,1) primary key clustered, dob datetime not null)

insert into @emp (dob)

SELECT convert(datetime,'1962-12-11 00:00:00.000') AS dob UNION ALL

SELECT convert(datetime,'1958-03-28 00:00:00.000') AS dob UNION ALL

SELECT convert(datetime,'1960-02-29 00:00:00.000') AS...

Money and decimal(19,4) do not do exactly the same thing in calculations, as the following code demonstrates:

select

a.*,

[DecDivision]= [DecMoney]/ convert(decimal(19,4),0.9999),

[MoneyDivision] = [MoneyMoney]/ convert(money,0.9999)

from

( -- Test Data

select

[DecMoney]= convert(decimal(19,4), 19.7777 ),

[MoneyMoney]= convert(money, 19.7777...

Why disable the foreign keys? Just load the data into the tables in the correct order.

The following script will show you the correct order to load the data.

Find Table...

alen teplitsky (9/1/2010)

---

stay put

i know someone that left a secure job that he thought he outgrew for a company that was on the verge of bankruptcy. except he didn't know...

The error message explains it fairly well, and it has nothing to do with filegroups.

That feature is only supported by Enterprise Edition or Developer Edition.

There is no reason why Developer Edition would prevent you from creating filegroups.

A CASE statement can only return one datatype.

select @@version