Yes, because they are still scans, ie a read of all the pages in...

sayfrend (11/4/2008)

---

What is the reason to kill the open Transaction. Correct me if I am wrong, When SQL Server takes Transactional log backup, it removes all the inactive transactions...

What do you mean, you don't see lots of scans? Are you looking at the same execution plan I am? See attached. There are only two seeks in the entire...

Have a look in the error log. What does it say about that database?

I wouldn't bother creating a backup device for a once-off backup, and if you run that more than once, you may get an error saying the backup device already exists.

Just...

No. Literal text hasn't been changed and your first query would throw an error saying no such column as SomeText

SELECT tbl.Column AS [MyColumn], 'SomeText' AS [LiteralText]

FROM MyTable AS tbl

The []...

Once you've set it back to full, you'll have to take a full database backup or your backup software, which I assume does log backups, will fail.

Maybe. They're not indexes and as such they won't directly improve performance. They do give the optimiser more information about the data hence allowing it to produce better execution plans

Fernando (11/4/2008)

---

Since I started the log job, the size has not increased much. I just want to regain the space as the transaction log backup as well asn the nightly...

That's saying that the 6am diff is not based off the...

You can't disable logging. It's not an optional component of the database.

What you can do is set the database you're doing the transfer into simple recovery. Since it's not a...

You can, but unless you figure out why the log is growing, it's just going to get back to that size in time.

What recovery model?

If full or bulk-logged, how often...

Actually, I've just finished writing a short 'chapter' for a book. 😀

balbirsinghsodhi (11/4/2008)

---

SQL Guru.. I know this query is not good for optimizer so I did modify and used in a following manner but still going in a suspended mode and...

KATHLEEN Y ZHANG (11/4/2008)

---

When I run it using my windows account, I am system admin, the sql account is not a sysadmin, but when the developer ran it using her...