If an index isn't being used, you should see a lack of scans & seeks in the index usage stats DMO. So you want to limit that sub-select to those...

Oh. You're posting in the SQL Server 2008 forum, so answers might...

I wouldn't say that SQL Server 2012 introduces anything like a new job role or new job opportunities. It expands on existing jobs and provides a few new ways to...

michaeljharper (6/4/2012)

---

GilaMonster (6/4/2012)

---

One thing that was part of my introductory course for my M.Sc was 'why are you doing this?' and it made it very clear that if you're just...

Right click the plan, choose "Save As" and...

It's not that you don't protect it. In fact, you can protect it a lot more. It's just not a single file that you assign a password to like Access....

When all you have available is the full backup, that's all you're going to get. If you have log backups available, you can restore right to the end of the...

michaeljharper (6/4/2012)

---

Also, word of advice, asking instructors at a school, who are absolutely dependent on you attending that school for their livelihood, if you maybe ought to spend another two...

Generally, integrated security, Windows security, is considered to be the better approach. You can use a login and a password. That's called SQL Server security. But I wouldn't suggest it....

If updating the statistics slows down the performance of the query, it's likely because a new execution plan was created based on the updated statistics. You'll need to look at...

You need to validate how much CPU usage you're seeing on the system now. If you're already operating at the edge, sustained CPU usage at or above 75%, then you...

Not entirely sure what you mean by the question, but one of the coolest new pieces of technology to come with SQL Server 2012 is the AlwaysOn Availability Groups. You...

In the US, in certain fields, it will absolutely help. But overall, no, it won't help your technology career that much. If you were just getting started and I were...

Nope. Sorry, nothing but hard work in front of you to make a database run faster. Check out my book on query tuning.

Or, you can buy really big servers. Throwing...

Just an aside, instead of relying on backups for stored procedures, triggers, and other structural pieces of the database, I'd get all that code into a source control system.