network profile
|
Aug 6 |
awarded | Teacher |
|
Aug 6 |
comment |
Does having an index on a VARCHAR column with a lot of very similar starting values have bad performance Each index has statistics (sqlserverperformance.idera.com/tsql-optimization/…). MS SQL uses it to decide what will be faster: use index or not to use. If you have the only little part of records which satisfy to your condition the index will be used. |
|
Aug 6 |
comment |
Does having an index on a VARCHAR column with a lot of very similar starting values have bad performance @RGI, it is not my question so I don't know what it is. If I understanded correctly it is a inner implementation of Btree in MS SQL and only MS developers can know how it works. |
|
Aug 6 |
comment |
Does having an index on a VARCHAR column with a lot of very similar starting values have bad performance In this case (unique key) the index selectivety is fine and the server will use it. |
|
Aug 6 |
answered | Does having an index on a VARCHAR column with a lot of very similar starting values have bad performance |
|
Aug 6 |
comment |
SQl Server Password Change after installation Why? Can you give more detailed info. Screenshot, error messages and so on |
|
Aug 6 |
comment |
SQl Server Password Change after installation You connect to ANKUR-PC. Can you connect to localhost ? |
|
Aug 6 |
comment |
SQl Server Password Change after installation 1. Can you ping the server ? 2. Can you connect to your server from server machine ? |
|
Aug 6 |
comment |
SQl Server Password Change after installation I cannot read anything on this little image :) |
|
Aug 6 |
comment |
SQl Server Password Change after installation It will be helpfull if you attach the screnshot of you problem. |
|
Aug 6 |
answered | SQl Server Password Change after installation |
|
Dec 20 |
awarded | Student |
|
Dec 20 |
awarded | Scholar |
|
Dec 14 |
asked | MDX misunderstanding: complex FROM clause |
