Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,756 through 16,770 (of 59,101 total)

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
RE: Datatype performance - in theory there should be a difference, but in practice is there?

Eirikur Eiriksson (8/2/2016)
pcd_au (8/2/2016)
Eirikur Eiriksson (8/2/2016)
You will have to understand how the SQL Server works, which workload is expensive and which factors bear more weight than others, data sizes 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)

September 25, 2016 at 6:10 pm

#1903004
RE: The Black Boxes

To be honest, I don't trust any black box be it software or hardware or a combination. All can be setup to reveal information you might not want 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)

September 25, 2016 at 5:37 pm

#1903003
RE: How to close a file to move to another disk

SpeedSkaterFan (9/24/2016)
Reading Michel's advice yesterday, and after taking a good look at the contents of SQL Server config mgr, not only did I set SQL Server to a manual start,...
--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 24, 2016 at 1:58 pm

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

The Dixie Flatline (9/23/2016)
If you haven't read up on the MERGE operation in TSQL, be sure to do so. It allows you to insert and update (and d...
--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 23, 2016 at 11:41 pm

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

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 the author...
--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 23, 2016 at 10:12 pm

#1902943
RE: An interview question!!!!

dinksha70 (9/23/2016)
If an interviewer ask you a question:
"A report runs everyday (using a Store procedure). Just say it takes 15 min.to generate the report.
today it is took an hour....
--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 23, 2016 at 7:33 pm

#1902940
RE: How to close a file to move to another disk

SpeedSkaterFan (9/23/2016)
Hi Scott and Jeff,
Thanks for your suggestions.
Maybe some answer to your suggestions:
I don't believe my databse is in full recovery mode, I turned it off. My database is a...
--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 23, 2016 at 6:35 pm

#1902939
RE: How to close a file to move to another disk

Post deleted... I don't know what the heck I was thinking when I wrote it but it was totally incorrect.
--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 23, 2016 at 6:10 pm

#1902938
RE: Are the posted questions getting worse?

Luis Cazares (9/23/2016)
Someone needs a course on how to write basic DML. Or maybe I'm just grumpy this week.
No... you're not grumpy. As a matter of fact, ever 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 23, 2016 at 2:14 pm

#1902926
RE: How to Pass Multiple Strings as one parameter in Store Procedure

The Dixie Flatline (9/23/2016)
Just for what it's worth, we used to use the string splitter approach until the developers finally bit the bullet and learned to use table valued parameters....
--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 23, 2016 at 12:50 pm

#1902903
RE: SPID blocking frequently

Since it only recently started, my question would be... how often do you update statistics?
--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 23, 2016 at 12:48 pm

#1902902

Viewing 15 posts - 16,756 through 16,770 (of 59,101 total)