Viewing 15 posts - 2,881 through 2,895 (of 3,677 total)
Do you have a clustered index on the table and if so on what column(s)?
How many indices are there on your table? Do you really need them?
It is always...
February 17, 2005 at 1:55 am
Old cynic filter input = "Young, fresh, enthusiastic"
Old cynic filter output = "Naive, unjaundiced and cheap"
Yes you should have employed them
February 17, 2005 at 1:50 am
Anyone remember Z80 and 6502 Assembly Language?
February 16, 2005 at 8:29 am
I cleaned out my attic the other day and came across some college notes.
One of the lecturers had written "with the simplicity and ease of use of CP/M it is...
February 16, 2005 at 1:58 am
Ah 1966, yes indeed. I was conceived during the celebrations!
February 15, 2005 at 4:36 am
When I did the original SQL 6.5 courses the person taking the course warned us that the exams had some answers that had to be answered a particular way and...
February 15, 2005 at 3:43 am
I would like to know of all those certified people
a) Did you sit exams at the end of a formal paid for course?
b) Did you personally pay or did your...
February 15, 2005 at 1:49 am
In other words command that might be remotely useful in an indexed view.
BOL does not exclude aggregate functions but does say that COUNT_BIG should be used rather than COUNT.
It also...
February 15, 2005 at 1:45 am
VBScript
Response.Write "&news=" & Server...
JavaScript
Response.Write "&news=" + Server...
If you are using Visual Studio to write your code there is a way of setting up line by line debugging however I have...
February 15, 2005 at 1:35 am
In short, someone who forgets that businesses sees IT as nothing more than a tool. Pro or anti Microsoft makes no difference.
Its a bit like the politically correct whingers....
February 14, 2005 at 8:20 am
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
Viewing 15 posts - 2,881 through 2,895 (of 3,677 total)