If 50 million is too many rows for a single transaction, how about something like this?

Limit the @Cycle variable so it doesnt for ever, or you want to time a...

We have the same problem moving packages between different versions of sql.

The text qualifier gets changed from <none> to _x003C_none_x003E.

Dev and Prod are OK, but Test is on an older...

All is shows is your name, certification(s) and date(s).

There is a certification ID, but I don't think that's personally identifying.

I would talk about differing philosophies of the role of SSIS. Some people love it and want to do everything in SSIS, while others use it as a framework for...

nicver (9/6/2012)

It is not better, it is up to date, that's all. I would say that 90% of it is the same but why...

If the keys are generated by a column default, you can use NEWSEQUENTIALID.

Oops, just noticed the date, never mind.

How many rows are returned without the WHERE clause?

I may be wrong, but I think the openquery will filter the results in Oracle, whereas...

Is 461 easier than 433?

That looks like code I have written in the past to return a data set for a report parameter list.

If the TOP 100% was a TOP N, then I think...

I managed to get it wrong.

I thought the correct answer was too easy and maybe the 1 would default to a bit data type.

I did something similar recently on a very large table. I found that it split pretty much every page, so the disk space taken by the clustered index doubled until...

This may be obvious, but if you just want to make it work for now, comment out all but the first column and run the select.

Then uncomment the next column...

If the table is partitioned on the Day column, wouldn't it need to be a not null column? and part of the primary key?

How is data continually pumped in to this table if it only has 200 rows?

I don't know much about it, but at a previous job all the VMs were unable to use parallelism (at least that's how it seemed).

I would look at the execution...