Viewing 15 posts - 33,076 through 33,090 (of 49,552 total)
Where is that used in the function? The only table I can see you reference in the function anywhere is v_accounts_info_table.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2010 at 8:18 am
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2010 at 8:08 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2010 at 8:06 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2010 at 8:00 am
b.noof (5/5/2010)
Sure i want your helpwhat i have to do ??
i give the function & the table
I've asked twice already for the table definition (which I still don't see),...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2010 at 7:54 am
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2010 at 6:06 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2010 at 2:01 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2010 at 1:44 am
Jason P. Burnett (5/4/2010)
True however, I am not sure that would cause any more growth in your log than suspending your log backups during the duration of the full backup.
Correct.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2010 at 1:40 am
karthik -450760 (5/4/2010)
Trying using DBCC Checkdb in the database..
It won't be possible to run checkDB while the database is suspect. That can only be run if the database is online/emergency....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2010 at 1:31 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2010 at 3:06 pm
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2010 at 2:43 pm
Maninder S. (5/4/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2010 at 2:43 pm
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2010 at 2:30 pm
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2010 at 2:17 pm
Viewing 15 posts - 33,076 through 33,090 (of 49,552 total)