What are your autogrowth settings? If you're not sure about the effect autogrowth can have on performance and how and why to change the settings, this excellent article [/url]by Greg...

Are you running this process on <local>?

rodjkidd (4/5/2013)

---

Steve Jones - SSC Editor (4/5/2013)

---

Cadavre (4/5/2013)

---

I'm in Castle Marina...

Can you post the whole query please?

Cadavre (4/5/2013)

---

I can find at least one person that would not only agree with you, but would...

You've been spending waaaay too much time in front of a computer 😀

Cadavre (4/5/2013)

---

ChrisM@Work (4/5/2013)

---

Not sure how it will pan out yet. With a couple of good mates in the immediate area and a nearby pub boasting 180 different whiskies[/url], it's a...

Grant Fritchey (4/5/2013)

---

ChrisM@Work (4/5/2013)

---

Not sure how it will pan out yet. With a couple of good mates in the immediate area and a nearby pub boasting 180 different whiskies[/url], it's...

rodjkidd (4/5/2013)

---

Cadavre (4/5/2013)

---

rodjkidd (4/5/2013)

---

Nice.

So I take it you will jogging there and back then? 😀

I hate distances like that. Too far to walk, to short a drive for the car...

Cadavre (4/5/2013)

---

I'm in Castle Marina Premier Inn, which according to Google...

Why don't you simply concatenate into fixed-width, like this?

DROP TABLE #table_x

CREATE TABLE #table_x (Empno INT IDENTITY(3141593,31415), FirstName VARCHAR(25), LastName VARCHAR(25))

INSERT INTO #table_x (FirstName, LastName) VALUES

(('Francis'),('Bacon')),

(('Jean'),('Baptiste')),

(('Clarence'),('Birdseye')),

(('Charles'),('Babbage')),

(('John'),('Logie Baird'))

SELECT *,

Concatenated_FixedWidth...

lda17_04 (4/4/2013)

---

Hello!!!

I need a database from an Insurance company, but they don't want to give it because it has a column with the ID number of each patient and their...

Use ROW_NUMBER, something like this:

USE SQLsafeRepository;

;WITH UnfilteredResult AS (

SELECT CASE WHEN LEN(p4.[name]) = 0 THEN p5.[name] ELSE p5.[name] + '\' + p4.[name] END AS server_instance_name

,p3.[name] [database_name]

,p4.[name] AS 'instance'

,p5.[name] AS 'server'

,p2.start_datetime

,p2.action_status

,p1.backup_type

,p2.utc_offset

,DATEDIFF(ss,p2.start_datetime,p2.end_datetime)...

sqlguy-736318 (4/4/2013)

---

What I'm suggesting is that table #a would have 2 rows with the same company. For example:

'Microsoft', 'Seattle'

'Microsoft', 'Portland'

In this scenario, row #1 would get updated but row...

Post the actual execution plan of the "Big Query" as a .sqlplan attachment.