meta user
network profile
| bio | website | |
|---|---|---|
| location | Sydney, Australia | |
| age | ||
| visits | member for | 9 months |
| seen | 13 hours ago | |
| stats | profile views | 43 |
|
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 |
|
Jan 28 |
awarded | Popular Question |
