Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,546 through 19,560 (of 59,072 total)

RE: How to Import Data to SQL Server from Access Database using TSQL Script

pietlinden (9/22/2015)
If you're importing from an .MDB file, use the Jet 4.0, not the ACCDB nightmare. The Jet one actually works.
IIRC, I don't believe that JET will work on...
--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)

September 22, 2015 at 7:47 pm

#1828632
RE: Logic to split Monthly numbers

sharonsql2013 (9/22/2015)
That really helped. Thanks
Do you understand how it works and why?
--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)

September 22, 2015 at 7:44 pm

#1828631
RE: DBA - Where in your organization?

joffwilliams (9/22/2015)
I'm interested in how it is structured in other organizations since there can be some variance from place to place.
Why? And, no... that's not a smart-guy answer on...
--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)

September 22, 2015 at 5:27 pm

#1828619
RE: 1st Time?

Two Views sounds a bit complicated. Just do a COUNT(columnname) OVER (PARTITION BY columnname) in a CTE and SELECT only those items that have a count of 1... no...
--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)

September 22, 2015 at 5:18 pm

#1828618
RE: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

@erichansen1836
Just a quick question and apologies for not following/reading all of the posts that have occurred since the last time I dropped in on this thread...
Do you actually 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)

September 22, 2015 at 5:00 pm

#1828613
RE: Painful datetime conversion

Eirikur Eiriksson (9/19/2015)
Jeff Moden (9/19/2015)
Eirikur Eiriksson (9/17/2015)
Using my normal test harness, Kristen's DATETIMEFROMPARTS solution is a clear winner, more than twice faster than the next one. Note that the slowest...
--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)

September 21, 2015 at 1:59 pm

#1828218
RE: Top SQL objects consuming CPU

GilaMonster (9/20/2015)
The reports use the same DMVs that the OP doesn't want to use because they're since the last compile, not a time frame.
Damn... I keep forgetting that because 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)

September 20, 2015 at 10:32 am

#1827952
RE: SSIS script to create folders

Newbie36037 (9/18/2015)
The documents are being migrated to a new application, so at the moment the date of the order is unimportant as all documents will eventually be moved
These types of...
--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)

September 20, 2015 at 10:28 am

#1827950
RE: Top SQL objects consuming CPU

nagakula (9/19/2015)
hi Team,
We are trouble shooting a SQL Server high CPU issue and want to know what statements are the expensive ones in terms of CPU usage (basically OpenText...
--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)

September 19, 2015 at 8:50 pm

#1827917
RE: Painful datetime conversion

Eirikur Eiriksson (9/17/2015)
Using my normal test harness, Kristen's DATETIMEFROMPARTS solution is a clear winner, more than twice faster than the next one. Note that the slowest solutions and those generating...
--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)

September 19, 2015 at 6:33 am

#1827891
RE: Are the posted questions getting worse?

SQLRNNR (9/18/2015)
Lynn Pettis (9/18/2015)
SQLRNNR (9/18/2015)
Jack Corbett (9/18/2015)
Okay, I'm going to give the instructor the benefit of the doubt. Maybe lesson 1 is cursor and lesson 2 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)

September 18, 2015 at 7:26 pm

#1827868
RE: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

Of course, Gene was also smart enough to not ask the engineers to make the LEM out of even the best of all tin cans. 🙂
--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)

September 18, 2015 at 5:11 pm

#1827864
RE: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

Grant Fritchey (9/17/2015)
This is just a ridiculous and extended troll. Unsubscribing. There's no point to any of this.
Come, come now man. You don't see the joy of maintaining 500+...
--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)

September 18, 2015 at 1:13 pm

#1827829
RE: The Counter Offer - Part 1

Andy Warren (9/17/2015)
Jeff, I'll disagree on it being stupid. We all get to decide what's right for each of us of course, no arguing that. In my experience it's fairly...
--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)

September 18, 2015 at 10:39 am

#1827794
RE: The Counter Offer - Part 1

Rod at work (9/17/2015)
Jeff Moden (9/16/2015)
I've always thought this whole process was a bit, um... well... stupid. If you're not happy with your job, etc, yadda, yadda, then 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)

September 18, 2015 at 10:33 am

#1827792

Viewing 15 posts - 19,546 through 19,560 (of 59,072 total)