Viewing 15 posts - 8,536 through 8,550 (of 49,552 total)
Just a terminology thing...
Hashbytes doesn't encrypt a password, it creates a cryptographic hash. Point of a hash is it's one way and deterministic, which is why it's good for passwords....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2014 at 12:42 pm
Install SQL then patch it to the latest service pack before you try using it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 5, 2014 at 10:51 am
What are you installing, what OS are you running?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 5, 2014 at 4:16 am
Jeff Moden (7/4/2014)
Do you see any disparity between the ad-hoc code data-types and the table data-types that just might cause some unnecessary implicit conversions?
No, Char and varchar are fine together...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 5, 2014 at 4:16 am
See the lock compatibility matrix - http://technet.microsoft.com/en-us/library/ms186396%28v=sql.105%29.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 4, 2014 at 1:06 pm
Write a typical select from the view, run it with Include Actual Execution Plan enabled.
There's nothing special about a CTE with it comes to exec plan. It's just a named...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 4, 2014 at 7:12 am
Yeah, an Oracle forum. We're a MS SQL Server site, so solutions posted here are generally for SQL Server, especially since you never gave any hint you were working with...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 4, 2014 at 6:47 am
Byzza (7/4/2014)
Any Comments ?
You have security vulnerabilities in that. Specifically SQL Injection. DO NOT concatenate user input into a string which will be executed. It is perfectly possible to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 4, 2014 at 4:56 am
Yes and there's a code link on the left-hand side which does work. (though I haven't checked what it includes)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 4, 2014 at 4:09 am
Forums are going to be quiet today. How am I supposed to keep myself entertained on a Friday afternoon at work now? 🙁
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 4, 2014 at 2:47 am
I think you have a key lookup deadlock here (ref https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/)
Can you make that existing index clustered?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 4, 2014 at 2:28 am
mattech06 (7/4/2014)
'2014' was an example, that value's passed by the user.
You can still use either Jack's or my solutions with a value passed from a user. You'd just need a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 4, 2014 at 2:27 am
Tell then they don't have a clue what they're talking about.
Unless this is a SQL Azure database, a single user absolutely can access multiple databases.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 4, 2014 at 2:17 am
Please post the table definition and all indexes on it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 4, 2014 at 2:13 am
Could be there's something in the code you left out which is doing something odd. But we can't tell.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 3, 2014 at 2:29 pm
Viewing 15 posts - 8,536 through 8,550 (of 49,552 total)