Viewing 15 posts - 2,401 through 2,415 (of 49,552 total)
Redo? The only time you get a redo (roll forward) is during crash recovery (after opening a DB/starting SQL Server) or restoring a backup.
Can you explain in more detail what...
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
September 13, 2016 at 8:40 am
~300-500 per day, except weekends.
iirc I suggested ignoring blog stats initially...
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
September 13, 2016 at 7:56 am
but this code doesn't work in functions
The isolation level and transaction will have to go into whatever calls the function, but the rest should work in scalar UDFs.
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
September 13, 2016 at 7:55 am
Please note: 3 year old thread.
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
September 13, 2016 at 6:16 am
That's a huge topic. More a book than a forum thread.
https://www.amazon.com/SQL-Server-Query-Performance-Tuning/dp/1430267437/
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
September 13, 2016 at 6:15 am
Do you have an Actual plan please?
I suspect that the top's not removing any rows, that it's something put into update plans for cases where it's a joined update and...
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
September 13, 2016 at 4:27 am
Can you not just attach the .sqlplan file?
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
September 13, 2016 at 4:14 am
What kind of log file are you talking about?
An error log? If so, something like Notepad++ will be able to open it.
A transaction log? If so, there are no errors...
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
September 13, 2016 at 1:15 am
Jeff Moden (9/12/2016)
And, the OP responded :-).
Yes, back in 2014.
Perhaps we can find out how he used partitioning to improve performance. :w00t:
The person who said they used...
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
September 13, 2016 at 1:13 am
NewbyUser (9/12/2016)
Is it possible to block the next number for the Admin-System thats no duplicate OrderIds are possible?
GilaMonster (9/8/2016)
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
September 13, 2016 at 1:11 am
ScottPletcher (9/12/2016)
The trigger should not itself be dynamic. Instead, you should dynamically generate a static trigger.
Seconded.
You can create a procedure that uses the system tables to generate...
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
September 12, 2016 at 4:03 pm
Not an AND (since there's nothing to add the AND to, just a WHERE clause.
SELECT SUM(dbo.[BPRS Scores].Score) - COUNT(dbo.[BPRS Scores].Score) AS Expr1,
...
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
September 12, 2016 at 4:01 pm
Jeff Moden (9/12/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
September 12, 2016 at 3:54 pm
Nope, as I commented on the referenced thread, not possible.
You can log ship up-version if and only if the logs are restored WITH NORECOVERY. You cannot have a version mismatch...
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
September 12, 2016 at 12:44 pm
Then you're going to have to dig into what's happening on that SQL Server and see where the CPU usage is coming from.
Chapter 3 of https://www.red-gate.com/library/troubleshooting-sql-server-a-guide-for-accidental-dbas might help
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
September 12, 2016 at 10:05 am
Viewing 15 posts - 2,401 through 2,415 (of 49,552 total)