SQL Kiwi (12/9/2012)

---

Hi Steve,

I did not receive a notification for this post (or perhaps I didn't see it) so apologies for the late reply. I have been meaning to...

You can restore a filegroup, which might help if you have data split by filegroups. Perhaps current data in one, archived in another(s). That might allow you to restore one...

crazy4sql (12/10/2012)

---

I have a question on one of the DR scenario,

Lets say I have 14 TB database in oltp mode with no/least performance problem. (yes weired but lets accept it)....

Use this: http://sqlfool.com/2011/06/index-defrag-script-v4-1/

What is returned? When you say it is unable to print the result, do you mean there is no value in @Bgk?

A good reason why I don't like guaranteed contracts. I think there ought to be a reduction of the contract for injury, even in season, and a club option to...

Somewhat, but also the ways in which we look for patterns, adding algorithms or new queries might be considered...

GilaMonster (12/3/2012)

---

*sigh* So my book shop loyalty program gives me a free movie ticket for my birthday, valid for a week from that day. Yay, so I can go see...

chrisn-585491 (12/3/2012)

---

After seeing the mess that is the Windows 8 interface, plus all the changes to management tools, the multiple changes in the Office interfaces, I'm not sure that Microsoft...

Tuning queries, designing better databases or models, import/export in custom formats, finding patterns in data, or...

The AdventureWorks files aren't files like Word or Excel. These are databases. You cannot browse them. They need to be attached to the SQL Server instance in order for it...

I hope not. I don't love...

Interesting. Didn't know that was broken. I'm sure this isn't on purpose. Have you reported this on Connect?

What's broken? It seems to work for me.

LocalSystem is local to the machine. You need an account that has rights to get to the network.

You should set a service account that's a domain account, with Everyone...