Where is that used in the function? The only table I can see you reference in the function anywhere is v_accounts_info_table.

A CTE, despite its name, is not a table. It's a named select statement. Think of it as a temporary view, defined and used within the same SQL query.

There's a difference between @v_accounts_info_table, which is defined as a VARCHAR(4000) and v_accounts_info_table, which is a table you are selecting from, updating and inserting into

Table definitions please, of all tables...

Index rebuilds (not index reorganise) always do a fullscan update of the statistics. The entire index has to be read to rebuild it, so there's no reason to do a...

I've asked twice already for the table definition (which I still don't see),...

UPDATE (and insert and delete) are not allowed within a SQL function. A function cannot make changes to the database.

I assume you don't want us to help you rewrite it?

Yes, you can use the missing index DMVs, however less logic goes into producing those recommendations than the recommendations produced by DTA. Neither should be trusted without verification, all suggestions...

Yes.

A table scan (only present when you don't have a clustered index) is a scan of the data pages of the table.

An index scan reads the leaf pages of the...

Correct.

It won't be possible to run checkDB while the database is suspect. That can only be run if the database is online/emergency....

You won't be able to run a backup with the database suspect.

Check the SQL error log, there will be some message in there saying why the database is suspect. Post...

There's a kb article on it iirc. I ran into that back when I first installed Vista (year and a half ago). Almost forgot about it until now.

Maninder S. (5/4/2010)

---

Also Pl do check that your jobs do not OVERLAP.. i.e schedule them at diff times.. e.g : if you do a full backup of all the databases...

Interval - it depends. What's the maximum amount of data loss allowed in the case of a disaster? Log backup interval should be lower than that.

Each backup to its own...

Firstly, that syntax is still incorrect.

In SQL, a SET cannot reference a table, unless it has is a subquery complete with SELECT and FROM

EXCEPTION WHEN OTHERS is not SQL...