Viewing 15 posts - 16 through 30 (of 41 total)
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...
January 26, 2007 at 12:26 am
"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)...
January 25, 2007 at 7:57 am
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...
January 24, 2007 at 1:04 pm
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...
January 24, 2007 at 12:57 pm
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...
January 24, 2007 at 3:45 am
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.
August 19, 2006 at 12:49 pm
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...
August 7, 2006 at 1:12 pm
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...
August 7, 2006 at 1:04 pm
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...
August 7, 2006 at 12:31 pm
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...
August 7, 2006 at 5:17 am
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...
August 7, 2006 at 5:00 am
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.
August 4, 2006 at 2:54 pm
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...
August 4, 2006 at 2:51 pm
Not out of the box I'm afraid.
I suppose this is indeed where DDL Trigger come in.
August 4, 2006 at 2:46 pm
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...
August 4, 2006 at 12:19 am
Viewing 15 posts - 16 through 30 (of 41 total)