166 reputation
4
bio website demas.me
location
age
visits member for 2 years, 10 months
seen Jul 6 at 8:20

Developer


Sep
24
awarded  Autobiographer
Feb
23
comment Best Isolation Level to avoid deadlocks in Sql Server
in this case choose of isolation level depends on side effects you are ready to have (dirty reads, uncommitter transactions and so on)
Feb
23
answered Best Isolation Level to avoid deadlocks in Sql Server
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