dbowlin (7/16/2010)

---

I thought this was something that was just science fiction! A parasite that can manipulate the behaviour of its host, kind of cool and scary at the same...

Hey Eugene,

That requires [type] to be defined NOT NULL too. You're quite right about the performance thing - part of the reason I provided three different solutions up front...

Hombré? :unsure: :blink: 😎

Hey Mike,

Yes, but only if the [type] column contains no NULLs. That information was not provided, so...

Dammit! I even refreshed the thread before starting my reply, just in case Gail replied first!

At least our answers were consistent, I suppose :satisfied:

1. Yes, testing the backup everyday does get old pretty fast. Many shops have a development or test environment that is 'refreshed' from the production systems - so...

funooni (7/19/2010)

---

Well i just checked it and it does work. Supplying the value value 19 to DATEPART function with the first option 'WEEK', it will return 3 which means...

Just one small thing to add to that - even if a full backup is somehow corrupted, you might still be able to recover from the previous full backup, assuming...

Eugene Elutin (7/19/2010)

---

Paul, yep, I was not exectly correct in my post, I should just say that it is impossible to create indices explicitly on table variable after its declaration,...

Richard Banks (7/19/2010)

---

...I will change it to full, set a full backup for once a day and a transaction log backup very 1 hour. With this in mind only...

Eugene Elutin (7/19/2010)

---

...Also there is a differnec in terms of indexing possibilities.

Table variable can only have one index (unique clustered one) which can not be created explicitly, it will be...

Did you read the article? It's not generally true to say that table variables...

Gail's right of course, but can I ask what the purpose of the second full backup is?

If you just want a separate physical copy of the same full backup you...

Thanks for the extra explanation doobya.

Here's the link again, Sagar:

http://www.sqlservercentral.com/articles/66720/

Paul