This is actually related to the 2012-06-06 QotD. If you look at Books Online for the DATE, DATETIME2, and DATETIMEOFFSET data types, you will see that they have a...

I'm going to throw out the old reliable...

Moving the objects from the PRIMARY file group to a new file group frees the space in PRIMARY but the space is still there for the database, it isn't going...

Doing it something like this:

alter table MyTable

Add Constraint [MyPrimaryKey] Primary Key (MyColumn)

WITH (FILLFACTOR = 75, ONLINE = ON, PAD_INDEX = ON);

Be sure to verify the complete syntax in BOL.

You may...

A primary key constraint will create an index to enforce the uniqueness of the primary key.

Since you already have a clustered index defined on the table, this index will be...

PRIMARY KEY CONSTRAINT does not equal CLUSTERED INDEX.

Why do you keep coming back to that? I didn't say anything about changing the clustered index.

The only thing that comes to...

Did you catch the other part of my post? If you build it using the ONLINE = ON, you may be able to do it with out much impact....

In theory, yes. In practice, you'll have to figure it out as I don't think this is portable as is to Oracle. It has been almost a year...

coronaride (7/3/2012)

---

To be perfectly honest, I'm astounded with the responses I've gotten. Most people don't seem to know that there's a difference between an index and a primary key constraint....

pamozer (7/3/2012)

---

Is there a way to make sure that in a bit column field that only one record for a specific set of criteria in the table is set to...

That's what matters. Good...

Jo Pattyn (7/3/2012)

---

Depends on selectivity (most distinct values goes) and the number of rows returned

WHERE clauses like Date BETWEEN a And B and Database = 'X'.

Assuming the most popular query...

Try the following to get the list of files:

dir *.* /a: -D /b /s /n

NOTE: No space between the a: and the -D. I had to put the space...

First, you need this function. Be sure to read the comments in the code plus the article it references, and the discussion that is associated with the article. ...

Have you checked the SQL Error logs?