restoring 2.5TB database for logshipping secondary. Paint is drying very fast!!

Took the plunge on 70-451

That's kind of a big topic for a forum question.

Have a look through these tutorials and see if they help.

http://msdn.microsoft.com/en-us/library/ms170246(v=sql.90).aspx

Evil Kraig F (12/7/2011)

---

I would...

Do a left join to each of those tables with the appropriate fields specified in the on clause. IN addition add 'and suchandsuchfield = 1'

e.g.

Left Outer Join BoatingWarningQaulityCodes

On...

There is not a DMV that replaces sp_who or sp_who2 in its entirety.

If you are looking for a query that is useful you could try whoisactive by Adam Machanic, or...

Yes on the 64K, get them to format as 64K clusters. If filestreaming with larger files, you may want larger cluster sizes.

The spindles seems off.

The local drive is far...

1. Yes, integrated is better. Many leave SQL Login enabled as a backup as well.

2. You could try creating a database user for your application without login

try using a cte and a row_number() ranking function.

Put your query in the cte with that ranking function, then select from the cte where rownum=1

Have a look at this connect item

http://connect.microsoft.com/SQLServer/feedback/details/557402/ssms-can-no-longer-create-or-edit-job-steps

It lists some patches and SPs that should fix the issue.

Legion

understatement

Where possible and feasible I like to try and consolidate - even if that means using Enterprise edition. Of course, homework has to be done before doing such a...

mutiny

L' Eomot Inversé (12/7/2011)

---

Steve Jones - SSC Editor (12/7/2011)

---

Jeff Moden (12/7/2011)

---

Revenant (12/6/2011)

---

Jeff Moden (12/6/2011)

---

To be honest, I didn't enter... didn't even try to answer a single question. They wanted...