Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,746 through 20,760 (of 59,098 total)

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
RE: Here are some SQL Server Interview Questions

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. 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)

May 14, 2015 at 1:14 pm

#1797995
RE: Documenting with Tests

PHYData DBA (5/14/2015)
Code Comments <> Documentation
Just in case that was not clear to everyone already.
I have to strongly disagree with that if it's done correctly. The next question would...
--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 12:08 pm

#1797960
RE: Run SQL query to retrieve 650 unique records

If this is something that needs to be done more than once or automated, post back and we'll turn it into a stored procedure 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)

May 14, 2015 at 12:02 pm

#1797956
RE: Fast Insert

As always, "It Depends". For example, no one has mentioned using the high performance "SELECT/INTO" method, which works wonders even if minimal logging isn't possible due to the current...
--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 11:57 am

#1797952

Viewing 15 posts - 20,746 through 20,760 (of 59,098 total)