Yeah, so did I. I see what happened now.

John

Sorry, I don't understand. What CAST to nvarchar(800)? Is there a typo in the question?

John

msbasssinger (5/28/2008)

---

What is it that the proponents of AGCC want? More government intrusion into telling me what I can drive, how it has to be built, how I use...

Yes, use OUTER JOINs instead of INNER JOINs where appropriate.

John

msbasssinger (5/28/2008)

---

[font="Tahoma"]First, it is not the overwhelming majority of the scientific community. When you narrow it down to scientists with expertise in closely related fields, they are quite divided....

Wouldn't be the first time. Remember the new Ice Age (global cooling)? Science is not a democracy. Scientists discover things daily that change what they thought was...

msbasssinger (5/28/2008)

---

[font="Tahoma"]A free people are always free to investigate the facts, which is why so many Americans know the whole anthropogenic global climate change issue is a hoax and a...

Probably the best way would be to create a "numbers" or "tally" table. Search this site for how to do that and examples of what it can be used...

Joseph

No, the same limits don't apply to SQL 2005. Have a look on the Microsft website to see what the limits are. Have you checked that you have...

Mmmm... we're really looking for table DDL in the form of CREATE TABLE statements and sample data in the form of INSERT statements. But anyway, looking at the snippet...

Joseph

You're right about what the /3GB switch does, but if your application can't use all the memory available to it then it won't. SQL 2000 Standard can only use...

Joseph

SQL Server 2000 Standard will only use 2GB whatever you do. That's the theoretical maximum - more often you see something like the 1.7GB you are witnessing.

John

Excellent article, Frédéric. I have recommended this to people in the past.

One thing I don't quite understand about the left and right bounds. Suppose I wanted to add...

One way of doing it is to build a script to perform the reindexing and then run it. Here's some pseudo code; yours will no doubt end up more...

Reindexing automatically updates the statistics, so you don't need to include both. I don't know exactly how a maintenance plan decides what it is going to reindex, but if...