Sean Lange (11/6/2014)

---

I am back. Had a major project get deployed 2-3 weeks ago. This was a complete top to bottom rewrite of our ecommerce system that took nearly 2...

.303

Glad we could help. Thanks for the feedback.

kiran.vaichalkar (11/5/2014)

---

Hi Ed Wagner,

The sample data added is no diff to the existing.

So I was not relying on FULLSCAN.

What is NCI??

Also I updated the stats of Clustered Index...

What sample did you use when you updated the statistics and was this different than what you used when you had your 14-second time? Using FULLSCAN takes longer, but...

I have to say that Michael's suggesting is probably the best one. Having clean addresses is the best way to find and remove duplicates. Come to think of...

Forty-four

I don't see the logic in generating the results either. Could you please explain how you get from the source data to the report? It'll make it easier...

Like Koen pointed out, disabling a login is pretty simple. Here's how to get a list of all Windows logins to SQL:

select *

from sys.server_principals

...

In addition to the error you're receiving, how are you trying to backup the database? Are you typing "BACKUP DATABASE"... or is a database job trying to back it...

That's what got me. Need more coffee.

Caliber

Rifle

This functionality...

Erikur, I don't know how you got that bit of logic from the decimal values, but well done! It seems to make sense. I was hoping for more...