Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,551 through 17,565 (of 59,102 total)

RE: Interview Questions

Eric M Russell (6/7/2016)
So I typically bypass the Programming 101 stuff and zoom in on what I really expect from senior level database developer.
I do expect Senior level Database...
--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 7, 2016 at 9:03 am

#1883628
RE: Are the posted questions getting worse?

Luis Cazares (6/7/2016)
Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.
It was almost as sarcastic as using LMGTFY but I'm absolutely with 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 7, 2016 at 8:59 am

#1883622
RE: Interview Questions

vs.satheesh (6/7/2016)
Hi
Today i am facing one interview Questions
I have following folder structure(like string path)
1) c:\Programmefiles\Dicument\file1.txt
2) c:\Programmefiles\Dicument\Subdocument\file1.txt
3) c:\Programmefiles\Dicument\Image\file1.txt
4) c:\Programmefiles\Dicument\Text\file1.txt
I want to following output (I want last folder name)
1)...
--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 7, 2016 at 8:49 am

#1883614
RE: Interview Questions

Luis Cazares (6/7/2016)
Try this:
SELECT sys.fn_get_folder(path, 1)
Absolutely the correct answer! 😛 Well, except for the Hungarian notation used. :hehe:
--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 7, 2016 at 8:46 am

#1883609
RE: Interview Questions

Eric M Russell (6/7/2016)
They're asking the wrong type of questions for a job interview.
I think it's a great question. It shows whether or not you actually know much about...
--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 7, 2016 at 8:45 am

#1883608
RE: Potential presentation idea: SQL Server for absolute beginners

Understood. Ed and I go to Cleveland and Pittsburgh every year and neither of us are sponsored. Everything comes out of our own pocket. Definitely worth...
--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 7, 2016 at 8:30 am

#1883599
RE: Alternate Way to Write query: ISNULL function causing issues

And notice that Drew did NOT suggest using 9999-12-31. That's because the classic method of isolating date ranges requires a "AND SomeDTColumn < @EndDate +1" and all similar variations....
--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 6, 2016 at 9:07 pm

#1883501
RE: Potential presentation idea: SQL Server for absolute beginners

Ray K (6/6/2016)
Michael L John (6/6/2016)
For the Pittsburgh SQL Saturday, one of the most popular tracks is the "So you wanna be a DBA"?
We geared this toward students(we host it...
--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 6, 2016 at 9:02 pm

#1883498
RE: Potential presentation idea: SQL Server for absolute beginners

Ray K (6/3/2016)
How many people who know absolutely nothing about SQL Server ...
Ah... easy answer for me. About 90% of the people that I've interviewed for Sr. DBA or...
--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 6, 2016 at 8:51 pm

#1883497
RE: SQL server does not use tempdb

Duplicate post. No answers here, please. Keep all the answers together at the following post...
http://www.sqlservercentral.com/Forums/Topic1792569-146-1.aspx
Thanks, folks.
--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 6, 2016 at 8:43 pm

#1883496
RE: UDF slow even when used as a persisted computed column

DennisPost (6/6/2016)
Thinking this to be the cause, we changed the table to make these 2 columns persisted. Straight away we had better performance, 15 minutes later, the performance was terrible...
--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 6, 2016 at 8:38 pm

#1883495
RE: How to send email from procedure depend on value

asita (6/6/2016)
Hello Good Morning,
I have the below procedure if it returns 0 no need to send any email , if it is more than 0 then we need to send...
--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 6, 2016 at 8:31 pm

#1883493
RE: SQL server does not use tempdb

java56p 72136 (6/6/2016)
I have a DB with some tables more than 7 millions record. However any query ,even with join , from those table are slow and the they 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)

June 6, 2016 at 8:24 pm

#1883490
RE: DBCC CHECKDB JOB STOPPED EXECUTION

coolchaitu (6/5/2016)
I thoroughly looked at Event logs,SQL Logs and did not find anything. Is the problem with the PowerShell script?
If nothing else, that would be the next place to look....
--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 5, 2016 at 7:44 pm

#1883294
RE: What are the advantage of using cross apply over union all?

dale_berta (5/25/2016)
It's not a question of there being an advantage of one over the other, since they do different things.
Careful now. What you say is true except when...
--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 4, 2016 at 3:30 pm

#1883265

Viewing 15 posts - 17,551 through 17,565 (of 59,102 total)