Something else is going on there. If you...

It will increase the size of the index, but only for leaf pages. The non-leaf pages of the index will be the same size as before.

Jeff Moden (11/3/2012)

---

ScottPletcher (11/2/2012)

---

Given that a clustered index doesn't cost you much space (just for the upper/non-leaf levels of the index), I tend to cluster log tables as well. However,...

I do see one potential valid use for a heap (an unclustered table): as a bulk staging table. That is, if you just need a table to quickly bulk-load...

mmallkc (10/30/2012)

Whenever I try to insert a new record in violation of this constraint, I get an error as expected. However, when I update the table in violation of this...

capnhector (11/1/2012)

---

David92595 (11/1/2012)

---

Can Fields B, C, and D still be manually changed after the fact if need be? or are fields B,C, and D locked as computer values at that...

Haven't a clue. If you get even close, you've got a horrible table design anyway.

Who would ask such a Mickey Mouse q??

You could also use WHERE with NOT:

...

WHERE NOT (

(CARS = 'Volvo' AND Year = 2006) OR

(CARS = 'Buick' AND Year =...

scogeb (11/2/2012)

---

Michael Valentine Jones (11/2/2012)

---

scogeb (11/2/2012)

---

I like to think there is always an exception to every rule. Take for instance a table that ALWAYS has inserts and NEVER has...

I think technically this is the last time the table was accessed since SQL was last (re)started.

/* Author: ScottPletcher */

SELECT

start_date,

end_date AS end_date,

CAST(

DATEDIFF(YEAR, start_date, end_date) - CASE...

What is the problem? Do you have NULLs in the the MainZip when it's not present/used?

SELECT D.*

FROM Doctors D

INNER JOIN ZipCodes Z ON

(D.MainZip IS...

Don't rely solely on the missing index recommendations from those tables. SQL typically suggests way too many indexes. You need to have someone review all available information before...

Try using [ ] instead of ' ' around the user name:

DECLARE @sql nvarchar(max)

SET @sql = ''

SELECT @sql = @sql+

'DROP USER ['+name+'] --<<--

'

FROM sys.database_principals

WHERE principal_id >...

I would have to know the version of SQL to know how to answer this.

For 2008+, you have CDC.

For SQL prior to that, they probably wouldn't like my answer, but...