Jeff Moden

Forum Replies Created

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

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
RE: Name Value Pairs Table Handling

Matt Miller (4) - Tuesday, November 7, 2017 10:51 AM
Have you considered just storing the XML itself (or a standardized version 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)

November 8, 2017 at 6:01 am

#1967139
RE: Date Ranges - Simple, but seemingly impossible

jcelko212 32090 - Tuesday, November 7, 2017 1:00 PM
Vegeta7 - Tuesday, November 7, 2017 2:34 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 7, 2017 at 6:48 pm

#1967079
RE: What are you worth?

norway.martin - Tuesday, November 7, 2017 12:16 PM
Jeff Moden - Tuesday, November 7, 2017 12:12 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 7, 2017 at 12:43 pm

#1967045
RE: What are you worth?

norway.martin - Tuesday, November 7, 2017 11:35 AM
You are aware that it is usually illegal for a company in the US 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 7, 2017 at 12:12 pm

#1967041
RE: SQL versus program

patrickmcginnis59 10839 - Tuesday, November 7, 2017 6:27 AM
Sergiy - Tuesday, November 7, 2017 4:46 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 7, 2017 at 12:09 pm

#1967040
RE: ApexSQL Monitor

KJKKPSI - Tuesday, November 7, 2017 9:32 AM
Jeff Moden - Tuesday, November 7, 2017 7:46 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 7, 2017 at 10:03 am

#1967020

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