Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,491 through 17,505 (of 59,069 total)

RE: Interview Questions

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 just that for...
--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 10, 2016 at 9:20 pm

#1884494
RE: Are the posted questions getting worse?

Phil Parkin (6/8/2016)
And why not ask them to make it idempotent while you're at it:
IF COL_LENGTH('dbo.mytable', 'col1') IS NULL
BEGIN
ALTER TABLE dbo.mytable
...
--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 10, 2016 at 1:15 pm

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

drew.allen (6/10/2016)
Jeff Moden (6/9/2016)
drew.allen (6/9/2016)
Jeff Moden (6/6/2016)
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 <...
--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 10, 2016 at 10:30 am

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

DennisPost (6/10/2016)
@jeff,
@jeff, I've been reading up on parameter sniffing, but haven't found anything relating to scalar UDFs that do not access data. Have you written anything about it or 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 10, 2016 at 8:19 am

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

drew.allen (6/9/2016)
Jeff Moden (6/6/2016)
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...
--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 9, 2016 at 9:51 pm

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

DennisPost (6/9/2016)
Hugo Kornelis does a good write up of the overhead involved when calling an UDF and the bad decision taken by the query optimizer. A few big SQL names...
--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 9, 2016 at 8:40 pm

#1884272
RE: Interview Questions

Eric M Russell (6/9/2016)
...even a very experienced T-SQL programmer routinely does string manipulation...
I guess that's the primary difference between what you and I think. We do a ton of...
--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 9, 2016 at 8:34 pm

#1884271
RE: Primary Key Violation when Loading Table

Welsh Corgi (6/8/2016)
I execute the following query:
SELECT DISTINCT ID, Name, Abbreviation, CountryID
FROM Postal_StateProvince
WHERE CountryID = 2
It returns the following values:
IDNameAbbreviationCountryID
52AlbertaAB2
53British ColumbiaBC2
54ManitobaMB2
55New BrunswickNB2
56NewfoundlandNL2
57Northwest TerritoriesNT2
58Nova ScotiaNS2
59NunavutNU2
60OntarioON2
61Prince Edward IslandPE2
62QuebecQC2
63SaskatchewanSK2
64Yukon TerritoryYT2
It return the following...
--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 8, 2016 at 3:49 pm

#1884034
RE: The Big Lie

David O (6/8/2016)
P.S. if Steve Jones read this and wants me to turn this into a guest editorial private message me.
Although I think Steve would reply with a resounding...
--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 8, 2016 at 3:44 pm

#1884032
RE: Querying single table suddenly running slowly

Erik de Jonge (6/8/2016)
We ran into an issue with our ERP's database last night where out of nowhere any of our queries that were hitting a specific table in 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 8, 2016 at 3:40 pm

#1884031
RE: Interview Questions Help

prafuljemail (6/7/2016)
check interview questions on forums of winmilestone.com / http://www.winmilestone.com/Topic?Interview
You want way too much information on the signup sheet. It's not worth 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 8, 2016 at 3:24 pm

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

Ray K (6/8/2016)
Ray K (6/7/2016)
Michael L John (6/7/2016)
Sounds like quite a few folks on this thread need to submit sessions for the Wanna be a DBA track at the Pittsburgh...
--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 8, 2016 at 10:27 am

#1883931
RE: Index fragmentation and SSDs

Mick Opalak (6/8/2016)
Unfortunately we are seeing the exact opposite. We accidentally altered our index maintenance job so since late March we've only been defragging about 20% of our indices....
--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 8, 2016 at 10:23 am

#1883930
RE: Index fragmentation and SSDs

Brent Ozar put on several presentations talking about how much time is wasted by doing defrags. Yeah... I was highly skeptical and thought he was drinking bong water with...
--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 8, 2016 at 9:06 am

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

Ray K (6/7/2016)
Michael L John (6/7/2016)
Sounds like quite a few folks on this thread need to submit sessions for the Wanna be a DBA track at the Pittsburgh SQL Saturday.
I...
--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 8, 2016 at 12:11 am

#1883794

Viewing 15 posts - 17,491 through 17,505 (of 59,069 total)