I ran a few tests and found that there are only marginal differences beween most of them, except that the dateadd/datediff form takes about a third longer (on my test...

Does anyone know which uses least processing time?

The only time I've seen this done is in generated queries. That is, a query is built from selecting various options...

Can you elaborate?

A quick glance at info on the polyServe database utilitity would indicate that it's used to ease relocation of SQL instances between physical servers. VMs can be...

I must admit that until a few months ago, I hadn't considered how virtualization worked and had sort of assumed it was similar to emulation (like running old PDP-11 software...

One of the reasons I love these forums is that there's always something new to...

donald.jones (1/21/2008)

---

I have the same problem, with my data imported as nvarchar in the format MMDDYYYY (01012008, for example.) I get an out-of-range datetime value when I attempt the alter...

keywestfl9 (1/17/2008)

---

i have some fields in SQL Server table as nvarchar(50) and the user actually enters date (example : 02/05/07) now they want those fields to be converted to datetime...

I'd still be interested if there's an easier way, but my current solution is...

create table ##db_obj (

dbid int,

objectid int,

objname varchar(128)

)

/*

Temp table #T contains columns dbid(int) and objectid(int) with the values...

Thanks for the suggestion, but I'd...

Hi Steve,

Unfortunately that doesn't work.

On my test server,

"use scratch;select count(*) from sys.objects" returns 61

"use perf;select count(*) from sys.objects" returns 1609

I need a pointer to whatever sys.objects is looking at so...

In the UK, I've had a couple of jobs where criminal record checks were done (one was an organization which works almost exclusively with teenagers), but that's about it. Most...

Brent McCracken (1/10/2008)

---

I do have two...

Probably very inefficient...

create table #c (val varchar(10))

insert #c (val) values('003')

insert #c (val) values('003.1')

insert #c (val) values('003.2')

insert #c (val) values('003.3')

insert #c (val) values('003.31')

insert #c (val) values('003.32')

insert #c (val) values('003.33')

insert #c (val)...

Hi Jeff,

Just wanted to say that I too think this is a great article - well written with plenty of food for thought.

I've got several complex queries I need to...