I've just tried your script, and it looks like I was wrong about not being able to use a variable in your BACKUP statement, so ignore that comment. I...

You can't use a parameter for the database name in a BACKUP statement. You need to use dynamic SQL instead, or find some other way of building your SQL...

Leave it as it is, otherwise it'll only grow again, wasting system resources and causing fragmentation. If there's been a one-off event that has caused the log to grow...

Hugo

I was about to make precisely that point. Paul is quite right, since the question asks how to get the proc to do an index seek. But it...

Dwain's method is more efficient, since it doesn't involve string conversions. Granted, it doesn't give you the AM/PM, but do you really need that?

If you want proof, run this...

kiran.rajenimbalkar (2/17/2012)

---

is there any function is in the sql server to generate new ID(as like sequence number) every time while inserting the rows from the front end(like front report) to...

varchar does not mean varchar(max) - it means varchar(30) when CONVERTing.

http://msdn.microsoft.com/en-us/library/ms176089.aspx

The 103 date format means dd/mm/yyyy, so that explains the result of the first statement. The second one returns...

dwain.c (2/17/2012)

---

On the other hand, if code may change over time for a part_id, maybe the intention is to capture the current code at the time of the order? ...

Maybe, but that doesn't show up in the sample data he posted.

You're way...

Oops - wrong thread! Don't know how that happened.

John

I understand what you're trying to do, although I don't know what you meant with that partial code about the join. However, please, please don't do it like this....

Got it right, but I think the answer should be "it depends". On what? The selectivity of the data in Col. You get a seek if you...

Your last two posts don't make sense to me. Please will you post some sample INSERT statements and show what the new rows in ORDERS should look like after...

This will happen if you use BACKUP LOG TO DISK = 'x:\MyFolder\MyBigLogBackupFile.TRN' and you don't specify WITH INIT. Use RESTORE HEADERONLY to check how many backups are in the...

Yes, after you take your next full backup, if you delete the 79GB log backup, you will only be able to restore to a point in time after the full...