Viewing 15 posts - 2,731 through 2,745 (of 49,552 total)
Can someone who speaks Spanish please check the translations? http://www.sqlservercentral.com/Forums/Topic1804719-2799-1.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 27, 2016 at 3:39 am
Via google translate:
Hello dear, I tell them the problem I have, I have a database in which they separated in mdf, NDF and LDF files. The NDF which different filegroup...
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 27, 2016 at 3:38 am
It'll be the new cardinality estimator. Most queries improve in performance or stay the same, a small number typically experience performance regressions.
I've seen 3 clients upgrade to 2014. One did...
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 26, 2016 at 8:07 am
BLOB_EATER (7/26/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 26, 2016 at 7:58 am
http://sqlinthewild.co.za/index.php/2011/05/17/on-transactions-errors-and-rollbacks/
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 26, 2016 at 1:50 am
Just to give you a benchmark, my new laptop has as much memory as your production server... 🙂
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 25, 2016 at 1:40 pm
Lynn Pettis (7/25/2016)
GilaMonster (7/25/2016)
fergfamster (7/25/2016)
You dont think using the @@rowcount is useful? Better to just do both statements?
No, because what if there's 6 rows that need inserting and 4 updating?...
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 25, 2016 at 1:37 pm
fergfamster (7/25/2016)
You dont think using the @@rowcount is useful? Better to just do both statements?
No, because what if there's 6 rows that need inserting and 4 updating? To use rowcount,...
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 25, 2016 at 1:15 pm
http://source.entelect.co.za/why-is-this-upsert-code-broken
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 25, 2016 at 12:21 pm
Siddarth V (7/25/2016)
Possibility of duplicate incoming data is zero.
I've heard that before. Often followed later by finding out that something had changed somewhere upstream and there now were duplicates
If you're...
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 25, 2016 at 12:20 pm
Assuming you're referring to Always On Availability Groups, that can't cause primary key violations. It's a high availability feature that provides secondary servers to take over if the primary fails....
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 25, 2016 at 11:53 am
And missing any form of error handling.
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 25, 2016 at 8:44 am
Doesn't mean the transaction has to be committed, you can get the IDs within the transaction. You can get them from the insert using the OUTPUT clause, then use 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 24, 2016 at 2:24 am
stricknyn (7/22/2016)
But unfortunately TableA has to be committed first.
Why?
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 23, 2016 at 7:31 am
What you can also do, to narrow down the cause, is schedule a job to write the following into a table, during the backup process.
SELECT name, log_reuse_wait_desc FROM sys.databases
WHERE name...
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 23, 2016 at 7:29 am
Viewing 15 posts - 2,731 through 2,745 (of 49,552 total)