not really - in sql 2000 it was an enterprise edition...

hmm

but the funny thing is that yesterday the query was working fine.... what can have changed to make the showcontig stall ?

i simplified the code just to match the CTE i wrote for you, but it would look a little like this

with x (mon,monid) as

(select DATENAME(month,1) as month,1 as monid

UNION...

sanujss (5/23/2012)

---

Hi,

I am working on a GPS related issue. There is a table where we keep geographical information of vehicles tracked using GPS devices. This devise will be sending...

Sachin 80451 (5/23/2012)

---

I have the following scripts which gets me all the data from a table. But I want to shows months such as December and January which currently dont...

this is something that itzik ben-gan demos at some of conferences he talks at

he's doesn't say don't use read uncommitted, just know when and where to use it and be...

perry - could you post the update command you are trying to perform, and also the structure of the table and all indexes on it.

we can't really assist without this

i tried the following and found by turning on Client statistics and sql profiler that my version using RIGHT performs consitantly better by a very small margin

create table #temp(emailid varchar(100))

insert...

Usman Butt (5/23/2012)

---

First of all, let me make it clear, I am not against the CLR integration at all 😉 It serves much better than TSQL in some scenarios.

But...

krypto69 (5/22/2012)

---

I have a local site (production) and I have a DR site located many states away.

Thanks to the help from this site, I setup mirroring. Which worked fine until...

SQL Kiwi (5/23/2012)

---

dwain.c (5/23/2012)

---

I've seen (dramatically) how WITH SCHEMABINDING improves the performance of a Scalar Valued Function. I'm wondering if the same is true for TVFs and what is...

from the link i posted - hence my original posting

A database mirroring session runs with either synchronous or asynchronous operation. Under asynchronous operation, the transactions commit without waiting for the...

my bad there (oops) - i was just trying to find the link that describes the difference between high performance and high safety and accidentally hit post!

see the following link

http://msdn.microsoft.com/en-us/library/ms189852.aspx

post deleted because it was wrong (oops) 🙂

the other thing to consider is do you want to do CI (continuous integration) builds on your checked in code......