Jeff Moden

Forum Replies Created

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

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
RE: Rebuild index taking time

pietlinden - Thursday, December 20, 2018 8:33 PM
This might be a helpful read:
https://www.brentozar.com/archive/2013/09/index-maintenance-sql-server-rebuild-reorganize/
Lordy, don't use REORGANIZE. It'll take longer, beat 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 20, 2018 at 10:46 pm

#2017013
RE: Convert string MMDDYYYY to a date

Since you're using SQL Server 2012, DATEFROMPARTS with substrings to isolate the parts might be the fastest.
Of course my initial thought is to ask that they send...
--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:36 pm

#2017012
RE: urgent

Welcome. I suggest that you first download a free copy of SQL Server 2016 or 2017 Developers Edition, install it on your computer, buy a book on the subject 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 20, 2018 at 10:30 pm

#2017011
RE: Getting distinct values from multiple lines??

jbalbo - Thursday, December 20, 2018 3:08 PM
Hi
I am trying to get distinct values from multiple filed on multiple lines per "client"
example
Client ...
--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:24 pm

#2017010
RE: Set @rptStartDate = CASE WHEN 'TransactionCount' = 2 Then '11/1/2018' - 30 days Else '11/1/2018' End

jcelko212 32090 - Wednesday, December 19, 2018 1:50 PM
patrickmcginnis59 10839 - Wednesday, December 19, 2018 12:53 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 20, 2018 at 1:32 pm

#2016987
RE: Get Temp Table definition

Jonathan AC Roberts - Thursday, December 20, 2018 9:13 AM
I really like this script. Just been using it to create definitions or...
--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 1:06 pm

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

Heh... hold the phone.... If you have a user ID (and assuming that it's unique), why do you need another surrogate key to begin with??? :blink:
--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 8:59 am

#2016964

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