My boss is constantly at me to switch over to Mac. Resisted so far. That's all I can tell you.

As to the rest, get lots of memory & fast...

Not parsing the entire query, but several issues immediately jump out at me. First, you're not using ANSI standard JOIN syntax:

...FROM TableA AS a

JOIN TableB AS b

ON a.ID = b.ID...

But...

The compile parameters are stored with the plan because they help show how the plan was created. You also get the ANSI settings stored with the plan. Other than that,...

Assuming you're going to use sys.dm_exec_query_stats and then sort by CPU, I/O or some combination, then you can combine that DMO with sys.dm_exec_query_plan and look for queries that do not...

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