Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,186 through 19,200 (of 59,072 total)

RE: Pipe Delimmeted Data To Shred Into A Table

Ok... first things first. Part of the reason why you've gotten no actual code to help you for the split portion of this problem is because you haven't posted...
--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)

November 13, 2015 at 6:50 pm

#1839773
RE: Are the posted questions getting worse?

Ah... the "blood in my eyes" caused me to misread Jason's post. I thought he meant something else.
Yes. It was a hot post and I didn't really mean...
--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)

November 13, 2015 at 6:26 pm

#1839771
RE: Are the posted questions getting worse?

jasona.work (11/13/2015)
Whhoooo!!!
*I* nearly got singed by this reply: http://www.sqlservercentral.com/Forums/FindPost1736339.aspx
Not that I blame Jeff, he's probably had the "joy" of interviewing people like the OP...
I'm curious... How did you almost get...
--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)

November 13, 2015 at 5:40 pm

#1839769
RE: 4 Queries Required Very Urgent

Ed Wagner (11/13/2015)
Jeff Moden (11/13/2015)
This is actually pretty sickening. Why do you even bother going to school if you're not going to even try. You should drop 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)

November 13, 2015 at 4:13 pm

#1839765
RE: 4 Queries Required Very Urgent

Alright, nexus2vijay... Putting the teaching hat back on, let's work on the first problem...
Here's the problem as you listed it in the original post on this thread...
1. List the top...
--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)

November 13, 2015 at 2:18 pm

#1839755
RE: 4 Queries Required Very Urgent

nexus2vijay (11/12/2015)
Using the attached schema diagram below, develop TSQL script for each question.
Use JOIN wherever applicable (do not use EXISTS!).
Do NOT use variable or temporary table.
4 Tables are below 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)

November 13, 2015 at 8:11 am

#1839620
RE: Pipe Delimmeted Data To Shred Into A Table

xxxy2k (11/13/2015)
Final peice will be something like this
select
dbo.GetDomain(t.test,'|',0) as col2,
dbo.GetDomain(t.test,'|',1) as col3,
dbo.GetDomain(t.test,'|',2) as col4
from...
--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)

November 13, 2015 at 6:27 am

#1839594
RE: What's a Code Smell?

Phil Factor (11/12/2015)
@jeff Moden
It was a difficult booklet to write because I was merely trying to record those things that were considered by people cleverer and more experienced than 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)

November 12, 2015 at 12:54 pm

#1839492
RE: Refactoring SQL Server code

Ed Elliott (11/11/2015)
Martin Fowler is pretty clear that refactoring means looking for and cleaning substandard code for example:
http://martinfowler.com/articles/workflowsOfRefactoring/#opp-flow
The thing is, who determines what "substandard" actually is? Based on 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)

November 11, 2015 at 7:52 pm

#1839256
RE: Refactoring SQL Server code

I love refactoring because we can indeed get rid of a huge amount of technical debt, improve performance and scalability of the code, simplify by removed gobs of RBAR, 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)

November 11, 2015 at 3:10 pm

#1839232
RE: Question for All DBAs (What can I learn to enahnce my career?)

Chitown (11/11/2015)
Thanks all. I think I will start with learning TSQL since I am just a little weak in that department. 🙂
Cool. That's great. I have to tell...
--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)

November 11, 2015 at 8:44 am

#1839137
RE: Question for All DBAs (What can I learn to enahnce my career?)

Steve Jones - SSC Editor (11/10/2015)
Jeff Moden (11/6/2015)
My recommendation would be to learn the database engine inside and out along with everything you can get your hands on for T-SQL...
--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)

November 10, 2015 at 9:19 pm

#1839023
RE: Exporting column using xp_cmdshell to plain text file error

SoHelpMeCodd (11/8/2015)
You are way too gentle Jeff. I struck out my comment - my apologies:)
I've seen your posts. You've got a good spirit and a great heart not 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)

November 10, 2015 at 8:56 pm

#1839022
RE: Exporting column using xp_cmdshell to plain text file error

Nicegirl13 (11/10/2015)
Thanks for the replies, i have sorted out the issue. It was rights problems. I created a Sub folder i C:\ and exportet there, magic happened and it worked...
--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)

November 10, 2015 at 8:34 pm

#1839021
RE: What's a Code Smell?

Phil Factor (11/10/2015)
@TomThomson
Is this the SQL Code Smells ebook you're referring to? I wasn't sure, since there were 120 SQL Code Smells itemised, not 27. If it is mine, I'll...
--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)

November 10, 2015 at 8:21 pm

#1839020

Viewing 15 posts - 19,186 through 19,200 (of 59,072 total)