Viewing 15 posts - 46,186 through 46,200 (of 49,552 total)
Can you perhaps post the execution plan in its xml format? (save as .sqlplan, zip and attach to your post). The base tables and index definitions would also be nice.
Regarding...
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
June 18, 2008 at 12:16 am
Do you want to see what users have the lock pages privilidge? If so, you may have to locate where in the registry the values are entered and use xp_regread...
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
June 18, 2008 at 12:15 am
Do you have a backup?
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
June 18, 2008 at 12:02 am
mike.bishop (6/17/2008)
In the sys.dm_db_index_usage_stats DMV the field user_lookups is the total number of bookmark lookups. Correct?
Correct
Either way my question is why do bookmark lookups occur on a clustered index?
They...
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
June 17, 2008 at 7:41 am
nukhanwa (6/17/2008)
It is a site for free PDF books, managedby a team worth appraising.
That looks like a warez site. Links to copyrighted materials are not permitteed on this forum.
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
June 17, 2008 at 7:08 am
It's not T-SQL. You don't ever have to use it. There are many places it's convenient to use.
As I mentioned, there are statements that need to be the 1st in...
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
June 17, 2008 at 6:47 am
GO is a batch delmiter. It shows where 1 batch ends and another begins. There are some SQL statements (CREATE PROCEDURE) that have to be the first statement in 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
June 17, 2008 at 6:34 am
Since you're using SQL 2005, look up PIVOT in books online.
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
June 17, 2008 at 5:39 am
Set the log file for the max size it needs to be to support what you do to the DB.
You can space out the index rebuild and/or backup 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
June 17, 2008 at 5:35 am
Check the number of seeks, scans and lookups. If they're all 0, the index is not been used. Number of updates shows how many times SQL had to update 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
June 17, 2008 at 1:36 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic517923-150-1.aspx
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
June 17, 2008 at 12:44 am
tmbasha (6/16/2008)
This is the table which stores an Order of 93 columns
Still... I'd be quite willing to bet that SQL is only using a small % of those indexes. Check...
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
June 17, 2008 at 12:23 am
ALTER AUTHORIZATION On <Object name> TO <New Owner>
There are a lot of different options for ALTER AUTHORIZATION, so check what Books online has to say on the subject
That's if...
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
June 16, 2008 at 2:05 pm
control (6/16/2008)
How can I do an update or change the value of one or some of the Column/s?
You don't. The system tables aren't updatable in SQL 2005. They aren't even...
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
June 16, 2008 at 1:41 pm
Can you post the VB code please?
Is it possible that you have implicit transactions and are reusing a connection that has an ope transaction?
Second the suggestion of profiler. It will...
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
June 16, 2008 at 1:28 pm
Viewing 15 posts - 46,186 through 46,200 (of 49,552 total)