Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,421 through 9,435 (of 59,091 total)

Reply To: Rebuilding indexes

oogibah wrote:
Quite a few people use Ola Hallengrens solution for this, if you google that name it will come right up.. just schedule the job to run during your maintenance...
--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)

April 25, 2019 at 1:25 am

#3533380
Reply To: Rebuilding indexes

If you don't have mirroring or log shipping or anything else running that would be damaged by changing the Recovery Model, do a log backup, change the recovery model 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)

April 24, 2019 at 10:00 pm

#3532733
Reply To: Can using a scalar UDF actually improve performance?

I'm thinking that "everything changes" when you're using a remote connection but don't know for sure. I supposed "It Depends" on the connection settings. If you've come across connection settings...
--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)

April 24, 2019 at 9:52 pm

#3532684
Reply To: Incrementally loading a very large Dimension table - Performance problems

Another possibility along with the known problems of compression and page splits is that you may have a shedload of indexes that are all doing the same deadly dance.
--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)

April 24, 2019 at 3:42 pm

#3531389
Reply To: Incrementally loading a very large Dimension table - Performance problems

TheComedian wrote:
The table must remain compressed

That is very likely your biggest problem. If you're updating pages and the updates are "ExpAnsive" (the rows get bigger), then you run into rampant...
--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)

April 24, 2019 at 3:41 pm

#3531376
Reply To: Creating DR strategy from scratch for 4 production instances of SQL Server

Just make damned sure that you know who can access your stuff on the cloud. A lot of people don't setup security right. There's been more than one instance of...
--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)

April 24, 2019 at 2:41 pm

#3531192
Reply To: SQL VIEW works on its own but not when combined

I've got to disagree about SQL Server not being good about code reuse and say "It Depends". And it really depends when it comes to views because they're frequently written...
--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)

April 24, 2019 at 2:32 pm

#3531094
Reply To: Splitting a multi-dimensional Array in SQL Server 2012

You'll probably get some responses if you make the data you posted "readily consumable". Please see the link in my signature line below for one way to do that.

Also, 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)

April 24, 2019 at 2:21 pm

#3531067
Reply To: SQL VIEW works on its own but not when combined

thenewbee wrote:
Each view is bit complicated and brings back huge volume of data and they are grouped
I know it's not the answer you're looking for but the two items above...
--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)

April 24, 2019 at 2:04 pm

#3531010
Reply To: Get the Datetime

Thomas Franz wrote:
be aware, that adding dates / times only works with the DATETIME data type but not with the new (ANSI compatible) DATETIME2 (this would cause Error 8117: Operand data...
--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)

April 23, 2019 at 10:05 pm

#3526645
Reply To: Regarding project description

sneha.kranthi wrote:
Hi Jeff Maden, Thank you for taking time and explain things. I will try my best and study the concepts needed.
You could at least apply enough attention 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)

April 22, 2019 at 1:44 pm

#3513687
Reply To: LTRIM function giving same results as TRIM

I guess I don't understand the need for the parameters of BOTH, LEADING, and TRAILING. Apparently the industry standard has changed over time because, for me, TRIM() always meant both...
--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)

April 22, 2019 at 1:40 pm

#3513679
Reply To: SQL Hung

haichells wrote:
What is this PDW & Poly Database movement about? I see some errors on those services in my SQL log.

We can't see your logs. You should post the errors...
--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)

April 22, 2019 at 11:57 am

#3513077
Reply To: LTRIM function giving same results as TRIM
Eirikur Eiriksson wrote:
TRIM can remove characters other than spaces, LTRIM and RTRIM an only remove spaces 😎 This works fine
SELECT LEN(TRIM('.' FROM '.....SSMS.....'))
Good lord... talk about a...
--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)
April 22, 2019 at 11:49 am

#3512993
Reply To: Filling the blanks of a Rolling total with Previous non-blank value- DAX Query.
Steve Dell wrote:
```
Actual_DateReceivedVendor
201804250        10256
201805023128.57        10256
201806143103.09        10256
201808023120.19 ...
```
--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)
April 22, 2019 at 11:46 am

#3512954

Viewing 15 posts - 9,421 through 9,435 (of 59,091 total)