Viewing 15 posts - 2,401 through 2,415 (of 49,571 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...
September 13, 2016 at 8:40 am
~300-500 per day, except weekends.
iirc I suggested ignoring blog stats initially...
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.
September 13, 2016 at 7:55 am
That's a huge topic. More a book than a forum thread.
https://www.amazon.com/SQL-Server-Query-Performance-Tuning/dp/1430267437/
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...
September 13, 2016 at 4:27 am
Can you not just attach the .sqlplan file?
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...
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...
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
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...
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,
...
September 12, 2016 at 4:01 pm
Jeff Moden (9/12/2016)
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...
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
September 12, 2016 at 10:05 am
Viewing 15 posts - 2,401 through 2,415 (of 49,571 total)