Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,676 through 15,690 (of 59,063 total)

RE: Backups Aren't Backups Until a Restore Is Made

We do a restore of our two big "money makers" every night. We use them for troubleshooting purposes if anything goes wrong in prod but I'd do it anyway even if...
--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 8, 2017 at 4:36 am

#1927282
RE: Query fills tempdb after upgrade from 2005 to 2012

Definitely post the query. If you can post the actual execution plan as an SQLPlan attachment, that would help, as well.
--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 11:40 pm

#1927242
RE: Trouble with openxml query

pisorsisaac - Tuesday, February 7, 2017 8:24 PM
GRRR (at myself) ... I'm very thankful to you for looking at my problem, can't...
--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 10:38 pm

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

ALIF-662928 - Tuesday, February 7, 2017 11:24 AM
As it seems like there is not a standard approach for this, so have 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 7, 2017 at 5:35 pm

#1927224
RE: Trouble with openxml query

Either I'm not yet used to the new forum software or you forgot to attach the attachment you're talking about.
--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 5:07 pm

#1927222
RE: trouble wit a poor performing query

srmc - Tuesday, February 7, 2017 2:44 PM
I've got a poor performing query and not sure the best approach to fixing 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)

February 7, 2017 at 5:00 pm

#1927220
RE: convert HH:MM:SS to datetime

I have to ask why someone is storing something that will only ever contain digits and colons as NVARCHAR. It should be stored simply as CHAR(8) if the times never...
--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 9:20 am

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

Viewing 15 posts - 15,676 through 15,690 (of 59,063 total)