Can you post sample data, it will be much easier to help you out.

Remove the ISNULL from the second statement. Does it return all NULL values?

Take a look at this, I believe this might fix your problem,

http://www.sqlservercentral.com/scripts/users/69523/%5B/url%5D

If you copied the database files over before the sql logins it will break the login connection to the DB. You basically have to re-initialize the logins. There are a...

New Born DBA (3/28/2014)

---

I don't know how...

New Born DBA (3/28/2014)

---

I am not, but yes they are being...

Grant Fritchey (3/28/2014)

---

JoshDBGuy (3/28/2014)

---

New Born DBA (3/28/2014)

---

JoshDBGuy (3/28/2014)

---

If it's simple recovery, after a transaction has been fully committed the space used should be reused. If it's in full recovery, you...

Sure, here's a good article[/url] from Pinal Dave that may help you understand how these backups work.

You want to maintain consistent T-Log backups from your last full backup. So if you backup at say 6:00 PM every day, you're going to want all of the T-Log...

That's actually two terabytes. That's your maximum file size, not the autogrowth amount. 10% is the amount your log file currently grows. If you...

New Born DBA (3/28/2014)

---

Come to think of it, I don't know how adding initial size to 1000 MB and set the growth to 1000 MB will help. The auto-growth of...

The better way to go about this is to determine why your server is having performance issues. Are people running massive amounts of ad-hoc queries? Have you reviewed your indexes?...

New Born DBA (3/28/2014)

---

I think we are a little bit stingy when it comes down to giving extra space to the log file. Lesson learned.

1 more question. When the log...

Here's a good article,

http://technet.microsoft.com/en-us/library/bb402876(v=sql.105).aspx

Also, I forgot to mention in my above post, in the future you should think about putting your log and data files on separate drives. Both files placed on the...