Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,521 through 17,535 (of 59,069 total)

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
RE: Query calculation over a partition

leehbi (6/2/2016)
I had a the best results from this query. Works really well over the huge table. Thanks 🙂
Which query is "this" query? A lot of them...
--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:07 pm

#1883264
RE: Can is stop DBCC CLEANTABLE

jude.pieries (6/3/2016)
HI
used a batch is of 10000 ,
So if i understand it correctly, if i stop the script it would rollback up to a max of 10000 ?...
--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 11:26 am

#1883260
RE: Service account setup for SQL Services

I agree. It's not only a security risk (think payload from each server), it would also prevent you from customizing what each server can see based on it's functionality....
--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 3, 2016 at 10:43 pm

#1883244

Viewing 15 posts - 17,521 through 17,535 (of 59,069 total)