Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,836 through 14,850 (of 59,097 total)

RE: Tempdb

krishna83 - Monday, June 26, 2017 10:54 AM
TheSQLGuru - Monday, June 26, 2017 10:40 AM
--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)

June 27, 2017 at 8:37 pm

#1948492
RE: Tempdb

TheSQLGuru - Monday, June 26, 2017 10:40 AM
Tempdb file(s) should be EXACTLY the same size with EXACTLY the same growth increments. 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)

June 27, 2017 at 8:26 pm

#1948490
RE: replacing hard coded value with column name fails the query

jcelko212 32090 - Monday, June 26, 2017 1:25 PM
Jeff Moden - Sunday, June 25, 2017 3:39 PM
--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)

June 27, 2017 at 8:10 pm

#1948486
RE: If statement in T-SQL

jcelko212 32090 - Monday, June 26, 2017 1:32 PM
It is completely different from flow control which doesn't exist in declarative languages....
--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)

June 27, 2017 at 7:48 pm

#1948484
RE: Help needed in resolving dead lock

Jeff Moden - Monday, June 26, 2017 11:22 AM
shamantha4 - Sunday, June 25, 2017 12:39 AM
--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)

June 27, 2017 at 7:25 pm

#1948483
RE: Database Migration.

newdba2017 - Tuesday, June 27, 2017 8:48 AM
I need to migrate one of the database we have from one server (2008 standard...
--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)

June 27, 2017 at 7:23 pm

#1948482
RE: Help needed in resolving deadlocks

Steve Jones - SSC Editor - Monday, June 26, 2017 11:11 AM
Please post here. This is more appropriate for the administration forum....
--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)

June 27, 2017 at 7:22 pm

#1948481
RE: Impact of running dbcc cleantable in sharepoint database

Your handle has the abbreviation "DBA" in it. You should know this or know how to find 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)

June 27, 2017 at 7:20 pm

#1948480
RE: How Can I Write A Query That Sums the Number of Occurrences Of a Value and Groups Them Into Ranges

Alan.B - Tuesday, June 27, 2017 2:45 PM
Dang! Ed beat me to it.
I would add - for optimal performance you want 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)

June 27, 2017 at 7:15 pm

#1948479
RE: Are the posted questions getting worse?

Lynn Pettis - Friday, June 23, 2017 10:07 AM
Jeff Moden - Friday, June 23, 2017 9:27 AM
--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)

June 27, 2017 at 6:01 pm

#1948468
RE: Are the posted questions getting worse?

jasona.work - Tuesday, June 27, 2017 6:49 AM
Sergiy - Monday, June 26, 2017 11:22 PM
--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)

June 27, 2017 at 5:59 pm

#1948467
RE: Are the posted questions getting worse?

jonathan.crawford - Tuesday, June 27, 2017 9:01 AM
Jeff Moden - Monday, June 26, 2017 6:44 PM
--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)

June 27, 2017 at 5:57 pm

#1948466
RE: SUBSTRING and CHARINDEX query.... please help.

Sergiy - Tuesday, June 27, 2017 4:49 PM
Jeff Moden - Saturday, June 24, 2017 9:51 AM
--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)

June 27, 2017 at 5:54 pm

#1948465
RE: Unable to understand the Query Logic

autoexcrement - Tuesday, June 27, 2017 2:18 PM
I love you Jeff Moden.
Thanks, but nah... I got the problem definition wrong.
--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)

June 27, 2017 at 5:51 pm

#1948463
RE: Unable to understand the Query Logic

J Livingston SQL - Tuesday, June 27, 2017 6:20 AM
I think that this is the origin of the question, along with...
--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)

June 27, 2017 at 9:18 am

#1948406

Viewing 15 posts - 14,836 through 14,850 (of 59,097 total)