How about:

USE tempdb;

GO

CREATE TABLE dbo.Class

(

ClassID ...

Christian Buettner-167247 (4/30/2010)

---

Hi Paul, thanks for your reply. I managed to get it done with your second option, but the first option does not work for me. The screen looks...

Christian Buettner-167247 (4/30/2010)

---

Not sure what you mean. Just to clarify my question a bit: I have restored everything, except the tail log backup (and I am in no-recovery). If I...

Hey, Stefan. I see Grant...

Christian Buettner-167247 (4/30/2010)

---

Tested it with SSMS and failed ("Select the Backup Sets to restore" shows no entries after selecting the tail backup in "From device:")

...

If anyone could tell me if...

I have some sympathy with this view. So many QotDs have tried...

CirquedeSQLeil (4/29/2010)

---

The part that gets me with these questions is if the hardware failure was enough to corrupt the database and the full backup - it would seem to me...

Yep, glad I missed that thread.

Atif Sheikh (4/29/2010)

---

Yep I...

Matt Miller

---

So - if the DB engine doesn't see there being any improvement in rebuilding (say - the index is so small that it will always fit in memory), you...

I should. Any idea who that is? 🙂

Hey Iain,

Double precision is just a synonym of float.

I thought my function was reasonably complex 😉 😀 :w00t:

Sounds like...

I replied on Ask, but thanks for posting the thread reference there too.

I don't usually post on Ask because every...

Grant Fritchey (4/29/2010)

---

Jeff, or anyone else that knows a heck of a lot more about decimals than I do, please go check this question on Ask.SQLServerCentral. I really don't have...

For anyone reading this thread in future that would prefer range results (as below) here's another method.

customer product from_date ...