Jeff Moden

Forum Replies Created

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

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
RE: Transferring data between tables

richardmgreen1 - Wednesday, April 18, 2018 6:32 AM
The tables are, for the most part, identical.
I know it seems too obvious but I...
--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:09 am

#1987527
RE: Are the posted questions getting worse?

Lynn Pettis - Wednesday, April 18, 2018 2:19 PM
Lynn Pettis - Tuesday, April 17, 2018 10:26 PM
--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 7:26 am

#1987510
RE: Default trace - high read activity on disk

Paul Cresham - Thursday, April 19, 2018 5:38 AM
We are running Idera's SQL Diagnostic Manager and we also have some Red Gate...
--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 7:23 am

#1987509
RE: Default trace - high read activity on disk

Paul Cresham - Wednesday, April 18, 2018 2:01 PM
I've noticed on one of our servers running SQL Server 2014 Enterprise in Resource...
--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 18, 2018 at 7:18 pm

#1987438

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