durai nagarajan (8/21/2012)

---

In that case he has not scheduled Tlog backup from 6:00PM to 10:00PM which in turn might leave him in data loss incase of disaster.

with full backup and...

Here is another potential solution. Would like to have others give it a test.

Against the small original test set it worked. Unfortunately, I think it may be wrong...

ronmoses (8/21/2012)

---

I got it wrong on the assumption that data type conversion would take precedence over concatenation or addition. Now I understand that while I'm correct about that, the...

I am going to join in with the "It depends" group. You need to test if a materialized view is going to help or not. There really is...

The key for the SQL Logins is the SID, and since they are the same, there should be no problems. As far as the default database changing on a...

durai nagarajan (8/21/2012)

---

Lynn Pettis (8/17/2012)

---

Looks to me like you have a very active database even for its small size. I can understand the initial tlog being large, as it...

tshad (8/20/2012)

---

Actually, this is a stripped down version of the actual query I was using so it is a little difficult to do that.

But I did figure out my issue,...

Sergiy (8/20/2012)

---

SET DATEFORMAT DMY

select CAST...

You may also want to check out this article:

http://www.sqlservercentral.com/articles/T-SQL/67898/

TRUNCATE TABLE is logged. If you truncate the table on the principal side, it will get truncated on the mirror.

GilaMonster (8/20/2012)

---

Lynn Pettis (8/20/2012)

---

If this means that it backs up a 21 GB log file for a 20 MB database because no t-log backups have been run between full backups,...

smallmoney (8/20/2012)

---

Hi,

I seem to have caught amnesia.

I understand that frequent transaction log backups help maintain the size of a transaction log.

However do Full backups help anything with the transaction...

CELKO (8/19/2012)

---

why do all the string spliting and concatenation when the a) the text string is already in dd/mm/yy format, and b) you can use the format codes (3...

CELKO (8/18/2012)

---

CAST (SUBSTRING (IN_STR, 7, 4)+'-'

+SUBSTRING (IN_STR, 3, 2))+'-'

+SUBSTRING (IN_STR, 1, 2)

AS DATE)

cut up the string and...

CELKO (8/17/2012)

---

Aren't you required by law to use the VIN and not invent your own identifier? Or is this just aq skeleton? I have a horror story about a...