Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,711 through 16,725 (of 59,067 total)

RE: Are the posted questions getting worse?

SQLBill (10/3/2016)
Lynn Pettis (10/3/2016)
What ever happened to basic problem solving skills?
Basic Problem Solving Skills checklist:
1. post issue on SQL Server Central without examples or all the details
2. if you don't...
--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)

October 3, 2016 at 3:34 pm

#1904568
RE: Maximum number of CROSS APPLY functions

The Dixie Flatline (10/3/2016)
This is part of an ETL process I'm having to work on replacing. The existing process has rather complicated logic governing when columns 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)

October 3, 2016 at 3:31 pm

#1904567
RE: SPID blocking frequently

SQL Galaxy (9/27/2016)
Hi SQL GURU and Jeff,
Issues resolved by developer, he has changed and modified the existing whole query at application side. After that there is no glitch...
--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)

October 2, 2016 at 4:28 pm

#1904317
RE: The Black Boxes

TomThomson (9/26/2016)
Jeff Moden (9/26/2016)
Steve Jones - SSC Editor (9/26/2016)
On our Prius, if you lose power, you cannot open the rear hatch, at least not without disassembling a panel. Guess where...
--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)

October 2, 2016 at 4:19 pm

#1904316
RE: Maximum number of CROSS APPLY functions

The Dixie Flatline (9/30/2016)
Fortunately, I only need around 300, not thousands. 😀
Thanks guys.
Just curious.... what are you doing that needs so many APPLYs?
--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)

October 2, 2016 at 4:04 pm

#1904315
RE: How to average a date column?

Sorry... I wasn't paying attention. This is a 6 year old thread and andrewd.smith did previously post code for the "Average Date" problem.
--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)

September 30, 2016 at 9:16 pm

#1904284
RE: How to average a date column?

Evil Kraig F (11/2/2010)
Hm, the only solutions I'd have for you with this puzzle would be in T-SQL code, not at the reporting layer.
If you really wanted a date average,...
--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)

September 30, 2016 at 9:14 pm

#1904283
RE: Using "Update" or "Merge" on 2014 SQL table

alex_martinez (9/26/2016)
Jeff,
By chance it's only about 10 - 20 rows per day to insert so that shouldn't be an issue. Thank you.
What are the ramifications if those 1-20 rows...
--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)

September 26, 2016 at 1:27 pm

#1903202
RE: Using "Update" or "Merge" on 2014 SQL table

The Dixie Flatline (9/26/2016)
Jeff, I have to agree that if you're trying to do a large number of rows in a single merge, you need to jump through some hoops...
--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)

September 26, 2016 at 12:25 pm

#1903176
RE: Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator

Jeff Moden (9/23/2016)
h.tobisch (9/23/2016)
I do not like the wording. A column HAS a name and CONTAINS values.
so, to my understanding,
'first pivoted column' should be 'first value of pivoted column'
Since...
--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)

September 26, 2016 at 12:23 pm

#1903175
RE: SPID blocking frequently

SQL Galaxy (9/25/2016)
Pl. suggest me, How can escalate to application developer?
Ummm... ostensibly, you're the DBA on this system. You need to figure it out without having to rely on...
--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)

September 26, 2016 at 12:15 pm

#1903171
RE: Datatype performance - in theory there should be a difference, but in practice is there?

pcd_au (9/26/2016)
However my original question did (try to) restrict answers to data warehousing style applications.
Understood that from the beginning. A data warehouse application isn't much different than anything else...
--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)

September 26, 2016 at 12:05 pm

#1903168
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (9/26/2016)
jasona.work (9/26/2016)
I find it a little concerning that while there's been a decent amount of talk about how this will impact desktop Windows, there's not...
--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)

September 26, 2016 at 11:56 am

#1903164
RE: The Black Boxes

Steve Jones - SSC Editor (9/26/2016)
Gary Varga (9/26/2016)
Steve Jones - SSC Editor (9/26/2016)
...I especially hate the newer keyless entry that doesn't have a backup. When there's an issue with electronics,...
--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)

September 26, 2016 at 11:19 am

#1903155
RE: Datatype performance - in theory there should be a difference, but in practice is there?

I can't speak for anyone else but here are my thoughts and a couple or personal observations on the subject.
On the original subject of "does it really matter", the 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)

September 25, 2016 at 6:40 pm

#1903005

Viewing 15 posts - 16,711 through 16,725 (of 59,067 total)