Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 8
Impact
~5k people reached

Feb
15
comment Why does sql server need to convert count(*) result into int before comparing it with an int variable?
Did you try COUNT(id) which means id column as your primary int field index column?
Oct
5
comment Do I need an index on this?
Thx for the hint.
Jun
14
comment computed columns, index, clustered index and covering index?
+1 for philosophy corner opened :)
Jun
14
comment Determine sql server installation (server or client tools only)
I knew the software keys, already checking them, but this don't tell me if there is just client tools installed or a server running. But checking the existance of a sql server service will do it, good idea.