I've done that too.

Once had the backups for the...

Stefan Krzywicki (12/29/2011)

---

Grant Fritchey (12/29/2011)

---

GilaMonster (12/29/2011)

---

Grant Fritchey (12/27/2011)

---

Based on the fact that we can't get people to run good sets of backups despite Umptymillion articles, blog posts, presentations, webcasts and...

Stefan Krzywicki (12/29/2011)

---

Dev (12/29/2011)

---

Dev (12/29/2011)

---

Stefan Krzywicki (12/29/2011)

---

GSquared (12/29/2011)

---

Dev (12/29/2011)

---

I thought some "Magic" (recovery trick) will happen & that DB will be saved. It’s a...

David Moutray (12/29/2011)

---

This is the point when I need to step in and ask that we all remain positive and pleasant. 🙂

All of you are helping me by offering your...

patrickmcginnis59 (12/29/2011)

---

Gianluca Sartori (12/28/2011)

---

NOLOCK? :sick:

With RCS enabled writers don't block readers. Is this the kind of concurrency issue you're trying to address?

As far as the dangers is concerned, you could...

Stefan Krzywicki (12/29/2011)

---

GSquared (12/29/2011)

---

Dev (12/29/2011)

---

I thought some "Magic" (recovery trick) will happen & that DB will be saved. It’s a nice learning opportunity that I missed. However the...

This is the kind of situation where full text indexing and a custom thesaurus file will come in very, very handy.

I've seen this kind of query many, many times, and...

Dev (12/29/2011)

---

I thought some "Magic" (recovery trick) will happen & that DB will be saved. It’s a nice learning opportunity that I missed. However the lessons learnt today...

Updating Image type data is done via WriteText or UpdateText. It's not simple, but read the documentation and test a few samples and you'll get it.

Documentation is here: http://msdn.microsoft.com/en-us/library/ms187993.aspx

You can't directly run a UDF on another server like that.

Build a stored procedure on the remote server that does what you want. Run that instead.

GilaMonster (12/29/2011)

---

Grant Fritchey (12/27/2011)

---

Based on the fact that we can't get people to run good sets of backups despite Umptymillion articles, blog posts, presentations, webcasts and screaming lightning talks, I...

Michael Valentine Jones (12/29/2011)

---

GSquared (12/29/2011)

---

Michael Valentine Jones (12/28/2011)

---

GSquared (12/28/2011)

---

Michael Valentine Jones (12/28/2011)

---

GSquared (12/28/2011)

---

Michael Valentine Jones (12/28/2011)

---

I don't see how RCS would be a problem in a data warehouse\datamart application.

If there...

Might look like:

;with HierarchyCTE as

(select ID, NULL as ParentID, '000000' as Breadcrumb

from dbo.MyHierarchyTable

where ParentID is null

union all

select MyHierarchyTable.ID, MyHierarchyTable.ParentID, Breadcrumb...

That's actually pretty normal. If you're using sp_prepexec,...

Dev (12/28/2011)

---

GSquared (12/28/2011)

---

Dev (12/28/2011)

---

GSquared (12/28/2011)

---

If I'm reading it correctly, it's pretty much just a "Where in (values)" statement with as close to unlimited number of allowed...