Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,386 through 20,400 (of 59,098 total)

RE: The Scientific Method: a call to action

With that in mind and for those people that exclaim, "OK. You sold me. Where the hell do you get a million rows of test data?", the answer...
--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)

June 12, 2015 at 2:33 pm

#1805245
RE: OPENROWSET problem

sgmunson (6/12/2015)
Why don't they just use SSIS ? Even the import/export wizard in SSMS might be a better choice. I suspect a registry permissions issue, but...
--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)

June 12, 2015 at 2:27 pm

#1805242
RE: OPENROWSET problem

n.heyen (6/12/2015)
I have a test server (TEST1) running SQL 2012 and Windows 2012R2. One of the developers wants to use OPENROWSET to read in data from an Excel 2010 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)

June 12, 2015 at 2:26 pm

#1805238
RE: Sql Server Core vs Full blown version of SQL Server

I can't speak for anyone else and I'm sure that it will rub some folks' sensibilities the wrong way but I do install the full monty on my servers 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)

June 12, 2015 at 10:44 am

#1805147
RE: Index rebuild slow on 2014

Outstanding feedback, Michael. Thanks for taking the time to post 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)

June 12, 2015 at 9:43 am

#1805101
RE: How to find the date created and date modified values of all files in a location.

Do the files actually have a date and time in the file name? That would make life pretty easy. If so, please post the "general" format of 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)

June 12, 2015 at 9:39 am

#1805099
RE: The Scientific Method: a call to action

Please folks... there's a time and a place for everything. I realize that it's an important subject but let's not turn this wonderful thread into a "global warming thread".
--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)

June 12, 2015 at 8:41 am

#1805075
RE: How to find the date created and date modified values of all files in a location.

SQL-DBA-01 (6/12/2015)
Thanks.
Anyway you can help me getting the script in xp_cmdshell?
Were the two methods of mine that you found on a couple of the other posts too slow (and I...
--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)

June 12, 2015 at 8:23 am

#1805065
RE: Finding / getting in touch with recruiters?

jasona.work (6/11/2015)
For the most part though, staying in the Metro Detroit / suburbs area would be preferred.
That's where all the all the recruiters I know are at... between downtown 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)

June 12, 2015 at 8:19 am

#1805061
RE: Finding / getting in touch with recruiters?

Eric M Russell (6/12/2015)
Also build up a cash emergency fund enough to cover three months of basic living expenses. You may end up needing that to pay bills or at...
--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)

June 12, 2015 at 8:17 am

#1805059
RE: Need better query to capture job runs on sql servers

Barkingdog (6/12/2015)
Jeff,
Thank you for the perspective. I like it and will remove the WHERE clause as you suggested.
BD
We'll need to do a bit more than just removing the WHERE clause....
--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)

June 12, 2015 at 1:09 am

#1804889
RE: Finding / getting in touch with recruiters?

jasona.work (6/11/2015)
Jeff Moden (6/9/2015)
On that note, give me some idea of where you'd actually like to work, area wise.
Jeff, realistically, I'd probably (for the right price) go as far as...
--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)

June 11, 2015 at 10:22 pm

#1804877
RE: Need better query to capture job runs on sql servers

Barkingdog (6/11/2015)
Jeff,
You are absolutely right. My query will be used to create a report for the Operators group to check the daily sql runs jobs. I too have some jobs...
--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)

June 11, 2015 at 10:18 pm

#1804876
RE: Just want to make sure I have my facts straight about autogrowth.

Steve Jones - SSC Editor (6/11/2015)
Agree with the above. You might also keep a few placeholders around: https://voiceofthedba.wordpress.com/2014/11/24/placeholders-for-emergencies/
You just have to remember to be a bit careful with what get's...
--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)

June 11, 2015 at 10:10 pm

#1804874
RE: Parsing large varbinary fields

Ah. wait a minute. I've apparently gotten two different threads mixed up. The individual internal "rows" in your large binary are delimited by CHAR(10), correct?
--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)

June 11, 2015 at 7:04 pm

#1804869

Viewing 15 posts - 20,386 through 20,400 (of 59,098 total)