Viewing 15 posts - 2,761 through 2,775 (of 49,552 total)
ianharris2 (7/21/2016)
does it continue to service requests as normal?
Yes.
The only thing losing the witness does is remove the automatic failover ability.
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 21, 2016 at 8:22 am
Depends what kind of auditing was set up and how.
If you mean the 'SQL Audit' feature specifically, then https://msdn.microsoft.com/en-us/library/cc280728.aspx, but that's not the only way that login monitoring could be...
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 21, 2016 at 8:15 am
Before asking how the entire table gets locked, check and confirm what the exact locks involved are. Next time it happens, look in sys.dm_tran_locks and see what locks exist 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
July 21, 2016 at 8:09 am
Shahin (7/21/2016)
In fact I am sure the Database stors information on login and logout to the database, but question is how to get the info for that user.
You 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
July 21, 2016 at 8:06 am
It'll do the job, but app names are spoofable.
But the thing is, this is a non-technical problem. Address it as a non-technical problem. Someone is doing something they shouldn't, probably...
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 21, 2016 at 4:54 am
Changing the name in one table means that the matching row can't have some completely different attribute changed in another table?
Keep in mind this will cause concurrency problems, may even...
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 21, 2016 at 3:59 am
Update locks are held until the end of the transaction, so locks taken for that update already behave the way you want them 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 21, 2016 at 3:39 am
Hugo Kornelis (7/21/2016)
But frankly, I don't think I know anyone that would fit the bill on these.
I've done the second a few times, out of forgetfulness only not malicious intent.
I...
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 21, 2016 at 3:36 am
ThomasRushton (7/21/2016)
BrainDonor (7/21/2016)
Does anybody know who the "Hotshot SQL Guru" is?https://tmblr.co/Z14uHt29WaOS7
https://tmblr.co/Z14uHt29Ww0kS
https://tmblr.co/Z14uHt29ZP3zF
Somebody wasn't impressed.
Celko?
The first wouldn't apply to Celko. Traceflags aren't ansi standard.
Some people, unfortunately, have an elevated opinion of themselves.
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 21, 2016 at 2:08 am
Just remove that second restore statement. The gui often does odd things, that's why most people advice restoring via T-SQL.
Ignore, didn't read clearly enough
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 21, 2016 at 1:44 am
koti.raavi (7/21/2016)
GilaMonster:Thanks for your response; you mean to say if query is big it’s better to use CTE instead of derived table?
No, I did not mean to say that....
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 21, 2016 at 1:43 am
sql-lover (7/20/2016)
Then I am back to square 1 and my initial question. Which one will provide the best concurrency? The table migration or the CREATE INDEX with ONLINE clause ?
The...
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 21, 2016 at 1:41 am
What's your RESTORE statement?
If you're using the GUI, rather don't. It's a pain for this reason. At best use it to script the restores.
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 20, 2016 at 4:12 pm
sql-lover (7/20/2016)
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 20, 2016 at 4:04 pm
CREATE CLUSTERED INDEX ...
WITH (DROP_EXISTING = ON)
will probably be the least disruptive, but the log impact will not be small (estimate 2x the size of the data), you'll need probably...
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 20, 2016 at 2:28 pm
Viewing 15 posts - 2,761 through 2,775 (of 49,552 total)