Jeff Moden

Forum Replies Created

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

Reply To: Text file import

Wecks wrote:
Is there a script that scan take text that is not column delimited and transfer each line into a separate record and each line where it is separated 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)

April 26, 2019 at 2:50 pm

#3540901
Reply To: Hidden Formatting Troubles with STR() (SQL Spackle)

If I'm reading your post correctly, I actually DO demonstrate that phenomena in the article in a couple of places.
--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 26, 2019 at 2:39 pm

#3540863
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Quoting is a big challenge with styling and code. Really, I'd urge you to avoid hitting quote every single time. In this thread, it is often helpful, but in...
--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 26, 2019 at 2:49 am

#3538458
Reply To: Time difference

Ah... sorry, Jonathan... If that came across as me badmouthing your code, it wasn't what was intended, especially since the OP provided no data to suggest that a daily boundary...
--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 4:01 pm

#3536176
Reply To: Are the posted questions getting worse?
Jeff Moden wrote:
Please ignore this post. It's just a test to see if I was able to clear up a problem where SSC thought I was trying to post empty replies.
Lordy......
- This reply was modified 7 years, 5 months ago by Jeff Moden.
--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 2:07 pm

#3535746
Reply To: Are the posted questions getting worse?

Please ignore this post. It's just a test to see if I was able to clear up a problem where SSC thought I was trying to post empty replies.
--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 2:05 pm

#3535744
Reply To: Time difference

Unless I'm misreading the given solution, it won't properly calculate the time difference correctly for entries that span a date boundary.

This is one of the many reasons why I rail...
--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:59 pm

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

Have a look at the following link... pay particular attention to the Light Blue box of text in it...
https://docs.microsoft.com/en-us/sql/t-sql/statements/set-ansi-nulls-transact-sql?view=sql-server-2017
A whole lot of front-end Developers in the world wrote 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 25, 2019 at 1:55 am

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

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