Depends really....

If Instant File Initialisation is turned off then yes, auto growth on a large DB can affect performance temporarily.

Say you have a DB of 200GB size, when auto...

You will need to generate a control totals script. For your data of person and organization details you can have a for example:

1) Number of person records migrated.

2) Number of...

You welcome. 🙂

UPDATE a

SET a.password = b.password

FROM SCC..SEMP as a

INNER JOIN SCCL..SEMP as b

on a.ID = b.ID

AND a.fname = b.fname

AND a.lname = b.lname

You can try different settings for MAXTRANSFERSIZE and BUFFERCOUNT

I use BUFFERCOUNT = 1024 for my backups.

Also, I'm curious as to why you went for an odd number of strips? W...

Okay fair enough then just make the tempt table into a global temp table and problem is sorted.

No worries... have fun! 😀

Sweet, don't forget to change the PRINT to EXEC

Quick and dirty method 😛

create table #SSC(ID INT IDENTITY (1, 1), Code CHAR(1))

insert into #SSC

select 'A' union ALL select 'B' union all select 'P' union all select 'V' union all...

You can copy the result of the below and run in a new sql session:

with cte_MyCodes(Code)

as (select 'A' union ALL select 'B' union all select 'P' union all select 'V'...

What I can't forgive is the lack of effort to even disguise the question lol. It's like here's my assignment for Monday morning, I'm off to the pub with my...

sturner (2/22/2013)

---

Abu Dina (2/22/2013)

---

By the way, the ID column appears to contain a mixture of integers and GUIDs. Should I create a new Identity column on the big table and...

Thanks for this suggestion.

I managed to find a workaround for this. The original ID column was a varchar column with a mixsture of INTs and GUIDs (that's how the data...

Why do people have spare keys for their cars/homes?

You may want to consider Full-Text Search if your list is going to grow to 70 million+ words.

From MSDN:

A LIKE query against millions of rows of text data can take...