Jeffrey Williams (8/10/2008)

---

For example, if you are going to be storing a lot of documents (thousands) - you probably wouldn't want to store them in the database. You probably...

Jack Corbett (7/30/2008)

To broadly generalize and call someone a luddite (one who is opposed to especially technological change - Mirriam-Webster Dictionary) because they take a stand on something or have...

HOORAH! Thanks for supporting common sense development, and not mind-numbing, one-solution-fits-all rules ("all sprocs, all the time"). It is always amazing to meet up with a "wizard" (aka...

kevriley (4/15/2008)

---

There is always 101 ways to do anything in t-sql - the trick (or more specifically, the skill) is knowing which is the right way:D

That's one of the attributes...

dominik.ladich (4/3/2008)

---

Even if SP 2 is the correct answer, I don't think it is correct, as I'm running a SQL 2005 SP 2 Client on Vista, which cannot display the...

Windows Vista 64-bit can use 128gb of memory for Ultimate, Business, and Enterprise editions (16gb/8gb for Home Premium/Basic). ...

You can check/remove duplicates as you are creating the inserts statements to push the data. Since the table is free from the new inserts coming in (whether you use...

Jeff; Interesting option you raise with using synonyms. My project was long before SQL 2005, so that option was not available at the time. But it would...

Yes, just a Create Table...

Yes, it may affect them. However, in the system I worked on, testing showed it to be the least likely to...

I had to do this for a project before, and each of the remote servers were over slow WAN links. Here's how I was able to do it best...

No, in SQL2000 you cannot have table names as variables in a procedure.

But you can create the SQL in a variable dynamically, and execute the SQL. For example...

This article is showing in today's newsletter as being updated. What is the update? I don't see any discernable difference?

I have to admit that I was mildly surprised when I heard the Rockies were going all-online for the World Series, but it will not be too long in the...

Wayne, that link points to the May 2007 update. Do you have a link to the September 2007 update?