Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,721 through 15,735 (of 59,101 total)

RE: High Memory Usage

ThomasRushton - Tuesday, February 7, 2017 4:57 AM
WhiteLotus - Monday, February 6, 2017 3: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)

February 7, 2017 at 8:10 am

#1927100
RE: How to know on which column should we create index.

mcfarlandparkway - Thursday, February 2, 2017 7:32 AM
I have a table getcode where it has countrycode,statecode, citycode and zipcode columns
there are other...
--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)

February 6, 2017 at 4:45 pm

#1926999
RE: Very large Indexes (~3TB) and need to rebuild fast

ALIF-662928 - Monday, February 6, 2017 3:57 PM
Hi Jeff, you have any articles to support it?
If I didn't, I'd write one. 😉 ...
--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)

February 6, 2017 at 4:22 pm

#1926995
RE: Very large Indexes (~3TB) and need to rebuild fast

ALIF-662928 - Monday, February 6, 2017 3:25 PM
Hi,
Hi,
We have a 40 TB DB, and have some big tables and few indexes which...
--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)

February 6, 2017 at 3:48 pm

#1926991
RE: HOW TO RUN THE SAME SCRIPT TO RETRIEVE DATA FROM MULTIPLE DATABASES

JALLY - Monday, February 6, 2017 3:16 PM
Greetings,
i have a challenge, who can point me or show me the simplest how 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)

February 6, 2017 at 3:42 pm

#1926989
RE: Deleting a row(s)

Now that you've got a couple of answers, I have to ask... who is fixing the original code that caused this problem to begin 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)

February 6, 2017 at 7:44 am

#1926864
RE: Importing data from Excel using ForEach Loop

delaine.gocke - Friday, August 29, 2008 7:38 AM
Any suggestions?
BAAA-HAAA!!! Yeah... Do it in T-SQL instead. 😉
--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)

February 6, 2017 at 7:41 am

#1926863
RE: Your Favorite Feature that Needs Work

roger.plowman - Monday, February 6, 2017 7:02 AM
I wouldn't mind a better syntax for upsert. I mean, the current one is just...
--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)

February 6, 2017 at 7:38 am

#1926862
RE: Today's Random Word!

Manic Star - Monday, February 6, 2017 6:56 AM
Kaye Cahs - Monday, February 6, 2017 6:53 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)

February 6, 2017 at 7:35 am

#1926860
RE: Truncating transaction logs

Tatay_2016 - Saturday, February 4, 2017 5:25 PM
I have a MS SQL 2008 database, remote hosted. Recently the host upgraded the...
--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)

February 6, 2017 at 7:31 am

#1926857
RE: Close Encounters of the CEIP Kind

Gary Varga - Monday, February 6, 2017 4:42 AM
I am a little concerned that this is hidden. I can even understand 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)

February 6, 2017 at 7:22 am

#1926855
RE: Best way to determine to Clustered index keys

goher2000 - Sunday, February 5, 2017 11:50 PM
I would (assuming one node can handle the workload cuz in my environment it does...
--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)

February 6, 2017 at 6:49 am

#1926845
RE: How does SSMS knows about the scalar functions ?

karenworld - Sunday, February 5, 2017 11:44 PM
Hi expert,
I have this reference code which make use of Scalar functions and stored procedure.
The...
--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)

February 6, 2017 at 6:43 am

#1926844
RE: Query to take the backup

ramyours2003 - Thursday, February 2, 2017 7:50 AM
I need a query to take the differential backup of all the databases in sql...
--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)

February 5, 2017 at 11:16 pm

#1926784
RE: same query, different behavior on different networks

Have you verified that the table in both "networks" has the same number of rows and have the exact same rows? I know you say you use the same copy...
--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)

February 5, 2017 at 11:08 pm

#1926783

Viewing 15 posts - 15,721 through 15,735 (of 59,101 total)