Aaah another week @ home!
Although holiday is a big word... some heavy construction work going on :-p I have to prepare the room for my first little one which is on the way!
Happy happy, joy joy :-D
Saturday, September 10, 2005
Thursday, September 08, 2005
Wednesday, September 07, 2005
bit or tinyint
I'm looking for some information about the following:
Is it better to use a tinyint field instead of a bit field if you are going to index it? Some people say it would probably be better to use a tinyint because the bit has to be extracted from the bitmask causing some overhead. I haven't found any real deep technical information about this but it sounds acceptable.
So if any of you have real hardcore stuff please post a comment :-D
In case I find some info I'll obviously send a little update!
Is it better to use a tinyint field instead of a bit field if you are going to index it? Some people say it would probably be better to use a tinyint because the bit has to be extracted from the bitmask causing some overhead. I haven't found any real deep technical information about this but it sounds acceptable.
So if any of you have real hardcore stuff please post a comment :-D
In case I find some info I'll obviously send a little update!
Tuesday, September 06, 2005
Insufficient result space to convert uniqueidentifier value to char.
I needed a char representation of a GUID field but couldn't retrieve it because of an obscure error :-s
Insufficient result space to convert uniqueidentifier value to char.
This was caused by a CAST as varchar without specifying the length (or a too short length).
Just using CAST(field as char(36)) solved the problem.
Insufficient result space to convert uniqueidentifier value to char.
This was caused by a CAST as varchar without specifying the length (or a too short length).
Just using CAST(field as char(36)) solved the problem.
Labels:
database engine,
t-sql programming
Understanding TempDB, table variables v. temp tables and Improving throughput for TempDB
Yet another great post of one of my favorite SQL Server gurus :)
Finding Duplicate Indexes in Large SQL Server Databases
A nice article on how to detect duplicate indexes.
I suppose it happens more than you think...
I suppose it happens more than you think...
Monday, September 05, 2005
Create a PDF from a stored procedure without using 3rd party utils
Hmm, a very funky way to create a PDF in SQL Server :-)
Check it out.
I can't say that I'm a fan of such practices but who knows someone might be able to use it out there.
Check it out.
I can't say that I'm a fan of such practices but who knows someone might be able to use it out there.
Subscribe to:
Posts (Atom)