SQL Server Performance

Search Results

Search Again
  1. bseefelt

    How to Identify Table Scans

    Post by: bseefelt, Aug 25, 2010 in forum: SQL Server 2005 General DBA Questions
    Check the user_scans column in sys.dm_db_index_usage_stats
  2. bseefelt

    Connection string woes

    Post by: bseefelt, Oct 29, 2009 in forum: SQL Server 2005 General Developer Questions
    The default instance listens on port 1433. If connecting to port 1433 gets you into SQL 2000, then SQL 2000 was installed as the default (unnamed)...
  3. bseefelt

    Concurrency Problem

    Post by: bseefelt, Oct 19, 2009 in forum: SQL Server 2008 General Developer Questions
    Take a look at the UPDLOCK and READPAST hints. That would allow you to lock the row at the time of select, and keep it locked for the duration of...
  4. bseefelt

    Table Partition based on Day is this possible ??

    Post by: bseefelt, Aug 14, 2009 in forum: SQL Server 2005 General DBA Questions
    You could add a persisted computed column to the table with a value of DAY(sm_timestamp) and then use that column as the partition key.
Showing results 1 to 4 of 4
Search Again