Jeff Moden

Forum Replies Created

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

RE: Copy Table Data

Ed Wagner - Thursday, June 29, 2017 7:26 AM
Jeff Moden - Wednesday, June 28, 2017 6:06 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 29, 2017 at 7:51 am

#1948734
RE: Copy Table Data

No pun intended, but this is SIMPLE. Create the new target table with just the clustered index. The clustered index should be identical on both tables for the best performance...
--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 28, 2017 at 6:06 pm

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

Sergiy - Tuesday, June 27, 2017 10:42 PM
Jeff Moden - Tuesday, June 27, 2017 5:54 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 28, 2017 at 7:21 am

#1948545
RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, June 28, 2017 4:51 AM
jonathan.crawford - Tuesday, June 27, 2017 9:01 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 28, 2017 at 6:55 am

#1948540
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

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