Viewing 15 posts - 1,321 through 1,335 (of 49,552 total)
The passwords for SQL logins are stored hashed. SHA_512 in 2012, no idea if that's changed since then
http://sqlity.net/en/2460/sql-password-hash/
syslogins is a deprecated view, included only for...
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
June 7, 2017 at 1:26 pm
GilaMonster - Tuesday, June 6, 2017 12:48 PMCrystal ball, please, someone.
https://www.sqlservercentral.com/Forums/1878960/Find-user-connections-to-SQL-server-tables
headdesk
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
June 7, 2017 at 11:54 am
Tune your queries, that's often a far better return than adding memory.
And with 34GB memory, I would probably not go above 28GB on max server memory, and that's...
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
June 7, 2017 at 10:41 am
A seek operation requires that there is a value being searched for, and the column that is being searched is the left-most column of the index. That's the absolute minimum...
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
June 7, 2017 at 9:47 am
Why do you want the session_id?
The point of that report is to identify queries that need tuning to reduce their CPU usage.
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
June 7, 2017 at 6:52 am
Most likely some HDD failure that's corrupted the data file. That kind of thing is typically not repairable as you can't even open the database.
Restore from your last...
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
June 7, 2017 at 5:13 am
Please post new questions in a new thread, and give as much detail as possible.
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
June 7, 2017 at 5:02 am
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
June 6, 2017 at 1:30 pm
Begin Tran ... Commit is about atomic operations and isolation, it's a transaction block. If you need the inserts, deletes and other things to be atomic, you need a transaction...
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
June 6, 2017 at 12:49 pm
Crystal ball, please, someone.
https://www.sqlservercentral.com/Forums/1878960/Find-user-connections-to-SQL-server-tables
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
June 6, 2017 at 12:48 pm
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
June 6, 2017 at 12:44 pm
I'd love to help you, but I don't understand what exactly you want.
Does the client know that users don't connect to tables? If so, then what specifically are...
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
June 6, 2017 at 9:48 am
Connections aren't made to tables though. Users connect to databases, and run queries against tables.
Given that, what exactly are you trying to determine?
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
June 6, 2017 at 6:05 am
Both are valid options, go with whatever you enjoy more.
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
June 6, 2017 at 4:42 am
What exactly are you looking for?
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
June 6, 2017 at 2:01 am
Viewing 15 posts - 1,321 through 1,335 (of 49,552 total)