Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
youngster
Starting Member
10 Posts |
 Posted - 2007-12-06 : 06:11:29
|
| Assume I have a table with two columns, id (being an id i ms sql 2000) and name. I know that empty rows (i.e. no name) is useless but assume I have plenty of them. How will these affect things? I assume some queries will be slower but which ones? Cheers |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-06 : 06:34:10
|
| Do you mean empty as in NULL or empty as in a string ''?The difference will be that searches on name using like will be slower if you have a string ''. If they are NULL, then apart from selecting all records from the table (or records within a range that has loads of NULLs), you will not see any performance issues. |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-06 : 06:36:01
|
| Do you mean empty as in NULL or empty as in a string ''?The difference will be that searches on name using like will be slower if you have a string ''. If they are NULL, then apart from selecting all records from the table (or records within a range that has loads of NULLs), you will not see any performance issues. |
|
|
|
|
|
|
Empty rows