Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,261 through 10,275 (of 59,102 total)

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
RE: Performance Counters

edwardwill - Friday, December 21, 2018 3:28 AM
Could you provide a link to an authoritative resource, please?
This is one of those "If...
--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 9:22 am

#2017094
RE: dealing with Bulk load data conversion error

I do use the error sequestration functionality of BULK INSERT but I hate the cryptic messages it stores. I've never understood why the messages can't be more like the ones...
--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 9:19 am

#2017093
RE: Convert string MMDDYYYY to a date

frederico_fonseca - Friday, December 21, 2018 8:25 AM
timings is going to depend hugely on the spec.
on my laptop (I7-8550-U 1.8GHz - 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 21, 2018 at 8:43 am

#2017079
RE: Using Hash values as Dimension Keys in Datawarehouse

xsevensinzx - Friday, December 21, 2018 7:16 AM
Jeff Moden - Thursday, December 20, 2018 8:59 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 21, 2018 at 8:11 am

#2017074
RE: Convert string MMDDYYYY to a date

Eirikur Eiriksson - Friday, December 21, 2018 2:29 AM
Jeff Moden - Thursday, December 20, 2018 10:36 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 7:53 am

#2017072
RE: Rebuild index taking time

rinu philip - Thursday, December 20, 2018 6:20 PM
Question: rebuild index task in a SQL 2014 ENV is taking a long 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 20, 2018 at 10:49 pm

#2017014

Viewing 15 posts - 10,261 through 10,275 (of 59,102 total)