Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,516 through 13,530 (of 59,095 total)

RE: Are the posted questions getting worse?

Chris Harshman - Tuesday, December 5, 2017 12:33 PM
JustMarie - Tuesday, December 5, 2017 10:35 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)

December 5, 2017 at 4:54 pm

#1970817
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Tuesday, December 5, 2017 12:59 PM
jonathan.crawford - Tuesday, December 5, 2017...
--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)

December 5, 2017 at 4:50 pm

#1970816
RE: Is This Database Being Used?

Eric M Russell - Tuesday, December 5, 2017 12:21 PM
Jeff Moden - Tuesday, December 5, 2017 9:16...
--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)

December 5, 2017 at 4:45 pm

#1970814
RE: Using CSS to control formatting in dbmail

katie.vaughan - Tuesday, December 5, 2017 8:20 AM
The problem we have is who I am sending to is not going to open...
--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)

December 5, 2017 at 11:58 am

#1970773
RE: Keeping tables online during loading with schema swapping using SSIS

Lynn Pettis - Tuesday, December 5, 2017 8:58 AM
His first article perhaps?
Yeah.... that's the 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)

December 5, 2017 at 11:51 am

#1970771
RE: Is This Database Being Used?

Bert-701015 - Tuesday, December 5, 2017 8:45 AM
Just a heads up; some of the techniques discussed can be skewed (in use) 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)

December 5, 2017 at 9:16 am

#1970743
RE: Keeping tables online during loading with schema swapping using SSIS

I can't put my finger on it but, IIRC, I've seen the graphics for this article from another article here on SSC, particularly that first one and the article was on...
--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)

December 5, 2017 at 6:59 am

#1970705
RE: Bulk insert into table from csv

jaryszek - Tuesday, December 5, 2017 6:00 AM
Hmm it is very strange - now i file was uploaded with success!
I will test...
--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)

December 5, 2017 at 6:36 am

#1970699
RE: Mathematics/Algorithms in SQL

ChrisM@Work - Tuesday, December 5, 2017 12:49 AM
Jeff Moden - Monday, December 4, 2017 5:17 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)

December 5, 2017 at 6:19 am

#1970691
RE: Bulk insert into table from csv

jaryszek - Tuesday, December 5, 2017 5:08 AM
Hi Guys,
in attachment there is my flat file from where I am trying to upload...
--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)

December 5, 2017 at 6:15 am

#1970689
RE: Mathematics/Algorithms in SQL

Alan.B - Monday, December 4, 2017 3:07 PM
I know that this is an old question bumped back up to the front of...
--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)

December 4, 2017 at 5:17 pm

#1970642
RE: Mathematics/Algorithms in SQL

drew.allen - Monday, December 4, 2017 3:23 PM
Jeff Moden - Monday, December 4, 2017 2:49 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)

December 4, 2017 at 4:36 pm

#1970639
RE: Index Fragmentation

Ah... one more thing... I don't believe they use NEWSEQUENTIALID to populate the RecordID column. I believe they use just a normal, random GUID to populate it. In that case...
--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)

December 4, 2017 at 4:23 pm

#1970636
RE: Index Fragmentation

p.s. Almost forgot... much more important than the "logical fragmentation" is "page density" (that % of page fullness thing) and rebuilding stats. For GUID clustered indexes, don't worry about page...
--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)

December 4, 2017 at 4:08 pm

#1970634
RE: Index Fragmentation

jarmendadmin - Monday, December 4, 2017 10:49 AM
Hi everyone,
I am fighting with a SQL Server 2014 table [IR_RecordingMedia] (5.5GB data, 6.8GB Index,...
--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)

December 4, 2017 at 3:53 pm

#1970633

Viewing 15 posts - 13,516 through 13,530 (of 59,095 total)