Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,176 through 23,190 (of 59,102 total)

RE: What Is the Hardest Feature to Learn About SQL Server?

I think that the hardest thing (a hidden feature, for sure) for people in general to learn about SQL Server is the paradigm shift necessary to produce high performance code....
--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)

July 21, 2014 at 8:58 am

#1731047
RE: What Is the Hardest Feature to Learn About SQL Server?

andrew gothard (7/18/2014)
Off the top of my head, probably recursive CTE.
Recursive processes in POSH, .Net or VBS - say to explore a directory structure - clear as a bell. ...
--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)

July 21, 2014 at 8:52 am

#1731045
RE: How can we DBAs get alerts when SQL resources don't come online after a cluster failover ?

Joy Smith San (7/21/2014)
Hi Thanks.
I was talking about only SQL Server services. Yes, I stumbled upon PowerShell script.
Anyone has any such script already running by any chance ?
Thanks again.
Smith.
Can...
--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)

July 21, 2014 at 8:47 am

#1731042
RE: Create SQL table from an Excel spreadsheet

J Livingston SQL (7/20/2014)
as an example of what may work for you...........
I have a spreadsheet called JLS.xlsx that is always stored in C:\xlimport (C:\xlimport\jls.xlsx)
it has a worksheet named "data"...
--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)

July 20, 2014 at 9:56 am

#1730865
RE: Create SQL table from an Excel spreadsheet

pnr8uk (7/19/2014)
Thanks for the reply and that is a good article, however it does not create the table automatically from the Excel spreadsheet. I can't create the table first as...
--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)

July 19, 2014 at 9:08 pm

#1730856
RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

@Jeztagab,
You're problem doesn't appear to be hierarchical in nature. For that reason, I'd prefer to not dilute the discussion on this thread to something off topic. Would 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)

July 19, 2014 at 12:45 pm

#1730840
RE: MAXDOP = 1 ?!

SQLRNNR (7/18/2014)
Jeff Moden (7/17/2014)
From what I've seen, Grant Fritchey's recommendations for changing the default threshold of parallelism are much more effective than changing the whole server to use MAXDOP 1....
--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)

July 18, 2014 at 8:12 am

#1730631
RE: Importing Poorly Formatted Text File

Ed Wagner (7/18/2014)
Jeff Moden (7/17/2014)
Ok. Here we go. Time for some good ol' fashioned "Black Arts". 🙂
The first thing is, is to understand the true nature of 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)

July 18, 2014 at 7:26 am

#1730597
RE: Importing Poorly Formatted Text File

Koen Verbeeck (7/18/2014)
Ed Wagner (7/18/2014)
Koen Verbeeck (7/18/2014)
Jeff Moden (7/18/2014)
@Koen,
Now you see why I never get into SSIS. I just don't need it.
Everyone has his own tool. I can say...
--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)

July 18, 2014 at 7:14 am

#1730591
RE: Convert Rows into Columns

zbychbor (7/18/2014)
And next solution:
regards
Zbig
;with lot(lotNo) as (
select lotNo
FROM (VALUES('A'),('B'),('C'),('D'),('E'),('F'),('G'),('H'),('I'),('J'),('K'),('L'),('M'),('N'),('O'),('P'),('Q'),('R'),('S'),('T'),('U'),('V'),('W'),('X'),('Y'),('Z'))t(LotNo)
)
, cte02 as (
select rn = row_number() over (order by lotNo)
...
--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)

July 18, 2014 at 6:45 am

#1730577
RE: Convert Rows into Columns

antonio.zerbinati (7/18/2014)
I dislike the solution proposed, it's far too complicated to reach a so easy task.
You requirement was to print 3 lots at a time per line of document. This...
--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)

July 18, 2014 at 6:36 am

#1730575
RE: Convert Rows into Columns

fregatepllada (7/17/2014)
Despite all of my protests I have to implement EAV in my current project because some genius :alien: "discovered" this anti-pattern. I do not need to do any aggregation...
--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)

July 18, 2014 at 6:21 am

#1730566
RE: Importing Poorly Formatted Text File

Koen Verbeeck (7/18/2014)
Jeff Moden (7/18/2014)
@Koen,
Now you see why I never get into SSIS. I just don't need it.
Everyone has his own tool. I can say the same thing 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)

July 18, 2014 at 5:22 am

#1730551
RE: Importing Poorly Formatted Text File

@Koen,
Now you see why I never get into SSIS. I just don't need 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)

July 18, 2014 at 12:00 am

#1730495
RE: Importing Poorly Formatted Text File

Ok. Here we go. Time for some good ol' fashioned "Black Arts". 🙂
The first thing is, is to understand the true nature of the data-file example that was...
--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)

July 17, 2014 at 11:51 pm

#1730492

Viewing 15 posts - 23,176 through 23,190 (of 59,102 total)