Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,186 through 22,200 (of 59,102 total)

RE: 15 Quick Short Interview Questions Useful When Hiring SQL Developers

ScottPletcher (12/25/2014)
Geoff A (3/3/2013)
Jeff Moden (2/28/2013)
Shifting gears a bit, I’m glad that these are essay-style questions so that I could write in what I believe is a more correct answer...
--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)

December 25, 2014 at 11:13 am

#1766416
RE: 15 Quick Short Interview Questions Useful When Hiring SQL Developers

wkampas (12/25/2014)
Nice list of questions. Thanks.
Could someone provide an example from question 10 where "HAVING without GROUP BY" works.
The SQL doc says you can do this and it behaves...
--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)

December 25, 2014 at 10:34 am

#1766414
RE: Date Table

CELKO (12/25/2014)
Why not move the data from the spreadsheets you already have to a table? Where is the ISO week-date column?
Hi Joe,
I think that's what the op is trying 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)

December 25, 2014 at 10:31 am

#1766413
RE: Starting from Scratch - How long to get the gist of SQL Server?

I'll just add what it says in my signature line about a paradigm shift but you have the added advantage of never having thought in rows before. Think 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)

December 24, 2014 at 9:07 pm

#1766390
RE: Are the posted questions getting worse?

Lynn Pettis (12/24/2014)
... Mark one off, 65 days on the calendar to go. 65 days on the calendar to go, 65 days to go, ...
Stay safe, Lynn. And Merry...
--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)

December 24, 2014 at 8:56 pm

#1766389
RE: Merry Christmas 2014 and Happy Holidays

Wow! I haven't heard that many buzzwords since the last marketing meeting with MS. 😛
Merry Christmas to you and yours, Steve.
And a special thanks to all the folks that...
--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)

December 24, 2014 at 8:50 pm

#1766388
RE: Restoring a replicated database to the same server for testing, with another name

Ah, be careful now. If you have "pass through" views or synonyms to other databases or calls to other production linked servers, the tests that you run on your...
--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)

December 24, 2014 at 3:00 pm

#1766382
RE: is bulk logged recovery model support point in time recovery

Shafat Husain (12/23/2014)
Hi,
Point in time recovery is only supported in Full recovery model. So NO, Bulk logged recovery model does not support point in time recovery.
http://msdn.microsoft.com/en-IN/library/ms189275.aspx
Hope it helps...!!!
Ah... you read...
--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)

December 24, 2014 at 2:46 pm

#1766380
RE: I'm arguing with BCP

BenWard (12/22/2014)
OK I seem to have identified the source of this issue...
My destination table has more rows than my flat file and they are in a different order.
I thought bcp...
--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)

December 24, 2014 at 2:26 pm

#1766379
RE: Date Table

I don't you if you still need it or want it but I went whole hog on this one and created a function that provides a whole lot of Fiscal-related...
--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)

December 24, 2014 at 2:18 pm

#1766377
RE: Are the posted questions getting worse?

GilaMonster (12/23/2014)
http://www.sqlservercentral.com/Forums/Topic1646163-391-1.aspx
I'll just be in the corner sobbing softly...
Heh.... say "Hi" to the dust bunnies for me. 😀 Beer popsicles are in order after that one. :w00t:
--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)

December 23, 2014 at 2:29 pm

#1766269
RE: How to format unformated phone numbers Please...,

sqldriver (12/22/2014)
Jeff Moden (12/22/2014)
ScottPletcher (12/22/2014)
Jeff Moden (12/22/2014)
CELKO (12/22/2014)
Pull all the punctuation out and pad with digits as needed until you get the Standard International phone number. Let the presentation layers...
--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)

December 22, 2014 at 7:21 pm

#1766099
RE: Replacing string values

Heh... a better way to do it would be to get that nasty ol' denormalized junk known as XML out of your database and replace it with proper columns 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)

December 22, 2014 at 6:12 pm

#1766098
RE: When Creating Tables, Is a RecID Column necessary?

Whenever this topic comes up, I say "It Depends" and refer folks to the following video. It might change your mind about the use of IDENTITY columns as 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)

December 22, 2014 at 6:06 pm

#1766097
RE: How to format unformated phone numbers Please...,

ScottPletcher (12/22/2014)
Jeff Moden (12/22/2014)
CELKO (12/22/2014)
Pull all the punctuation out and pad with digits as needed until you get the Standard International phone number. Let the presentation layers handle presentations.
http://en.wikipedia.org/wiki/E.123
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)

December 22, 2014 at 5:11 pm

#1766092

Viewing 15 posts - 22,186 through 22,200 (of 59,102 total)