Yes, it will. Doesn't mean it's useful.

If you create 5 identical indexes...

99%+ IO subsystem.

That can be anything from a filter driver to the HBA drivers, switch firmware, cables, controllers, SAN cache, disks and everything in between.

Make sure drivers and firmware is...

Please note: 6 year old thread.

Huh?

If you don't know what the value should be, how can anyone else?

Why the last entered ID value? What's the purpose? What are you trying to do here?

If you don't feel like the alert is useful, disable it.

Not following.

If I insert 'This is a string' into that table, where does the ID come from for the IDCopied field?

Personally I'm glad to see that change. Not everyone works with data warehouses. 463 is specifically SSIS, MDS and DQS, while I causally use SSIS from time to time, I'm...

Ask me over coffee sometime, somewhere.

I don't know. Company won't pay for me to...

jasona.work (6/26/2015)

---

OK, I've tried to make out the title of the Shadowrun book on the shelf, and had no luck. I *know* it's one of the older ones, but...

ken.trock (6/26/2015)

---

Thanks everyone. Even on a 120M row table SQRT(1000*<num rows>) is only a 350k row threshold. I'm bringing in at least that many every night. So not sure why...

Don't write your own, odds are it's using one of the more inefficient methods. Use the one...

jasona.work (6/26/2015)

---

OK, I've tried to make out the title of the Shadowrun book on the shelf, and had no luck. I *know* it's one of the older ones, but...

Why would you want more than 20% of you memory to not be used? Surely the point is to ensure that the data cache is used, not that SQL is...

It's not data types that are the problem. It's that IN doesn't work that way.

Column IN (@Variable), because there's only one variable in the brackets, means Column = @Variable, and...

The 'exit' statement that I made when I left the bank (after 4 years of working there and ~2 weeks of being intermittently belittled and insulted by some of the...