Jeff Moden

Forum Replies Created

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

RE: DBA career advice

RonKyle (6/11/2016)
But, if you got caught flat footed and had to submit to being interviewed in the next 10 minutes, would you fail the interview just because you didn't have...
--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 12, 2016 at 11:29 am

#1884540
RE: Commonly used DMVS in sql server

naveenareddy.dba (6/11/2016)
hi everyone,
what are the most commonly used DMV's
in sqlserver as a DBA.
Why do you ask? Knowing that might help us answer better.
And, you've presumed to include...
--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 11, 2016 at 1:23 pm

#1884513
RE: DBA career advice

patrickmcginnis59 10839 (6/10/2016)
RonKyle (6/9/2016)
Besides, if you have to prepare for an interview, then you're not ready for the job.
Disagree. It never hurts to review the basics even though 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 10, 2016 at 9:24 pm

#1884495
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

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