You don't use the data file, you specify a connection to the Server.

Open View -> Server Explorer.

Right click on Data Connections -> Add Connection.

Select...

RBarryYoung,

Just curious why you don't use DBNull.Value? The other thing would be to set a default value in the SP to null as in:

create procedure insertproc

(

@datetimevar datetime = null

)

and...

Noel,

If you feel sporty one time, try the rebuild for one table over the update stats command. From everything I am getting it is going to be faster with...

You might also reconsider your security model and the permissions people have if you are having an issue with something like a column being added to a table and no...

The best bet to get a true answer to this question is call the licensing folks at:

Licensing –Microsoft, Contact

(800) 426-9400

I would think the answer is no, but I am...

Lynn Pettis (12/26/2008)

---

Jack,

Actually, no I haven't. A friend of mine did some research and it seems that there have been a few others that have had similiar issues with...

noeld (1/6/2009)

---

On VLDB you should NEVER run DBCC CHECKDB because it does simply too much. You can split the checks (ALLOCATION only, CHECKTABLE only, PHYSYCAL only, etc ...) or...

Jim Johnston (1/5/2009)

---

I Guess I hadnt thought about from a speed perspective, but more so from an availability standpoint. Defrags dont prevent other processes from running like a reindex...

I can ask Paul Randal to answer that. I don't know what a good answer would be to be perfectly honest, but my gut says no.

MAXDOP only applies to Rebuilds and not reorganizations. Reorganization is supposed to be a single threaded operation so an CXPACKET Wait that you get will be what you get...

What version of SQL Server is this for?

GilaMonster (1/5/2009)

---

Jonathan Kehayias (1/5/2009)

---

GilaMonster (1/5/2009)

---

I had a similar piece of code (for SQL) at my former company. I didn't take the code when I left, of course. I should probably...

Don,

Have you resolved this, and if not, what is the table/index definition for employees? Is there an index on the clientid column and what is the datatype for that...

GilaMonster (1/5/2009)

---

I had a similar piece of code (for SQL) at my former company. I didn't take the code when I left, of course. I should probably rewrite and retest...

It would make an interesting article to write up anyway. If I get it complete, I'll PM you the code that way Steve can publish it as an article...