Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,656 through 20,670 (of 59,098 total)

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
RE: Finding out Total Disk Space in TSQL

Steve Jones - SSC Editor (1/15/2015)
JimAtWork (2/3/2014)
I have the same challenge and I have to query thousands of servers many of which do not allow the use of OA_ 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)

May 20, 2015 at 10:29 am

#1799377
RE: Sql Job to send results

ramana3327 (5/14/2015)
Hi,
I want to run this below query on scheduled basis and send the result to me through Sql job. It is running but not sending any result
How to set...
--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 19, 2015 at 7:06 pm

#1799211
RE: How to create numerous directories on a server using data from sql table

GF (5/19/2015)
Update on this adventure.
I have created all the folders I need to based on a list I generated from a SQL table.
FOR /F %i in (E:\documents\folderlist.txt) do md "%i"
Now...
--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 19, 2015 at 6:52 pm

#1799209
RE: Unused,duplicate indexes

tcronin 95651 (5/19/2015)
i would look at ozar's index routine and use that.
Link?
--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 19, 2015 at 6:04 pm

#1799205

Viewing 15 posts - 20,656 through 20,670 (of 59,098 total)