Jeff Moden

Forum Replies Created

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

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
RE: PLE

Arsh - Wednesday, August 30, 2017 8:11 AM
Jeff Moden - Tuesday, August 29, 2017 8:24 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 30, 2017 at 4:54 pm

#1957568
RE: Script out permissions - Azure SQL database

SQL!$@w$0ME - Wednesday, August 30, 2017 12:00 PM
SQL!$@w$0ME - Thursday, January 26, 2017 11:20 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 30, 2017 at 4:01 pm

#1957563
RE: Calendar Table Function

michael-l-johnson - Tuesday, August 29, 2017 10:09 PM
I have not received a reply.
Then I'd use ScottPletcher's technique to build a real Calendar...
--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 30, 2017 at 8:46 am

#1957456
RE: Are the posted questions getting worse?

Sean Lange - Wednesday, August 30, 2017 7:40 AM
The quote from the top decision maker is "we will never be fully...
--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 30, 2017 at 8:12 am

#1957441

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