Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,431 through 11,445 (of 59,099 total)

RE: Count the Number of Weekend Days between Two Dates

dbeggs57 - Thursday, August 23, 2018 2:12 PM
Adam, thank you for your example, it got me thinking. I didn't have the table you...
--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)

August 23, 2018 at 5:31 pm

#2003130
RE: Bullk insert in sql server..

Unless they've changed it recently, BULK INSERT and BCP are delimiter sensitive when it comes to counting rows rather than what humans perceive to be a line in a file. ...
--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)

August 23, 2018 at 3:48 pm

#2003122
RE: PIVOT

TJ_T - Thursday, August 23, 2018 10:53 AM
I need help with SQL PIVOT
Example
SELECT Manufacturer, CarType
FROM Vehicles
Manufacture Cartype
Ford ...
--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)

August 23, 2018 at 3:40 pm

#2003121
RE: Convert Varchar field

bpmosullivan - Wednesday, August 22, 2018 7:35 PM
I have a Varchar field with units in inches 🙁 that i need to convert...
--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)

August 23, 2018 at 3:35 pm

#2003118
RE: Is it possible to retrieve name(s) of SSIS package(s) that have an Exec SQL task that executes a specific SP?

VoldemarG - Thursday, August 23, 2018 3:03 PM
True. but there are 1100 packages on 3 prod servers... 🙂
Heh... Phil wasn't suggesting 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)

August 23, 2018 at 3:29 pm

#2003117
RE: Count the Number of Weekend Days between Two Dates

carsten.saastamoinen - Thursday, August 23, 2018 9:54 AM
"Every bit helps avoid the "Death by 1,000 cuts" that so many systems experience. ...
--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)

August 23, 2018 at 11:02 am

#2003084
RE: Count the Number of Weekend Days between Two Dates

csj - Thursday, August 23, 2018 7:55 AM
But use of memory for the recursive solution is not a problem until someone uses that...
--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)

August 23, 2018 at 8:11 am

#2003058
RE: Count the Number of Weekend Days between Two Dates

csj - Thursday, August 23, 2018 7:31 AM
One of the big problems when we are writing SELECT statement is, that there 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)

August 23, 2018 at 7:48 am

#2003051
RE: File sizes in system tables

elea.grig - Thursday, August 23, 2018 6:48 AM
I am querying select * from sys.master_files in order to know the file sizes...
--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)

August 23, 2018 at 7:34 am

#2003047
RE: Sanity check

HappyGeek - Wednesday, August 22, 2018 11:59 AM
Even if you had a tried and proven method of managing file growth, would you...
--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)

August 23, 2018 at 7:30 am

#2003045
RE: Count the Number of Weekend Days between Two Dates

While I don't necessarily agree with the way things were done in the article, I have to tell you that I never agree with any form of recursion even for...
--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)

August 23, 2018 at 7:10 am

#2003040
RE: Count the Number of Weekend Days between Two Dates

csj - Thursday, August 23, 2018 1:29 AM
Why do it in such a complex way. Use recursion, which also is faster in...
--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)

August 23, 2018 at 6:50 am

#2003036
RE: Huge number of tables

JackCarrington - Thursday, August 23, 2018 1:00 AM
Jeff Moden - Friday, August 17, 2018 6:48 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)

August 23, 2018 at 6:45 am

#2003035
RE: Insert new records from one database to another using SSIS

Why not "just" use replication or log shipping for 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)

August 22, 2018 at 4:57 pm

#2002961
RE: Checking my knowledge

Grant Fritchey - Wednesday, August 22, 2018 11:57 AM
john_laspada - Wednesday, August 22, 2018 10:48 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)

August 22, 2018 at 12:21 pm

#2002903

Viewing 15 posts - 11,431 through 11,445 (of 59,099 total)