Viewing 15 posts - 11,926 through 11,940 (of 49,552 total)
sqlnaive (8/27/2013)
"DELETE is a logged operation while TRUNCATE is not" as the truncate just deallocates the data pages from the table and that is...
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
August 27, 2013 at 9:01 am
sqlnaive (8/27/2013)
"DELETE can be ROLLED BACK...
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
August 27, 2013 at 9:01 am
Try Books Online (the SQL help file). It has pages and pages on both.
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
August 27, 2013 at 6:43 am
Once more with feeling.
Triggers.
Audits.
The functionality exists, and I've mentioned this repeatedly over a few weeks now, so I don't know why you're still puzzled.
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
August 27, 2013 at 6:27 am
If the transaction has committed, you can't roll it back, no matter whether it's a delete or a truncate. Committed transaction is committed.
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
August 27, 2013 at 6:25 am
davidandrews13 (8/27/2013)
good advice. i'll certainly get in the habit and also update Procedures as-and-when i get to them so that, come day zero, it wont be such a big problem.
Bear...
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
August 27, 2013 at 3:30 am
Koen Verbeeck (8/27/2013)
GilaMonster (8/27/2013)
What version they'll do that is however is another matter....
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
August 27, 2013 at 3:13 am
A simple select * with no joins or aggregates won't use TempDB space, there's nothing in that statement that requires temporary workspace.
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
August 27, 2013 at 2:55 am
When they finally make it mandatory, T-SQL that's not terminated by a ; will indeed break (hence mandatory)
What version they'll do that is however is another matter.
I would...
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
August 27, 2013 at 2:53 am
L' Eomot Inversé (8/26/2013)
Steve Jones - SSC Editor (8/26/2013)
SQLRNNR (8/26/2013)
GilaMonster (8/26/2013)
33 slides for 3 hours. Should be enough.
With that many slides you could easily stretch it into an 8hr preso...
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
August 27, 2013 at 2:49 am
Yes
GilaMonster (8/26/2013)
It's called triggers and audits, along with properly configured security (minimal permissions)
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
August 27, 2013 at 2:42 am
I didn't say it's harmless, I said you are highly unlikely to be able to measure an impact.
Now, what if you have something like Sharepoint that is known to deadlock...
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
August 26, 2013 at 2:58 pm
If you can measure any effect from that traceflag at all I'll be surprised.
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
August 26, 2013 at 2:30 pm
Sean Lange (8/26/2013)
If however you use windows authentication you might be able to use SUSER_SNAME().
I would recommend ORIGINAL_LOGIN() instead, in case there's any impersonation occurring.
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
August 26, 2013 at 2:21 pm
I used to run a server with that traceflag on 24/7. If you have so many deadlocks that the traceflag is causing noticable load, the traceflag is not the primary...
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
August 26, 2013 at 2:20 pm
Viewing 15 posts - 11,926 through 11,940 (of 49,552 total)