Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,626 through 20,640 (of 59,072 total)

RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Excellent. I'll try to take a look at this over the weekend, unless they hit me with the next ton-o-bricks at work.
--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)

May 22, 2015 at 12:40 pm

#1800128
RE: Interview Questions

Michael L John (5/22/2015)
Jeff Moden (5/22/2015)As for "standard technical questions", they are a must. The difference is that you don't just sit there and listen to the applicant...
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)

May 22, 2015 at 12:38 pm

#1800126
RE: Interview Questions

jasona.work (5/22/2015)
Jeff Moden (6/6/2014)
thomashohner (6/6/2014)
kimberly_lehman (6/6/2014)
Ask "Using T-SQL, how do you get the current date and time"?
So would you consider this a valid answer? "I think it's CURRENT TIMESTAMP 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)

May 22, 2015 at 9:21 am

#1800058
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

At this point, I'm going to suggest that you post your testdata generators and your test harness.
--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)

May 22, 2015 at 9:19 am

#1800055
RE: Interview Questions

xsevensinzx (5/22/2015)
rsgardner2 (5/21/2015)
I really wish employers would get smart and try this instead of gathering lists of 'technical questions' from the internet.
Paraphrasing Google here: It's not about finding a master...
--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)

May 22, 2015 at 8:46 am

#1800039
RE: Interview Questions

rsgardner2 (5/21/2015)
I have had dozens of interviews in the past few years - am currently working a 1-year contract, so must have done something right.
IMHO the idea of 'asking technical...
--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)

May 22, 2015 at 8:39 am

#1800034
RE: SQL Server 2012 - High Memory Usage

Grant Fritchey (5/18/2015)
audiocool (5/18/2015)
After I adjust the maximum memory as mentioned as above which is 24GB out of my actual machine 32GB, it stay peak at 94 to 95%.
I'm 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)

May 21, 2015 at 9:32 pm

#1799881
RE: Populating SQL tables with entries from Windows folders

lenrigby (5/21/2015)
Thanks Jeff
I had a feeling that you may have a non-cursor based solution! I've set it running and will feedback.
Many thanks for your help.
IF it turns out to...
--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)

May 21, 2015 at 7:43 am

#1799665
RE: Populating SQL tables with entries from Windows folders

lenrigby (5/18/2015)
Hi
I have 14 Windows folders containing a mix of Word and PDF documents. Each folder contains up to 500,000 files and these documents are the source for a document...
--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)

May 20, 2015 at 9:27 pm

#1799533
RE: Help fro interview question

meerack11 (5/20/2015)
Hello...
I am currently looking for job as sql developer company gives sql query to solve so can you help me where I can find real time scenario...
--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)

May 20, 2015 at 6:50 pm

#1799520
RE: SQL Server 2012 - High Memory Usage

audiocool (5/17/2015)
Hi Shawn,
- OS and SQL Server 2012 are 64 bits
- The server equipped with SQL Server 2012 and McAfee Virus Scan Enterprise v8.8
- I monitor through...
--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)

May 20, 2015 at 1:11 pm

#1799449
RE: Unused,duplicate indexes

tcronin 95651 (5/20/2015)
http://www.brentozar.com
he has a whole group of great tools
Heh... yep... I know that. It's just that when you mention something that's very specific, you should include a 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)

May 20, 2015 at 11:21 am

#1799398
RE: Sql Job to send results

ramana3327 (5/19/2015)
The purpose of this job is to comparison of fragmentation before & after the the maintenance job. I am comparing two excels manually.
Some how I don't want to...
--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)

May 20, 2015 at 11:18 am

#1799395
RE: Are the posted questions getting worse?

Grant Fritchey (5/20/2015)
Ed Wagner (5/20/2015)
Brandie Tarvin (5/20/2015)
Grant Fritchey (5/20/2015)
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!
Dare we ask?
How about a link? You're normally so patient that it ought to be good. 😛
We've been beating this person...
--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)

May 20, 2015 at 11:11 am

#1799391
RE: Are the posted questions getting worse?

Ed Wagner (5/20/2015)
Grant Fritchey (5/20/2015)
Again...
AAARRARARRGGGGHHHH!!!
Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a random query hint....
--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)

May 20, 2015 at 11:10 am

#1799390

Viewing 15 posts - 20,626 through 20,640 (of 59,072 total)