Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,436 through 9,450 (of 59,102 total)

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
Reply To: LTRIM function giving same results as TRIM

To add to what Sue has stated, LEN doesn't include trailing spaces in its count. Here's the note from Books Online. The emphasis is mine.

Returns the number of characters 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 22, 2019 at 3:09 am

#3508297
Reply To: Viewing database diagrams

That and something that would work like "Query Designer on Steroids" where you would simply select a stored procedure and it would generate an ERD for each section of code...
--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 3:02 am

#3508241
Reply To: Interview question

Couldn't you also put a path "director" in the overall flow to select a path based on the time of day and execute the package 3 times? Again, forgive me...
--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 3:00 am

#3508231
Reply To: Viewing database diagrams

Ok... cancel my last. I went to the link posted and they didn't ask for a whole lot (just Name and email address) and so I took a shot at...
--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 21, 2019 at 8:55 pm

#3503685

Viewing 15 posts - 9,436 through 9,450 (of 59,102 total)