Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,576 through 19,590 (of 59,098 total)

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
RE: Painful datetime conversion

Sean Lange (9/17/2015)
The table is small right now because the system is not yet in production but it isn't likely to get too huge. Maybe 100 or so new rows...
--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 17, 2015 at 8:29 am

#1827436
RE: Painful datetime conversion

Man o' man... guess I need to find out what the hell's the matter with my Dev box at work. Here are the run results of Lynn's code from...
--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 17, 2015 at 8:14 am

#1827430
RE: Painful datetime conversion

Sean Lange (9/16/2015)
drew.allen (9/16/2015)
Try the FORMAT function. It was added in SQL 2012.
SELECT FORMAT(vhrgdt, '0000-00-00') + ' ' + FORMAT(vhrgtm, '00:00:00.000'), *
FROM #Something s
Drew
Thanks Drew. I don't use FORMAT very...
--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 16, 2015 at 10:57 pm

#1827295
RE: The Counter Offer - Part 1

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 should be talking about it...
--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 16, 2015 at 10:45 pm

#1827292

Viewing 15 posts - 19,576 through 19,590 (of 59,098 total)