Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,246 through 10,260 (of 59,093 total)

RE: Are the posted questions getting worse?

'Twas the night before Christmas and all through "The Room",
The servers were humming and no apps have gone "Boom'
This is all possible because we worked as a Team,
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)

December 24, 2018 at 8:56 pm

#2017294
RE: Sample TSQL , SSIS , SSRS projects

daniarchitect - Monday, December 24, 2018 11:16 AM
Thom A - Monday, December 24, 2018 8:07 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 24, 2018 at 4:54 pm

#2017292
RE: Parent/Child - where I am standing

shamshad.ali - Monday, December 24, 2018 4:31 AM
In parent child, I want to pass EmployeeId and get the list of all parents...
--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 24, 2018 at 3:37 pm

#2017291
RE: Parent/Child - where I am standing

jcelko212 32090 - Monday, December 24, 2018 11:04 AM
>> In parent-child, I want to pass emp_id and get the list of all...
--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 24, 2018 at 2:05 pm

#2017290
RE: Queries to practice compilation and recompilation.

Tac11 - Monday, December 24, 2018 10:04 AM
Yes, Jeff.
It's pretty easy to do such a thing. All you need to do is...
--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 24, 2018 at 11:09 am

#2017281
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Monday, December 24, 2018 8:08 AM
Merry Christmas and Happy Holidays. Everyone be safe and enjoy time...
--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 24, 2018 at 10:47 am

#2017237
RE: Validate date stored as a string as a complete, valid date

Scott In Sydney - Thursday, December 20, 2018 11:30 PM
ScottPletcher - Tuesday, December 18, 2018 11:12...
--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 24, 2018 at 10:41 am

#2017236
RE: Understanding Peer-to-Peer Transactional Replication, Part 1

samot-dwarf - Sunday, December 23, 2018 10:37 AM
I agree to the article beside the part about the clustering key and Fillfactor. 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)

December 23, 2018 at 9:34 pm

#2017178
RE: fetch multiple rows with single string

abhas - Sunday, December 23, 2018 5:03 AM
Hello friends,
I am having table which contains data stdentname,teachername,subjectname as below.
Studentname ...
--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 23, 2018 at 8:48 am

#2017169
RE: WMI connection error using Invoke-Sqlcmd

Heh... ok. Understood. But, if your stuff is working, you should be teaching PowerShell users a new skill. 😀
--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 22, 2018 at 10:49 am

#2017162
RE: PERCENTILE_DISC for median calculation

drew.allen - Wednesday, December 19, 2018 1:48 PM
Jeff Moden - Tuesday, December 18, 2018 8: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)

December 21, 2018 at 6:53 pm

#2017149
RE: WMI connection error using Invoke-Sqlcmd

smw147 - Wednesday, December 19, 2018 3:12 AM
... am trying to convert an old batch script that run some sql files via sqlcmd command 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)

December 21, 2018 at 6:34 pm

#2017147
RE: Best Practice for batch processing In SQL Server

Preprocess all your data in staging tables. When you're ready to update the final tables from the staging tables, start with ...
SET XACT_ABORT ON;
BEGIN TRANSACTION
--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 21, 2018 at 6:32 pm

#2017146
RE: Month T-1

1. Hopefully this teaches why you should never store formatted dates in a table. Leave such formatting to when you need to present the data.
2. Hopefully this also teaches...
--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 21, 2018 at 6:24 pm

#2017145
RE: Convert string MMDDYYYY to a date

Jeffrey Williams 3188 - Friday, December 21, 2018 10:36 AM
below86 - Thursday, December 20, 2018 2:47 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 21, 2018 at 2:06 pm

#2017139

Viewing 15 posts - 10,246 through 10,260 (of 59,093 total)