I usually have the OS and SQL Server binaries on a separate drive than the data files or log files.

What I'm mostly looking at these days is:

C: (internal drive) OS...

jcrawf02 (2/27/2012)

---

Has anyone implemented an ENDOFTIME()/BEGINNINGOFTIME() pair of functions before? taking a date and a period, returning the start/end of said period? Read an article from Itzik which mentioned such...

I don't think a stats update could be done in parallel. It pretty much needs to count values in columns, and spreading that out to multiple threads doesn't seem...

MyDoggieJessie (2/27/2012)

---

But fact that the execution plans for the procs are often cached and more likely to be reused isn't though. This isn't an option when running ad hoc...

Have you tried using LinkedIn to contact any connections from that area? I've found that useful in researching this kind of thing.

It's going to be the same as installing Enterprise Edition on a cluster. Are you familiar with that?

If it's an active/passive cluster, then start here: http://msdn.microsoft.com/en-us/library/ms189134.aspx

The bit about procs being pre-compiled is actually the IT version of an urban legend.

But the bit about refactoring a proc being easier than rebuilding and redeploying a report is...

Will this suffice?

DECLARE @XML XML = '<root><Books><Book><ID>2</ID><Name>Sql Server Admin</Name>

<Author><Name>Joseph</Name><Age>35</Age></Author></Book></Books></root>' ;

SELECT @XML.query('/root/Books/Book/Author') ;

If not, you'll need to query the values within the Author node, and then recompose it into XML with...

patrickmcginnis59 (2/27/2012)

---

Well I asked for a clarification this week on a post, and the poster replied that he was sorry I wasn't able to understand his post, and he wouldn't...

If it has to be done for each load, then you either need to add that to the script/proc that puts data in that table, or you need to make...

LutzM (2/27/2012)

---

So, is SaraGate a new name for RedGate? :unsure:

And, thank you, Brandie. Now I know there's a key required. So the area seems to be locked. I'll keep asking...

Sounds about perfect.

GilaMonster (2/27/2012)

---

GSquared (2/27/2012)

---

Amusingly, that reminds me of one of the more common scam issues in EVE Online. The scam artist claims to be doing research on trust between strangers...

I have a couple of lookup databases (like lookup tables, but it's the whole database). I'm not sure if that's what you mean.

I have one database called "Common", that...

How are you determining that the rows aren't there? A separate query?