Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,706 through 15,720 (of 59,097 total)

RE: How to Group By day and get a total from the Amount column per day?

Lowell - Thursday, February 9, 2017 11:29 AM
i think this will do it.
i'm using datemath to round the dates down to midnight...
--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 9, 2017 at 12:04 pm

#1927618
RE: Data loading is incomplete -

ramana3327 - Thursday, February 9, 2017 6:46 AM
We are using the database in simple recovery. I believe simple recovery model is also...
--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 9, 2017 at 9:22 am

#1927568
RE: Need Some Urgent Help in converting the 24 hour date format to grouping with 0-23 range

Ravi Teja - Tuesday, February 7, 2017 7:44 PM
Hi Friends need some help here. I am having a table with order date(yyyy-mm-dd)...
--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 5:01 am

#1927290
RE: How to write a string to a file in SQL.

Heh... if that's all there is to UTF-8, you have to wonder what the hell MS has been waiting on.
--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:45 am

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

Viewing 15 posts - 15,706 through 15,720 (of 59,097 total)