Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,216 through 19,230 (of 59,098 total)

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
RE: Do You Have Scary Code?

Gary Varga (11/10/2015)
Jeff Moden (11/10/2015)
Gary Varga (11/10/2015)
I joined a project part way though and got ridiculed the week when I added the first unit test project to the solution. 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)

November 10, 2015 at 6:52 pm

#1839018
RE: Do You Have Scary Code?

Eric M Russell (11/10/2015)
A foolish man builds his business on top of a million lines of source code.
Hmmm.... wonder how much code Google or Ebay has.
--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 6:46 pm

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

MadAdmin (11/10/2015)
Favorite Quotes:
"Has anyone ever told you that a query you have written runs too fast?" - Dwain Camps - 6 Mar 2014
Yes.
Because the DB was then able to successfully...
--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 6:39 pm

#1839015
RE: Do You Have Scary Code?

GilaMonster (11/10/2015)
I've recently seen a system with many user-defined functions, each with thousands of lines of code, often calling each other. Tests or no tests, I'm not touching that.
They've done...
--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 am

#1838897

Viewing 15 posts - 19,216 through 19,230 (of 59,098 total)