1,064 reputation
31335
bio website
location Sydney, Australia
age
visits member for 2 years
seen Aug 28 at 4:32

Feb
25
accepted Microsoft Baseline Configuration Analyser on Production
Feb
24
comment Choosing the right algorithm in HashBytes function
We need to join two tables on two nvarchar(max) columns. As you can imagine the query takes along time to execute. We thought it would be better to keep the hashsum value of each nvarchar(max) data and do the join on the hash values rather than the nvarchar(max) values which are blobs. The question is which hash algorithm provides the uniqueness, so that we don't run into the risk of having one hash value for more than one nvarchar(max).
Feb
22
asked Choosing the right algorithm in HashBytes function
Feb
22
asked Microsoft Baseline Configuration Analyser on Production
Feb
22
accepted How to set the timeoffset in a Datetimeoffset column without changing the date part
Feb
20
answered How to set the timeoffset in a Datetimeoffset column without changing the date part
Feb
20
comment How to set the timeoffset in a Datetimeoffset column without changing the date part
Well, I totally agree and understand your point to do it in presentation, but it is a requirement for our scenario, so I should do it in database.
Feb
20
asked How to set the timeoffset in a Datetimeoffset column without changing the date part
Feb
14
asked Is it possible to have a valid backupset with null position?
Feb
13
accepted Server default collation change or not change
Feb
13
answered Server default collation change or not change
Feb
13
awarded  Tumbleweed
Feb
13
accepted Can we minimise the risk of using xp_cmdshell?
Feb
13
comment Can we minimise the risk of using xp_cmdshell?
I see your point Aaron. You're right.
Feb
12
comment Can we minimise the risk of using xp_cmdshell?
Thanks. It seems what I was looking for. Could you please shed some light on how to do that? Do you mean I should enable xp_cmdshell in the stored proc where it's been called before using and then disable it right after the calling statement (when I'm done with that)?
Feb
12
accepted Restore the latest backup on the database
Feb
12
asked Can we minimise the risk of using xp_cmdshell?
Feb
12
comment Restore the latest backup on the database
Thanks for your comprehensive reply. I have access to the original server, can it make a difference? I was hoping to be able to do that without having to add a temp table.
Feb
11
asked Restore the latest backup on the database
Feb
6
asked Server default collation change or not change