For those using ROW_NUMBER, if you want users having 2 OR MORE roles, shouldn't the filter be rownum >= 2 instead of just rownum = 2?

Since you are on SQL 2012, new Windowing Functionality is available too. Here is a solution based on that. Note you may want to add in columns and/or...

opc.three (9/7/2013)

---

I have a client with a mission critical SQL Server serving local network and VPN users that wants offsite database backups. Compressed, the database backup is about 80MB, not...

The only thing I can think of that might be a performance effect of this is having data be physically "far apart" on disks, leading to a few extra milliseconds...

james marriot (9/6/2013)

---

Im aware of the usual way of getting a multi threaded/process insert by utilizing heaps or partitioned tables and multiple insert statements, but if inserting into a heap...

I personally STRONGLY recommend to my clients that they avoid in-place upgrades, ESPECIALLY on clusters and ESPECIALLY ESPECIALLY when skipping THREE versions. There's just sooo many ways and places...

Koen Verbeeck (9/6/2013)

---

TheSQLGuru (9/6/2013)

---

Personally I would not use INTERSECT. It is a relatively new operator in SQL Server and thus could be exposed to some bugs and/or not have...

I'm not saying anything. That was just a quote...

Personally I would not use INTERSECT. It is a relatively new operator in SQL Server and thus could be exposed to some bugs and/or not have all the efficiency...

Actually, doesn't SSIS interrogate some amount of rows (configurable?) and have the ability to "suggest" data types for inputs when you are building out transforms?? I am pretty sure...

Since you are on SQL 2012, I wonder if something in the new Data Quality Services stack can do what you need. No idea about that personally.

I always recommend full install too. Upgrade-install doesn't give me a warm-and-fuzzy at all.

I doubt very much you will find any benchmarking or other documentation on this trace flag. It would seem to be a "mostly-unsupported/undocumented" TF. I doubt you have...

Hi Sandy! I see that you are new to SSC.com forums. Welcome! Please note that we try to not post to old items.

do NOT use a scalar UDF if it or the place you are using it does data access. Read my chapter in the SQL Server MVP Deep Dives 2...