Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,726 through 16,740 (of 59,067 total)

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
RE: How to close a file to move to another disk

The long boot time may be because all your databases are in the FULL Recovery Model, no backups have ever been taken, the log files have gotten huge, and they...
--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:46 pm

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

paolo.bert (9/23/2016)
What to say, Jeff... First of all, maaany thanks for your thorough reply. I was afraid to post a so 'stupid' question on this Guru's cave, but now 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)

September 23, 2016 at 11:38 am

#1902879
RE: Urgent Help Need for DB Restoration

Now that you've solved your problem, prepare for the next problem by practicing how to do a restore until you can do it in your sleep. Having restore scripts...
--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 9:49 am

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

paolo.bert (9/23/2016)
I am not a PRO, but I used them in Access97, writing SQL code (TRANSFORM command), a long time ago, and as far as I remember there wasn't that...
--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 9:01 am

#1902812

Viewing 15 posts - 16,726 through 16,740 (of 59,067 total)