anil.nair@gtnexus.com (4/1/2013)

---

I wish SQL Server had a SQL Judge, Jury and Cop rolled-into-one feature which would summarily execute a user once it has used up more than a set of...

ldorian81 (2/11/2013)

---

If you put the whole query into SSMS 2008 and run it without removing the 'GO' commands you will still get the same results as shown below.

Msg 2714, Level...

This is a shot in the dark, buy is the package stored in msdb on one of the cluster nodes, but not another? so that when the cluster rolls over...

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...