Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,581 through 11,595 (of 59,095 total)

RE: Using a CTE as a Tally Table

BluePeter - Thursday, August 9, 2018 5:07 AM
Eirikur Eiriksson - Thursday, August 9, 2018 2:47 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)

August 9, 2018 at 8:22 am

#2001027
RE: DB Autogrowth

NewBornDBA2017 - Wednesday, August 8, 2018 12:28 PM
tmmutsetse - Wednesday, August 8, 2018 2:24 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)

August 8, 2018 at 2:58 pm

#2000918
RE: Index Optimize vs Update Stats

Matt Simmons - Wednesday, August 8, 2018 2:20 PM
I recall reading a study/article that I can no longer find that basically said...
--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)

August 8, 2018 at 2:48 pm

#2000915
RE: dtsx job to import and export

aaron.reese - Tuesday, August 7, 2018 6:19 AM
Sue_H - Monday, August 6, 2018 2:15 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)

August 8, 2018 at 2:38 pm

#2000911
RE: Is it OK to leap-frog service packs to get to SQL 2012 SP4?

In this case, that's true but SPs haven't always been that way. Take 2005, for example. In order to update RTM to SP2, you first had to update RTM to...
--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)

August 8, 2018 at 9:20 am

#2000850
RE: please help !! Dynamic SQL

Sue_H - Wednesday, August 8, 2018 8:26 AM
Jason A. Long - Wednesday, August 8, 2018 8:20 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)

August 8, 2018 at 8:43 am

#2000824
RE: please help !! Dynamic SQL

Sue_H - Wednesday, August 8, 2018 8:05 AM
laurie-789651 - Wednesday, August 8, 2018 2:15 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)

August 8, 2018 at 8:14 am

#2000810
RE: Why QUOTENAME is important

Thom A - Wednesday, August 8, 2018 7:49 AM
Jeff Moden - Wednesday, August 8, 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)

August 8, 2018 at 8:02 am

#2000806
RE: Why QUOTENAME is important

Thom A - Wednesday, August 8, 2018 7:12 AM
Thom A - Monday, August 6, 2018 2:22 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)

August 8, 2018 at 7:39 am

#2000795
RE: formatting T-SQL

Eric M Russell - Wednesday, August 8, 2018 7:12 AM
Code reviews are great, but depending on the volume and velocity of development,...
--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)

August 8, 2018 at 7:34 am

#2000792
RE: please help !! Dynamic SQL

Scott Coleman - Wednesday, August 8, 2018 6:26 AM
Jeff Moden - Tuesday, August 7, 2018 8:56 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)

August 8, 2018 at 6:57 am

#2000782
RE: Representing XML data in SQL Server

Eirikur Eiriksson - Tuesday, August 7, 2018 11:49 PM
Thank you for this article Diogo, nice write-up.
😎
Quick thoughts, I think it would...
--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)

August 8, 2018 at 12:12 am

#2000739
RE: Partioning Huge Table (650GB about)

Thanks and, yeah, joined at the hip with you on vertically spitting such wide tables into sister tables but, like you say, not my idea on these tables and common...
--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)

August 7, 2018 at 10:29 pm

#2000735
RE: BCP Error

First of all, I've only ever seen one other table consisting of mostly NVARCHAR(MAX) columns and it was horribly slow because of it. I know you're just trying to get...
--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)

August 7, 2018 at 10:04 pm

#2000734
RE: Need help to extract unstructured excel data to sql server

saptek9 - Tuesday, August 7, 2018 12:04 PM
Can i use Microsoft power query or third party tools like Alteryx to extract 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)

August 7, 2018 at 9:14 pm

#2000732

Viewing 15 posts - 11,581 through 11,595 (of 59,095 total)