Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,026 through 14,040 (of 59,095 total)

RE: Loading CSVs

What a terrible shame it is that MS doesn't make this possible this easily using just T-SQL.
--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)

October 20, 2017 at 7:09 am

#1964479
RE: Making Indexes Invisble to the Optimiser

I could be wrong but, without disabling or dropping the index, making indexes invisible to the optimizer in SQL Server isn't possible.
--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)

October 20, 2017 at 7:06 am

#1964477
RE: Trying to speed up this 'GetWorkingDays' function.

@jason,
I've seen it in the formulas but asking the questions out loud to make absolutely sure...
1. If a time is involved in the dates, it should...
--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)

October 20, 2017 at 6:37 am

#1964475
RE: Table Index

David Burrows - Thursday, October 12, 2017 9:32 AM
I have a potential table

CREATE TABLE dbo.Preferences
(
EmailAddress VARCHAR(100) NOT NULL,
ChannelID INTEGER NOT...
--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)

October 19, 2017 at 8:34 pm

#1964447
RE: OPEN TEXTFILE FROM T-SQL

sgmunson - Thursday, October 19, 2017 1:50 PM
And just assuming that you have your data files properly described, the error you are...
--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)

October 19, 2017 at 5:24 pm

#1964444
RE: Extreme slowness

Steve Jones - SSC Editor - Thursday, October 19, 2017 10:35 AM
We are implementing a new web server and a flip 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)

October 19, 2017 at 5:19 pm

#1964443
RE: Data row does not have a matching index row in the index

Gail is correct and I didn't mean to imply that it was the cause of a row missing from an index. I meant it only as a bit of advice...
--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)

October 19, 2017 at 5:14 pm

#1964442
RE: Having trouble displaying a date in a certain format...

crmitchell - Thursday, October 19, 2017 10:23 AM
Jeff,
True enough. Reports and third party software are probably the most common situations where you have...
--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)

October 19, 2017 at 5:01 pm

#1964441
RE: SQL versus program

rot-717018 - Thursday, October 19, 2017 4:22 AM
Thanks Jeff for sharing your thoughts with me.
I personnally think that SQL queries scares those...
--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)

October 19, 2017 at 9:44 am

#1964368
RE: Table Index

P.S. No wanting to rely on abbreviations, what does GDPR stand for in this case?
--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)

October 19, 2017 at 9:25 am

#1964361
RE: Table Index

Hi David,
Having recently gone through some problems with several relatively large tables that were once the size you predict, I do have some suggestions for "bullet proofing". I'll...
--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)

October 19, 2017 at 9:22 am

#1964359
RE: django (not the movie)

xsevensinzx - Thursday, October 19, 2017 7:16 AM
Sure. I've used Django with SQL Server, but have mostly switched to using Flask over...
--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)

October 19, 2017 at 8:36 am

#1964354
RE: Having trouble displaying a date in a certain format...

crmitchell - Thursday, October 19, 2017 3:21 AM
chef423 - Wednesday, October 11, 2017 2:24 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)

October 19, 2017 at 8:18 am

#1964349
RE: Extreme slowness

Steve Jones - SSC Editor - Wednesday, October 18, 2017 7:25 PM
We are experiencing some CPU issues on the web servers. 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)

October 19, 2017 at 7:57 am

#1964346
RE: Trying to speed up this 'GetWorkingDays' function.

I was able to get parallelism out of it by simplifying the function instead of the "Make Parallel" thing but now I'm dealing with an implicit cast that's making mine...
--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)

October 19, 2017 at 12:15 am

#1964310

Viewing 15 posts - 14,026 through 14,040 (of 59,095 total)