Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,526 through 12,540 (of 59,099 total)

RE: Keep It All

Eric M Russell - Friday, April 20, 2018 12:15 PM
jay-h - Friday, April 20, 2018 11:30 AM
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 20, 2018 at 1:03 pm

#1987744
RE: Where GROUPING SETS is used.

Key point here... don't confuse OLAP Cubes with the WITH CUBE option of GROUP BY.
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 20, 2018 at 11:54 am

#1987727
RE: Are the posted questions getting worse?

Lynn Pettis - Friday, April 20, 2018 10:15 AM
Jeff Moden - Friday, April 20, 2018 9:07 AM
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 20, 2018 at 10:29 am

#1987706
RE: Keep It All

Shifting gears a bit, we're setting up to delete 1TB from a 1.4TB database and 600GB from a 1TB database. The data we're dropping is simply data that no one...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 20, 2018 at 9:34 am

#1987690
RE: The best way to load big chunks of rolling data

valeryk2000 - Friday, April 20, 2018 8:50 AM
We have monthly loads of a THREE month of data: say, in April it's Jan,...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 20, 2018 at 9:28 am

#1987689
RE: Where GROUPING SETS is used.

saravanatn - Friday, April 20, 2018 9:08 AM
Jeff Moden - Friday, April 20, 2018 7:39 AM
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 20, 2018 at 9:24 am

#1987688
RE: Are the posted questions getting worse?

Shifting gears a bit, I'm giving a new presentation here in the Detroit area for the local PASS Chapter on the 10th of May. I was limited to 1000 bytes...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 20, 2018 at 9:07 am

#1987684
RE: SQL Server 2016 Enterprise - Free space recommendation

dajonx - Friday, April 20, 2018 7:16 AM
Ah, yes... You're right, Jason. I am confusing database file free space with free space...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 20, 2018 at 7:54 am

#1987667
RE: Where GROUPING SETS is used.

saravanatn - Thursday, April 19, 2018 9:03 PM
I am working as a Database Tester for quite some time. But I never comes...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 20, 2018 at 7:39 am

#1987662
RE: Backup and restore speeds are significantly slower on flash storage than on sas drives.

Feivel - Thursday, April 19, 2018 2:07 PM
One of our users complained that when trying to backup/restore a database roughly a GB...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 20, 2018 at 7:25 am

#1987658
RE: Spills into tempdb poor performing query fixed by converting to SP

My first-blush guess would be that the original code used values only known at execution time and the stored procedure used parameters known prior to execution time.
However, that's...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 20, 2018 at 7:18 am

#1987653
RE: Transferring data between tables

richardmgreen1 - Friday, April 20, 2018 6:52 AM
Thanks all
Unfortunately, I can't make that decision arbitrarily.
I'll have a chat with my boss and...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 20, 2018 at 7:13 am

#1987651
RE: Transferring data between tables

richardmgreen1 - Thursday, April 19, 2018 8:20 AM
ZZartin - Thursday, April 19, 2018 8:08 AM
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 19, 2018 at 8:46 am

#1987538
RE: SQL Server 2016 Enterprise - Free space recommendation

dajonx - Thursday, April 19, 2018 7:41 AM
Thank you.
I wasn't sure if the NTFS performance degrading when there's less than 15% free...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 19, 2018 at 8:42 am

#1987537
RE: Log File running out of space

itmasterw 60042 - Thursday, April 19, 2018 6:06 AM
Hi,
Recently I changed our database recovery model from Simple to Full. However, now the...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 19, 2018 at 8:28 am

#1987535

Viewing 15 posts - 12,526 through 12,540 (of 59,099 total)