Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,716 through 20,730 (of 59,072 total)

RE: Here are some SQL Server Interview Questions

TomThomson (5/15/2015)
David Webb-CDS (5/15/2015)
Your customer comes to you and says the query he has run daily for the last two years is suddenly taking hours instead of seconds. 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)

May 15, 2015 at 5:59 pm

#1798380
RE: Here are some SQL Server Interview Questions

Stephanie Giovannini (5/15/2015)
Real interview question that I asked during a tech screen for an entry-level programmer position:
Q: Where do you see yourself in 5 years?
My answer to the interviewer: ...
--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 15, 2015 at 12:50 pm

#1798306
RE: Here are some SQL Server Interview Questions

pietlinden (5/14/2015)
Best milkshakes ever. I don't like that boss very much.
That and a grilled cheese sandwich. I want to see his lips swell up to match the size...
--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 14, 2015 at 8:22 pm

#1798062
RE: Here are some SQL Server Interview Questions

This one is actually true.
Me, the interviewer: As the Lead Developer on this project, we're very interested in someone that understands and can easily do conversions between various numbering...
--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 14, 2015 at 8:09 pm

#1798061
RE: Here are some SQL Server Interview Questions

Interviewer: What makes you think you're a good <<any job title here>>?
Candidate: I don't. It's just that everyone else sucks so bad that I end up looking good....
--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 14, 2015 at 8:05 pm

#1798060
RE: Here are some SQL Server Interview Questions

TomThomson (5/14/2015)
Luis Cazares (5/14/2015)
You receive a late call during the night to inform you that the server is down and must be working correctly before everyone arrives in the morning....
--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 14, 2015 at 7:59 pm

#1798059
RE: Here are some SQL Server Interview Questions

Alvin Ramard (5/14/2015)
Here's an interview question:
Name 10 of the parameters for DBCC TimeWarp. 😛
I'd seriously consider asking a DBCC TimeWarp question at an interview, just to see how 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)

May 14, 2015 at 7:54 pm

#1798058
RE: Here are some SQL Server Interview Questions

SQLBill (5/14/2015)
You are quite skilled as a DBA/Developer/whatever and that is what the job requirement stated. However, we really need someone that can maintain computers. How do 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)

May 14, 2015 at 7:51 pm

#1798057
RE: Here are some SQL Server Interview Questions

Eric M Russell (5/14/2015)
Define "working correctly".
Easy... it doesn't automatically call me at 3 in the morning even if it broke. 😛
--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 14, 2015 at 7:49 pm

#1798056
RE: Dynamic PIVOT CLR

Nothing against the CLR method but since it just builds dynamic SQL and you have to provide almost everything anyway, why not just build a function in T-SQL that builds...
--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 14, 2015 at 7:45 pm

#1798055
RE: interview questions

CodeGuys (5/14/2015)
Please read my website for Interview Questions and Answers,
1. SQL Interview Questions and Answers
2. Basics Interview Questions and Answers[/url]
3. MSSQL Interview Questions and Answers[/url]
4. Oracle Interview Questions and Answers[/url]
5....
--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 14, 2015 at 7:16 pm

#1798050
RE: Percolating Data

Just an FYI... Jason's is faster because it quickly eliminates the blank "fields" but it also means that it will NOT return any row where all the ADDRx columns are...
--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 14, 2015 at 6:06 pm

#1798044
RE: Is SSAS a bit flaky?

Heh... so "Yes"... a bit flaky. 😛
They also had some problems with 2012. If you don't have SP2 installed and CU5 installed after that (came out in March), 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)

May 14, 2015 at 6:00 pm

#1798043
RE: Help needed to write SQL statement

mw112009 (5/14/2015)
no did not work.. Since this was an link to an Oracle database.
However I found it while googling...
Select top 100 * FROM CDRQ_Moderage..[CDR].[EEG_TEXT_T]
This works! 🙂 GOT 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 14, 2015 at 1:27 pm

#1797997
RE: Bulk Delete & Insert

Ratheesh.K.Nair (5/13/2015)
Hi Experts,
We have a scenario in which application scheduler inserts processed data (Approx 5million) into a table(ABC). This table is truncated before inserting the data. The scheduler takes...
--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 14, 2015 at 1:22 pm

#1797996

Viewing 15 posts - 20,716 through 20,730 (of 59,072 total)