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

Eirikur Eiriksson (4/24/2015)

---

Quick trick, in SSMS press CTRL+ALT+G to view Registered Servers, if they are grouped you can right click on the group, new query and that instance of the...

ken.trock (4/24/2015)

---

Gail Wanabee (4/24/2015)

---

I've seen code reviews required in some shops, little or none in others.

My personal execution: I almost always ask for a code review from a co-worker, even...

Yeah, that's probably the best type of solution, Jeff. Didn't think about tally tabling that, but it's a good use with dynamic SQL for a limited number of items, along...

That's it. I don't believe the UAC on any server OSes notifies you to open ports. The client versions (7, 8) seem to ask you to open the firewall.

Apologies, I...

Thanks for the update. Hadn't thought of the firewall, and I thought that it was opened by SSMS, but perhaps not. I'll have to try and see.

What OS?

I'd crosstab it more like this:

SELECT customers.name,

SUM( case when year(date) = 2014 then unitprice*qt else 0 end) AS total_2014,

SUM( case when year(date) = 2015 then unitprice*qt...