Notifications default to the last setting you posted with. It's a simple switch. You post, we use what you last choose. If you change it, we change it for the...

Ah, sorry. Missed that multiple times.

Fixed

Take it and submit something. would like to see something here.

define sales > 0. You have multiple years.

You can add a HAVING clause to the end. Read up on that.

Just a joke on the exercise for better...

Anything that uses a percent at the beginning (%yahoo%) is going to require a table scan of every value. No way around that.

Perhaps full text indexing could help, but really...

+1 for backup/restore

Main thing here is to test, test, test. I know it might be obvious, but you need to point your applications (as a test) to the test upgrade...

The other indexes can be more efficient with the int (or bigint) rather than an internal key for uniqueness.

I'm not sure at 70k (or 700k) that the PK is an...

I'm with Cunningham for a few reasons. I don't like adding things to system databases, especially when they could cause issues with MS upgrades/patches. I wouldn't expect new schemas, but...

For the OP, saikrish.cherukuri, you need to read through the output and limit it to the failed part of the job. I doubt there's much in here, so you need...

You need to provide more information and make an attempt. What is a one day old user? How do you define this? What is database level access detail?

This is really...

xsevensinzx (4/24/2015)

I know that I'm not the best and that I'm not perfect. I'm not trying to be perfect. I'm trying to get stuff done and stuff done that's not...

If it's in SSIS, I know you can loop a bit in there. Not sure exactly how, but I suspect you might be able to loop through a result set...

xsevensinzx (4/25/2015)

Here is a good example I think where the number crunching cannot exist in the database.

I worked in the video game industry, specifically in Massively Multiplayer Online Games. This...