Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,476 through 14,490 (of 59,101 total)

RE: Update Statistics..

Arsh - Friday, September 1, 2017 5:40 AM
GilaMonster - Thursday, August 31, 2017 1:19 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)

September 1, 2017 at 6:55 am

#1957818
RE: First / last item of a string in a nvarchar field

Mike Good - Friday, September 1, 2017 5:53 AM
Doh. That would be the Luis...
--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)

September 1, 2017 at 6:38 am

#1957814
RE: date fillers - dates in two rows

Jason A. Long - Thursday, August 31, 2017 6:40 PM
ekant_alone - Thursday, August 31, 2017 4:07 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)

August 31, 2017 at 8:33 pm

#1957775
RE: date fillers - dates in two rows

ekant_alone - Thursday, August 31, 2017 4:07 PM
yes i am allowed to. But i am confused how i can help my case...
--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)

August 31, 2017 at 8:24 pm

#1957773
RE: date fillers - dates in two rows

ekant_alone - Thursday, August 31, 2017 3:11 PM
Also change in requirement - i want hourly increment and not daily increment. thus there...
--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)

August 31, 2017 at 3:49 pm

#1957761
RE: Script out permissions - Azure SQL database

Dunno but I'm pretty sure that a decent look in Yabingooglehoo will help. It's what I'd have to do if I were looking for such a thing.
--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)

August 31, 2017 at 3:24 pm

#1957755
RE: First / last item of a string in a nvarchar field

Avi1 - Thursday, August 31, 2017 12:34 PM
There are multiple options, based on your requirement and can choose

---to get all...
--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)

August 31, 2017 at 3:16 pm

#1957754
RE: date fillers - dates in two rows

ekant_alone - Thursday, August 31, 2017 11:56 AM
Hello Drew, i used the below mentioned SQL to get pass through the above issue.,...
--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)

August 31, 2017 at 3:03 pm

#1957749
RE: Can I restore a single file .mdf to multiple files spread across disks

Arsh - Thursday, August 31, 2017 7:35 AM
GilaMonster - Wednesday, August 16, 2017 11:09 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)

August 31, 2017 at 2:22 pm

#1957743
RE: PLE

While I certain appreciate the attention to detail on all the hardware tricks of the trade, I'd really be surprised if much happened in the area of performance. If you...
--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)

August 31, 2017 at 2:19 pm

#1957741
RE: PLE

Arsh - Thursday, August 31, 2017 11:48 AM
Spot on Jeff! Have taken are to put that specifically. Proposed two different ...
--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)

August 31, 2017 at 2:16 pm

#1957740
RE: Update Statistics..

For the experiment, I'd use UPDATE STATISTICS schemaname.tablename WITH FULLSCAN; during a relatively quiet time. The reason for the WITH FULLSCAN is because auto-updates of statistics can be done 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)

August 31, 2017 at 9:49 am

#1957688
RE: Database Development Made Easy?

ZZartin - Wednesday, August 30, 2017 12:11 PM
jasona.work - Wednesday, August 30, 2017 6:31 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)

August 31, 2017 at 7:50 am

#1957657
RE: Update Statistics..

Arsh - Thursday, August 31, 2017 2:00 AM
Hi Experts,
Trying to figure out if it might help in solving any performance issues by...
--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)

August 31, 2017 at 7:43 am

#1957652
RE: PLE

Just a quick note... if the system is on a SAN and unless the SAN admin is very careful with how the logical drives are setup to guarantee the logical...
--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)

August 31, 2017 at 7:11 am

#1957640

Viewing 15 posts - 14,476 through 14,490 (of 59,101 total)