182 reputation
110
bio website daniel.wertheim.se
location Sweden
age
visits member for 2 years, 9 months
seen Apr 21 at 19:03

Aug
21
awarded  Popular Question
Jul
2
awarded  Curious
Jun
6
awarded  Popular Question
Mar
11
awarded  Popular Question
Sep
21
awarded  Notable Question
Mar
28
awarded  Supporter
Mar
28
accepted SQL Server 2012, rebuild not lowering avg fragmentation
Mar
27
awarded  Editor
Mar
27
revised SQL Server 2012, rebuild not lowering avg fragmentation
added 172 characters in body
Mar
27
asked SQL Server 2012, rebuild not lowering avg fragmentation
Jan
3
awarded  Popular Question
Nov
15
comment SQL-Server 2008 R2, update Microsoft.SqlServer.Types.dll
Of course I will not write my own. And upgrading to SQL2012 is not an option. Will go with the ugly SQL dance.
Nov
15
comment SQL-Server 2008 R2, update Microsoft.SqlServer.Types.dll
Or write my own
Nov
15
asked SQL-Server 2008 R2, update Microsoft.SqlServer.Types.dll
Jul
12
comment SQL Server : where with cast(value as varbinary) vs cast(value as varbinary(300))
The column is indexed, yes, but will it not evaluate the second part anyway?
Jul
12
comment SQL Server : where with cast(value as varbinary) vs cast(value as varbinary(300))
So then I need to specify the max length of the nvarchar column. I need to do a exact match and don't want to go the collate path.
Jul
12
asked SQL Server : where with cast(value as varbinary) vs cast(value as varbinary(300))
Jun
30
asked Primary key vs. unique index: performance difference with foreign keys?
Apr
16
accepted Which should be used after messing up clustered index? Update statistics, Reindex or Reorganize
Apr
15
comment Which should be used after messing up clustered index? Update statistics, Reindex or Reorganize
It's the clustered key I'm talking about. Look at the edited question above. I complemented with a scenario.