Purely fyi, I personally think a cross apply that names the value being used makes the code much easier to follow and easier to change later. For example:

Select

*

from...

Isn't that an overly broad assertion? If, for the sake of argument, some/all of the disk extents added were scattered all over...

This should "turn off" the identity property:

SELECT *

INTO dbo.newtable

FROM dbo.table

UNION ALL

SELECT TOP 1 (*)

FROM dbo.table

WHERE 1 = 0

ALTER TABLE dbo.tablename

ADD CONSTRAINT tablename__UQ_SalesmanSSN UNIQUE ( SalesmanSSN )

--of course you can name the constraint...

If you have an (extremely) large table(s), compress them [if on Enterprise Edition], particularly if they are (almost) never used, such as log/audit tables, etc..

First, you need an index on ceb.New_IndividualId: I'll assume you have that already.

Second, I'd cluster the #tmpIndividualCreateDates table by i.IndividualID: I'll assume you've done that already.

I guess the OUTPUT clause...

dwilliscp (5/14/2013)

---

Thanks for the warning Jeff.

On the Jobs front.. We almost never put SQL into the Job, but thanks for reminding me to check there too. Thanks to everyone...

I also search table sys.sql_modules, which contains the code for all sys.objects members of type P, RF, V, TR, FN, IF, TF, and R.

If you want to check for use...

When you delete a large or very large numberr of rows at one time, SQL Server defers the actual deletes. The next time a page with deleted r0w(s) is...

If the numeric portion is random anyway, definitely use all numeric characters if possible -- you're quite right: prefixing the random numbers with a fixed string will NOT help the...

jenny 12957 (5/6/2013)

---

hi,

im not sure this is the right forum to put this in, but i am working on redesigning our company database, and i was looking for best practices...

Just to clarify: with ROW_NUMBER(), you don't have to ORDER BY all the columns you want to SELECT; just one ORDER BY column is fine if that's all you need....

I think this will do it; performance will depend on the indexes available on the table:

select sales.*

from (

select distinct TerritoryID

from [Sales].[SalesOrderHeader]

)...

GilaMonster (4/30/2013)

---

No it doesn't. That would be an inefficient way of running a rebuild. Both online...

GilaMonster (4/28/2013)

---

1) DBCC DBREINDEX is deprecated, is included only for backward compatibility with SQL Server 2000 and should not be used any longer

2) Up to you. Depends on your requirements...