Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,951 through 4,965 (of 59,089 total)

Reply To: Using an Integer parameter in a WHERE clause

Actually, both OR and ISNULL are horrible for performance and should be avoided... when I say "should be avoided", I'm very close to saying "must be avoided at all costs"...
--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)

July 15, 2021 at 3:12 am

#3908094
Reply To: ETL in 2021 ?

My previous experience with SSIS was to determine a method to make table-to-table transfers like this work much more quickly. The way I did that was I stopped using SSIS...
--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)

July 15, 2021 at 1:51 am

#3908069
Reply To: Comparing every row in one table

Now that you have a couple of answers, I have to ask... why do you need to do this? What will it be used for? What business purpose does it...
--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)

July 15, 2021 at 1:49 am

#3908068
Reply To: How to get total only for today's date for some columns in reslut set

You left out the name of the date column for the two tables you're talking about and you didn't include those names anywhere in the code. With that in mind,...
--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)

July 15, 2021 at 1:10 am

#3908065
Reply To: How can I check that SP3 is really installed?

eager2learn wrote:
A systems works with Windows Server 2012 R2 Standard On this system MS SQL-server 2014 (x86) Express version 12.0.2000.8 is installed. The service pack SP3 had to be installed....
--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)

July 15, 2021 at 12:26 am

#3908057
Reply To: Let SQL profiler and Extended event can't capture the sql statement.

892717952 wrote:
Mr. Brian Gale wrote:
I read your question a little differently than Grant and Jeff, so I just wanted to confirm what you were looking to do.
If I understand your question correctly,...
--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)

July 14, 2021 at 8:46 pm

#3907993
Reply To: Importing a CSV into SQL Server Shouldn't Be This Hard

On the subject of "sometimes" quoted CSV's...
I totally agree that it shouldn't be necessary. MS has had more that 2 decades to make this "simple" stuff right as have 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)

July 14, 2021 at 8:19 pm

#3907991
Reply To: Create a View with Index
Let's peel one potato at a time. The first stop is the last item in your code...
```
 (jh.ProdQty - jh.QtyCompleted > 0)
```
Do you see any problems 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)
July 14, 2021 at 5:02 am

#3907658
Reply To: Importing a CSV into SQL Server Shouldn't Be This Hard

As strange as it may strike some, I've not even downloaded DBATools, yet. I'm sure it's documented on the site one way or the other but, just to ask the...
--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)

July 14, 2021 at 4:20 am

#3907650
Reply To: Configure DBMail to send the email to a local folder?

Actually, the email system in SQL Server is quite robust and a copy of every email is stored in the msdb.dbo.sysmail_allitems table. In fact, it's a bit of a pain...
--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)

July 13, 2021 at 5:23 pm

#3907467
Reply To: Create a View with Index

That would be an rCTE (Recursive CTE). If the recursion in based on incremental values and RBAR proceessing, a well written WHILE Loop will be faster and less resource intensive.
--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)

July 13, 2021 at 2:00 pm

#3907406
Reply To: Create a View with Index

robertopmorris wrote:
Apologies - I'm not sure what you mean - there is no cte in the above SQL statement.
Actually, there are 3. The first one starts right after the word...
--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)

July 13, 2021 at 1:41 pm

#3907394
Reply To: Create a View with Index
robertopmorris wrote:
```
WITH SubQuery AS
(
SELECTjh.Company, jh.JobNum, ja.AssemblySeq, jo.OprSeq, jo.OpCode, 
            CAST(CASE WHEN NOT jh.Date03 IS NULL THEN...
```
--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)
July 13, 2021 at 1:37 pm

#3907391
Reply To: Permissions needed to run query on master db

WebTechie wrote:
I do appreciate all of the feedback. However, you are fussing at the DBA who is the low man on the totem pole. AVPs and managers have already made...
--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)

July 13, 2021 at 2:32 am

#3907202
Reply To: Excessive run time

To be honest, this sounds like a case of the bad type of parameter sniffing.
--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)

July 12, 2021 at 11:42 pm

#3907174

Viewing 15 posts - 4,951 through 4,965 (of 59,089 total)