Viewing 15 posts - 12,856 through 12,870 (of 59,095 total)
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2018 at 8:53 pm
Take your time. You can't think if you're in a rush. Put it up for a couple of days and come back to it.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2018 at 7:31 pm
It's broke...
DECLARE
@Year
SMALLINT
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2018 at 2:58 pm
We have SQL Server 2012, on production database only 1 CPU used out of 4...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2018 at 2:42 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2018 at 2:35 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2018 at 1:34 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2018 at 9:27 am
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2018 at 9:21 am
Agreed that they're wrong if the rows are based on user clicks. Not seeing...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2018 at 9:17 am
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2018 at 9:14 am
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2018 at 9:10 am
Whatever you do, don't audit INSERTS. I'll be back to explain why after work tonight.
{EDIT} And don't use supposedly "portable" CLR triggers. They're horrible for performance because the...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2018 at 7:18 am
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2018 at 7:11 am
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2018 at 7:04 am
Apparently Ola's scripts are spot on in providing the errors that they did. Please see the following URL:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url#limitations
In particular, see the part where it says... --Jeff Moden Change is inevitable... Change for the better is not.
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
February 20, 2018 at 6:40 am
Viewing 15 posts - 12,856 through 12,870 (of 59,095 total)