Viewing 15 posts - 2,821 through 2,835 (of 3,607 total)
Yes you can index BIT columns but the query optimizer will probably ignore the index because it is likely to have poor selectivity.
February 14, 2005 at 4:07 am
See the following article and heated discussion.
http://www.sqlservercentral.com/columnists/dpeterson/lookuptablemadness.asp
My personal view on it is that if your Master look up table does not have a vast number of rows in it then...
February 13, 2005 at 4:16 pm
document.write is client side stuff.
Response.Write is server side.
<%= is short hand for Response.Write
Response.Write "&news=" + Server.URLEncode((to.Fields.Item("news").Value))
February 13, 2005 at 4:07 pm
I'm not too sure of the rules of American football however if you are prepared for a little foreign intervention try Rugby.
If Rugby looks too sissy try Australian...
February 13, 2005 at 3:48 pm
From a performance perspective I think that the fact that BIT fields take up less space means you can more records on a data page and therefore more records can...
February 13, 2005 at 3:42 pm
What I don't understand is how buffer overruns are found in proprietary software. I can understand open source stuff being found because you have access to the source code,...
February 11, 2005 at 7:15 am
You got something clear, simple, non-ambiguous and non-contradictory out of the Microsoft licensing department????
That is the single most impressive thing that has EVER been put on a forum.
February 11, 2005 at 1:55 am
The FireFox bug is that the address bar does not display the full unicode character set so a unicode character may appear in the address bar as a standard ASCII...
February 11, 2005 at 1:44 am
If Enterprise Manager is not set to ask for the password whenever it connects then all you have to do to reset the SA password is start EM and edit...
February 10, 2005 at 1:59 pm
I find that datetime comparisons are a mine field because your configuration of SQL can be set to accept M/D/Y or D/M/Y so 02/10/2005 can be 10th February or 2nd...
February 10, 2005 at 1:33 pm
Thanks Frank,
If you notice your site traffic jump through the roof it will be my fault!
Judging by the sheer volume of SPAM I get there isn't a limit to the...
February 10, 2005 at 4:24 am
2Gb of data. War and Peace in PDF form is only around 200Mb.
February 10, 2005 at 2:43 am
I visited northern Massachussets where it takes 15 minutes to walk off your own property and I would guess that identity theft would not be a problem there.
I live in...
February 10, 2005 at 2:42 am
If you are just interested in people of 17 or over then add WHERE age>=17 to your SQL, then a simple COUNT(*) will be the sum.
February 10, 2005 at 2:34 am
The looping around the a select statement works quite well because the locks are only held for a short period of time.
February 9, 2005 at 8:45 am
Viewing 15 posts - 2,821 through 2,835 (of 3,607 total)