Reputation
426
Top tag
Next privilege 500 Rep.
Access review queues
Badges
4 15
Impact
~13k people reached

Apr
21
accepted How many records should be deleted when batch delete is used?
Apr
20
revised How many records should be deleted when batch delete is used?
added 323 characters in body
Apr
20
revised How many records should be deleted when batch delete is used?
added 7 characters in body
Apr
20
comment How many records should be deleted when batch delete is used?
@MarkSinkinson Yes, I am sorry - it is the target table.
Apr
20
revised How many records should be deleted when batch delete is used?
edited body
Apr
20
revised How many records should be deleted when batch delete is used?
edited body
Apr
20
asked How many records should be deleted when batch delete is used?
Apr
16
comment How to optimize STDistance execution?
Yes, I have created such. But the query optimizer is not using it. If I use a hint like this WITH (INDEX(SPATIAL_idx_test)) I am getting the following error - Msg 8635, Level 16, State 4, Line 78 The query processor could not produce a query plan for a query with a spatial index hint. Reason: Spatial indexes do not support the comparator supplied in the predicate. Try removing the index hints or removing SET FORCEPLAN.
Apr
16
asked How to optimize STDistance execution?
Mar
30
comment Storing IP addresses - varchar(45) vs varbinary(16)
If it the case was only for IPv4 I guess I would convert the address to INT and used the field as index key. But for IPv6 I need to use two BIGINT fields and I prefer to store the value in one field - seems to me more natural.
Mar
30
asked Storing IP addresses - varchar(45) vs varbinary(16)
Mar
23
comment Scheduled Database Backup job fails due to lack of disk space
@VojtěchDohnal If the database is under FULL recovery model it will be better to start performing transaction log backups regularly.
Mar
23
comment Scheduled Database Backup job fails due to lack of disk space
Provide more space?
Feb
24
awarded  Notable Question
Feb
17
accepted If “large value types out of row” table option is enabled, the table size is increased
Feb
3
asked Wrapping code in function is causing a huge delay
Feb
2
asked Unable to start a nested transaction for OLE DB provider “SQLNCLI11” for linked server
Jan
30
comment Table size is not changed after new column is added
@RemusRusanu are you sure? I have rebuild the clustered index and the size was not increased. Then I perform simple UPDATE .. SET [column] = '' and the size was increased. I believe rebuilding the index do not force the column to materialized the value.
Jan
29
awarded  Yearling
Jan
29
accepted Table size is not changed after new column is added