I am not sure that blowing out a varchar(4000) conversion for lord knows what is a 'minor plan difference'!! 🙂

I bet the memory crap is happening for every...

GilaMonster (11/19/2009)

---

Do you have queries that filter on the combination of SSN + MyDataID or City + MyDataID?

p.s. That's a poor choice for a clustered index. See part 2 of...

bpatin (11/19/2009)

---

I've only worked on my own functions, and have looked at execution plans to compare the with and without. I have created some queries, without using functions, that had...

bpatin (11/19/2009)

---

I've seen the T-SQL for a maintenance plan (view only) with a disclaimer that it may not be exactly what the server will be executing, but see no way...

Dammit!! I thought I mentioned triggers up earlier in the thread but I don't see it. Something must have barfed in my...

Paul, I seem to recall other topics from the years whereby BIN collation was the way to go for efficiency reasons if that was your most important criteria.

asingh-773142 (11/18/2009)

---

To fast delete records with a "where" clause. You will have to do a little work but it is nothing compared the time it takes to delete the records.

Try...

And pretty much the entire value from just one thread too, eh?? Glad to have you onboard!

GSquared (11/18/2009)

---

Nadrek (11/18/2009)

---

Jeff Moden (11/17/2009)

You and another poster said about the same thing... I'm going to have to give it a try. Although it's not likely to have 8000 spaces...

And provide significant community benefit too!!

I especially dislike having to use a GUI to tediously redo by hand things such as maintenance plans that I might quickly do in an open-source platform with a text...

replication maybe?

Really starting to sound like you need either Microsoft support or a consultant on board to get this resolved.

One thing I have discovered is that functions can be very useful in simplifying queries, and equivalent functions can be written, with some accounting for language differences, for both SQL...

bpatin (11/17/2009)

---

Whatever the main premise of your article, you mentioned a "very simple four-way join" that "took ten times as long" in PostgreSQL as it did in SQL Server. ...

bwilliams-1049831 (11/17/2009)

---

Yes there is a top SQL screen.

You can view and sort by almost any parameter you wish. CPU time, Physical reads, Elapsed time, logical Reads etc.

When I am tunning...