Forum Replies Created

Viewing 15 posts - 16 through 30 (of 41 total)

  • RE: Image data types

    image is deprecating, meaning it will probably be removed in a future version.  So I would indeed use varbinary(max).

    Although I agree that storing them on the filesystem is an option...

  • RE: The Effect of NOLOCK on Performance

    "I would add that a hint is just that "a hint" not 100% of the time you will get what you asked for"

    Not all hints are indeed absolute (like ROWLOCK)...

  • RE: Image data types

    I have not tested it but I guess you could use the normal string functions to determine the length of the input string (in your insert stored procedure for example).

    Personally...

  • RE: The Effect of NOLOCK on Performance

    I love Aaron Ingolds' quote to be honest: "Blocking is good."

    Many people tend to forget this 🙁

    I too see many situations where people use NOLOCK to compensate poor design and...

  • RE: The Effect of NOLOCK on Performance

    Hi,

    Have you tried running the queries in a different order (first the NOLOCK variant and then the normal one)?  And running them with MAXDOP 1?

    Anyway, there is a little catch with...

  • RE: Understanding the Algorithms used by SQL Server

    The most 'low' level information about SQL Server that is available to the public is probably the book Inside SQL Server 2000.

    I'd contact Microsoft with your question if I were you.

  • RE: setting up a job to truncate the log file

    The only correct way to do this is to regulary backup the transaction log.  Increase the frequency of backups or increase the size if your transaction log can't handle the...

  • RE: Transaction Log sizing

    Does the extra space bother you?

    You better have one huge log file that is not used than one that autogrows (or shrinks) everytime.  VLogs are created everytime a log grows...

  • RE: DBCC Updateusage versus update statistics/sp_updatestatistics

    Colin,

    As I said before it all depends of course 🙂

    I agree most pages will be in the cache but I have seen systems where the clustered index is on guid...

  • RE: VARCHAR(1000) vs. VARCHAR(MAX)

    Just as with every feature you have to carefully see where it can be used.  I wouldn't recommend putting a 2GB varchar(max) in an index either 🙂  Although I'd love...

  • RE: DBCC Updateusage versus update statistics/sp_updatestatistics

    Colin,

    If you do a reindex the stats for that index are rebuilt with a fullscan.  You can easily check this with DBCC SHOW_STATISTICS.  The auto stats resets to the default...

  • RE: Index Update

    Since they say in SQL Server 2005 indexes don't get updated when you update a field with the same value I'm assuming first data and then index.

  • RE: Performance Monitoring Stats, please analyse

    Profile your server and watch which queries are performing bad.

    Normally you should always seperate your log from your data files.  But there are tons of things to do and not...

  • RE: Stored Procs Auditing

    Not out of the box I'm afraid.

    I suppose this is indeed where DDL Trigger come in.

  • RE: Reduce Audit Logout Time.

    The time you see there is the sum of the duration that particular SPID was connected.  It has nothing to do with the time it takes to close the connection.

    Don't...

Viewing 15 posts - 16 through 30 (of 41 total)