Viewing 15 posts - 46,201 through 46,215 (of 49,571 total)
dankwart menor (6/18/2008)
June 18, 2008 at 6:58 am
No, because it's not a warning. It's the same as trying to insert 'abc' into an integer column. It's a data conversion error.
I would suggest that you load into a...
June 18, 2008 at 6:46 am
Bad code and poor indexing cause deadlocks. Someone in the past probably switched the allow page locks off as a 'quick fix'. My guess is that your poor performance is...
June 18, 2008 at 4:21 am
I've never met a resume I could trust. From the person with 2 years IT experience who rated himself 5/5 on 3 versions of windows, 2 of SQL server and...
June 18, 2008 at 12:49 am
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...
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...
June 18, 2008 at 12:15 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...
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...
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...
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...
June 17, 2008 at 6:34 am
Since you're using SQL 2005, look up PIVOT in books online.
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...
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...
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
June 17, 2008 at 12:44 am
Viewing 15 posts - 46,201 through 46,215 (of 49,571 total)