Some other thoughts/possibilities:

Rather than export and then import, it should be faster to just directly INSERT INTO the new table, naturally doing a table lock on the new table.

Pre-allocate enough...

bteraberry (10/2/2012)

---

He said these are very big tables. Altering the column means...

dwain.c (9/26/2012)

---

Nice set up data Sean!

Using it, I'd like to offer a slightly less verbose solution:

SELECT *, WaitTime=DATEDIFF(minute

,CAST(check_in AS TIME)

,CAST(STUFF(appt_time, 3, 0,...

Maybe I'm missing something.

Why not just ALTER the column to be a bigint instead of an int?

SQL Server is optimized to do table lookups, whereas CASE statements are comparatively very slow.

Therefore, I suggest using a lookup table, as suggested by others. You absolutely want to...

#days / 7 = #wks

#days % 7 = #days

I wouldn't duplicate l lot of columns for a covering index w/o real research showing it was 100% necessary.

You should consider the possibility of clusterting tableB on fk_id, but that...

Eugene Elutin (10/2/2012)

---

It depends, but usually BIGINT is better.

Another question, related to keys... If a table uses...

Ellen-477471 (10/2/2012)

---

Is there a chart somewhere that shows the maximum number of identity values for the data type used when creating an identity field in a table?

I've searched for this...

If you typically query the Document table by PersonId, change the clustered key on the Document table to be PersonId instead and you should get great response time for individuals...

And for general performance reasons, get rid of the functions on the date/datetime column:

SELECT p.product,

SUM(CASE WHEN j.holiday = 0 THEN j.qty_delivered END) AS...

You could try:

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

If that doesn't work, there are SERVERPROPERTY parameters that aren't documented: you might try poking around for some of those and see if any of them help...

Try:

ADD (SELECT ON OBJECT::[dbo].[SecDetail] BY [dbo])

Yes there is a setting, but you should...

For me, it depends, mostly on how and/or how often the full_name was used.