Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,461 through 17,475 (of 59,067 total)

RE: Interview Questions

An interview is the one place where volunteering information can do nothing but good... if you know what you're talking about. When someone asks a simple question about how...
--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 15, 2016 at 8:39 am

#1885174
RE: Interview Questions

GSquared (6/15/2016)
Jeff Moden (6/14/2016)
GSquared (6/14/2016)
Jeff Moden (6/10/2016)
Eric M Russell (6/10/2016)
Eric M Russell (6/7/2016)
They're asking the wrong type of questions for a job interview.
I'm not saying that string manipulation is a...
--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 15, 2016 at 8:20 am

#1885166
RE: Interview Questions

ScottPletcher (6/14/2016)
My advanced knowledge, "tricky" q is:
In autocommit mode, when can an UPDATE statement partially complete, some UPDATEs made, some not, where SQL does not roll it back?
Edit:...
--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 14, 2016 at 10:58 pm

#1885076
RE: Interview Questions

Eric M Russell (6/14/2016)
You'll rarely ever be asked pop quiz style questions like "What is a clustered index?" or "How do you get the current date and time?", unless...
--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 14, 2016 at 10:44 pm

#1885075
RE: Interview Questions

GSquared (6/14/2016)
Jeff Moden (6/10/2016)
Eric M Russell (6/10/2016)
Eric M Russell (6/7/2016)
They're asking the wrong type of questions for a job interview.
I'm not saying that string manipulation is a bad question. It'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 14, 2016 at 10:20 pm

#1885074
RE: Strange Performance Issue

haridbakorrapati (6/14/2016)
sorry not able to get answers...
plz.. ]] mantion whats is ans. and what is qus. guys
There's not enough information to help. It could be anything and without actual...
--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 14, 2016 at 6:18 am

#1884857
RE: Interview Questions

Sergiy (6/12/2016)
Man, I can only say - you're dealing with some seriously screwed people. 🙂
Fakers and Posers and Shammers, Oh my! 😀
Of course, I cannot know how you define 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 14, 2016 at 5:58 am

#1884852
RE: FLAG

Manic Star (6/9/2016)
patla4u (6/9/2016)
SELECT TOP 1000 [SubjectID]
,[Phase_ID]
FROM [dbo].[TEST]
SubjectIDPhase_ID
1 2
2 ...
--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 13, 2016 at 9:12 pm

#1884807
RE: Copy Database Backup from One Server to Another

Do any of the backups contain any PII or other sensitive information that probably shouldn't leave the production server?
--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 13, 2016 at 6:10 pm

#1884800
RE: Restoring a database (without effecting original) - to test the retore process...

jellybean (6/13/2016)
Hi,
Hope this is the right forum. I using SQL Server 2014 and want to test the "restore" process is working correctly. What I wan to do is restore an...
--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 13, 2016 at 5:10 pm

#1884796
RE: QotD need an out

djj (6/13/2016)
Is there a way to see the discussion of a QotD without answering? There are questions that I have no idea about but would like to see 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 13, 2016 at 4:51 pm

#1884795
RE: Generate dynamic multilevel XML file from SQL Server table

Since I'm interested in an answer to this, I'll "bump" the post for 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)

June 13, 2016 at 4:50 pm

#1884794
RE: import from CSV/EXCEL and insert/update into SQL which is backend for payroll software

Learner44 (6/12/2016)
I get in EXCEL sheet. I convert them into CSV which gives me bit flexibility to run SSIS package.
Could you attach a sample of the file using the example...
--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 13, 2016 at 4:47 pm

#1884793
RE: CTE Replacement for Bi-Directional Recursion

michael.french 172 (6/13/2016)
Phil,
I totally agree with points 3 & 4. With points 1 & 5, they are crucial to handle the recursion efficiently as coded. As for point 2, since...
--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 13, 2016 at 4:40 pm

#1884792
RE: Function to get Number from word

It will ultimately be a whole lot easier and a whole lot less expensive both upfront and over time if you simply purchased some "CASS Certification" software, which will do...
--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 13, 2016 at 4:28 pm

#1884790

Viewing 15 posts - 17,461 through 17,475 (of 59,067 total)