Yup so now you just need to copy the result of the query then paste into a new query window and run (preferably one update at a time to be...

jennigirl (5/23/2013)

---

I have a SQL statement ready go but I am looking for a way to get SSMS to run the report weekly at midnight and provide an output of...

Eric M Russell (5/22/2013)

---

Abu Dina (5/21/2013)

---

We have a tall table that contains 2.6 billion rows

Table structure:

The application which uses this table has been running slow for the last couple of...

Crude but quick way of doing this is to copy then run the outcome of a query like the below:

select 'update ' + table_name +

'set ' + column_name +...

KJKKPSI (5/23/2013)

---

What they would like it to do is parse out the individual statements and destinations from the variable values, and then preform the export based on that pairing. After...

I have another question. Any implications running DBCC SHOW_STATISTICS on a live system with this big table?

Lowell (5/21/2013)

---

cool to have such big table, I'm actually a bit jealous, because it presents a lot...

The 2.6 billion total is after the insert of the 400 million.

Thanks to you both.

Not sure why I said index fragmentation. When my colleague mentioned it to me, the first thing I asked him was about the stats lol.

Was thinking along...

missing comma I think, try this:

Create database ToddTestDB On Primary

( Name = N'ToddTestDB',

FILENAME = N'C:\Program Files\Microsoft SQL

Server\MSSQL10.MSSQLSERVER\MSSQL\DATAToddTestDB.MDF' , Size = 3072KB, -- this was missing!

MAXSIZE = UNLIMITED, FILEGROWTH =...

Join the club! I also have a number of deadlines looming so don't have the luxury to spend too much time on this.

Record linkage is a pain in the backside...

Thanks for all your help so far.

This is one way I've tried and it works I think but I'm sure you clever folks can come up with a better way...

Yes, there are a number of indirect relationships and it gave me a lot of headaches.

It's just gone past midnight here in the uk so I'm off to bed. Will...

The original table is the product of a record linkage process. All the ids are linked together. I know it's hard to spot but if you go through each row...

Unfortunately my solution isn't working as expected. Anyone else with suggestions?

Here is some sample data:

with SCC_CTE (Retained_ID, Dropped_ID)

AS (Select 15799, 8388 union all

select 52941,8388 union all

select 52941, 15799 union...