No. They are used sequentially, first one, then the second. There's no striping of log writes (which you give you an improvement if there was more than one log file)

SQL has the ability to use an indexed view even if the view wasn't explicitly referenced in the query, if by doing so it can produce a cheaper plan and...

GilaMonster (5/5/2010)

---

You can't. CheckDB can only be run against an actual database, not a backup. I belive Paul R worked on something to allow CheckDB to run against a backup,...

It depends. 😀 (Did you really expect any other answer?)

If you do your index rebuild in bulk-logged recovery, the log may not need to be that big as rebuilds are...

If the ALTER doesn't work, what error does it give?

Are the files read-write?

OS?

You can't. CheckDB can only be run against an actual database, not a backup. I belive Paul...

Who's that in reply to? If it's in reply to my post, please feel free to explain why I'm wrong.

When we restore the 1 month...

Please read through this - Managing Transaction Logs[/url]

That will change a database from single user or restricted user to multi user. If will not change a database from read-only to read-write.

Is the mdf readonly? Is the database file in an encrypted or compressed folder? Does the SQL service account have full security permissions on that folder and on the files?

To do that you need either all the log backups since that full backup (not a single one can be missing), or the database mush be in full recovery, must...

Do note that R2 is not a patch or service pack. It's a new version of SQL that you will have to purchase licences for if you want to use.

How can it not be a table? You're referencing it in INSERT, UPDATE and SELECT statements

From the function that you posted:

INSERT INTO v_accounts_info_table( tempIdx , account_sequence ) VALUES (@v_account_id, @v_account_id)

SELECT...

Next time it happens, please, before you update the statistics, run a DBCC SHOW_STATISTICS and check if the last update was sampled or fullscan (rows compared with rows sampled). It...

While it doesn't address functions in the join/where, this is a look at how IN and joins compare:

http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/

http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/