Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,786 through 13,800 (of 59,101 total)

RE: Should We Move to Azure?

xsevensinzx - Wednesday, November 8, 2017 10:07 PM
Jeff Moden - Wednesday, November 8, 2017 6:20 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)

November 8, 2017 at 10:21 pm

#1967291
RE: Importing Variable length text files into SQL

steve.alston - Wednesday, November 8, 2017 3:57 PM
Hi
I regularly import a set of Windows text files into SQL. These files are...
--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)

November 8, 2017 at 8:36 pm

#1967287
RE: t-SQL Solution to backup and restore

Grant Fritchey - Wednesday, November 8, 2017 3:21 PM
Jeff Moden - Wednesday, November 8, 2017 1:02 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)

November 8, 2017 at 7:17 pm

#1967285
RE: Planning for a server

Grant Fritchey - Wednesday, November 8, 2017 3:29 PM
Jeff is always right.
Please, someone please tell the love of my life...
--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)

November 8, 2017 at 7:04 pm

#1967284
RE: Should We Move to Azure?

Frank W Fulton Jr - Wednesday, November 8, 2017 5:20 PM
The reason we left the mainframes, back in the 80's was so...
--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)

November 8, 2017 at 6:20 pm

#1967282
RE: Planning for a server

Andre 425568 - Wednesday, November 8, 2017 6:03 AM
Thanks for that. We have other systems on the same databases at other clients....
--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)

November 8, 2017 at 1:42 pm

#1967251
RE: t-SQL Solution to backup and restore

Grant Fritchey - Wednesday, November 8, 2017 12:34 PM
Jeff Moden - Wednesday, November 8, 2017 12:18 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)

November 8, 2017 at 1:02 pm

#1967244
RE: Data row does not have a matching index row in the index

GilaMonster - Wednesday, November 8, 2017 2:07 AM
tony28 - Wednesday, November 8, 2017 1:29 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)

November 8, 2017 at 12:45 pm

#1967240
RE: More Precedence

Budd - Tuesday, November 7, 2017 12:00 PM
That I can understand. However 🙂
Where is the logic in doing a calculation in a...
--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)

November 8, 2017 at 12:43 pm

#1967237
RE: Does Anyone know how you can copy values from a previous row into a null column in SSIS

sgmunson - Wednesday, November 8, 2017 6:43 AM
aaron.reese - Wednesday, November 8, 2017 4:09 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)

November 8, 2017 at 12:34 pm

#1967235
RE: Where are the "official" SQL 2017 logo's?

Theo Ekelmans - Wednesday, November 8, 2017 7:22 AM
Thanks for the link, but i was looking for the highres vector images 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)

November 8, 2017 at 12:32 pm

#1967232
RE: t-SQL Solution to backup and restore

river1 - Wednesday, November 8, 2017 9:17 AM
Thank you.
This brings me to the next question.
I will do like:
1) ALTER...
--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)

November 8, 2017 at 12:18 pm

#1967227
RE: t-SQL Solution to backup and restore

river1 - Wednesday, November 8, 2017 7:32 AM
Hello Guys,
Than you very much for your answers.
Now before restore is done, I need to guaranty...
--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)

November 8, 2017 at 9:11 am

#1967184
RE: Table Structure of Monthly Data

aaron.reese - Wednesday, November 8, 2017 3:23 AM
+1 for the suggestions so far.
One thing we might need to consider is whether this...
--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)

November 8, 2017 at 6:09 am

#1967143
RE: t-SQL Solution to backup and restore

river1 - Tuesday, November 7, 2017 12:47 AM
Dear all,
I was requested by my company to create a solution that is able 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)

November 8, 2017 at 6:05 am

#1967141

Viewing 15 posts - 13,786 through 13,800 (of 59,101 total)