Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,466 through 6,480 (of 59,091 total)

Reply To: Complex Join
Sergiy wrote:
Still there is a shorter version:
```
select * 
from leftTable  T1
join rightTable T2 
   on (
      T1.C1 = T2.C1...
```
--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)
September 9, 2020 at 7:35 pm

#3787404
Reply To: Extended Event collect sql text executed

Erland Sommarskog wrote:
(Well, I tend to think that it works better in any version given how much easier Trace is to use, but that is another story.)
It's too bad that...
--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)

September 9, 2020 at 5:03 pm

#3787373
Reply To: Select unique records between several tables

Is there a pattern to the actual name of the tables and are all of the tables in the same database?
--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)

September 9, 2020 at 5:01 pm

#3787369
Reply To: how to get Pivot result set using 3 tables

Erland Sommarskog wrote:
Jeff, he has already answered which version he has: SQL Express 2012 SP1. (So, Gaurav, you should apply the latest Service Pack for SQL 2012, which is SP4!)
Thanks, Erland......
--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)

September 9, 2020 at 4:54 pm

#3787364
Reply To: Changing nvarchar to varchar

p.s. I you do decide to move the table (whether you turn it into a partitioned view or not), you should keep the original table for a couple of weeks...
--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)

September 9, 2020 at 1:54 pm

#3787324
Reply To: Changing nvarchar to varchar

terry999 wrote:
Jeff Moden wrote:
I don't see much advantage to changing ProcessName or Type to a key from a "process table" or "type" table. In the face of the other tables, it's...
--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)

September 9, 2020 at 1:38 pm

#3787323
Reply To: Compare data with previous period

Since you're using a version of SQL Server that's 2012 or above, here's a method that eliminates the need for a self join and the extra reads that go 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)

September 9, 2020 at 4:23 am

#3787198
Reply To: Changing nvarchar to varchar

Terry,
If this is truly a log table (the name of it implies that it is) , there are two things that I'd do. As you say, changing the NVARCHARs 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)

September 9, 2020 at 3:56 am

#3787196
Reply To: Complex Join

Thanks for taking the time to post the readily consumable data.
I agree... Sergiy's shortened version doesn't work the same as the code you posted. I've not worked with Boolean Algebra...
--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)

September 9, 2020 at 2:49 am

#3787193
Reply To: Any 2014 to 2019 migration issues?

Johan Bijnens wrote:
I haven't encountered issues yet.
In any case, best is to start your preparation using SQL Server Data Migration Assistant
As a bit of a sidebar, I won't use...
--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)

September 8, 2020 at 1:43 pm

#3786985
Reply To: Index build spilling to tempdb

What size is the actual index? I'm not talking about the memory grants, etc. How many pages does the actual index have?
As for as the memory grant formulas being used...
--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)

September 8, 2020 at 1:40 pm

#3786984
Reply To: Issues with SQL Trigger

n.subbuu wrote:
The requirement is export the rows to a text file in a path when it meets the condition. Like say when there is a transaction of particular store, 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)

September 8, 2020 at 1:04 pm

#3786963
Reply To: Issues with SQL Trigger

To be honest, I think this whole task might be a mistake in the making. It sounds like someone is trying to build a homegrown version of replication. What is...
--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)

September 7, 2020 at 10:14 pm

#3786836
Reply To: Changing nvarchar to varchar

terry999 wrote:
Thanks Jeff that's a good point, which I do not know the answer. I don't have control over the code. I doubt the support Guy I'm talking to, would...
--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)

September 7, 2020 at 10:08 pm

#3786834
Reply To: query to calculated based on the value of previous month

To be honest, I'd spend a little more time on the forecast formulas. They appear to take a flat line set of actuals and "predict" a 50% increase that results...
--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)

September 7, 2020 at 7:56 pm

#3786825

Viewing 15 posts - 6,466 through 6,480 (of 59,091 total)