Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,451 through 6,465 (of 59,072 total)

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
Reply To: How to check if the file exists in S3 bucket.

I'm not a PowerShell user but a Google for "check if file already exists using powershell" turns up things that may easily help do what you want. Try it.
Even better...
--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:43 pm

#3786824
Reply To: Issues with SQL Trigger

n.subbuu wrote:
Yes for my testing, I have database called tesdb and testing it by manual insert. So if this is not the right way of doing, can you please advise...
--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:33 pm

#3786823
Reply To: Issues with SQL Trigger

Do you actually have a table called "TestDB"? If so, which database is it in and what in your BCP command identifies that database?
I also agree with Sergiy. Having this...
--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 6, 2020 at 1:06 am

#3786634
Reply To: Complex Join

DonlSimpson wrote:
It's not what is expected, and the data condition won't occur. Each column is null-able, but both cannot be null.
You should post some readily consumable test data and 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 6, 2020 at 12:47 am

#3786633
Reply To: Silly SQL Question
Jeffrey Williams wrote:
If the only values available in the result column are Y or N - you could do this:
```
 Select r.id
   From Response r
 ...
```
--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 5, 2020 at 11:10 pm

#3786628
Reply To: Silly SQL Question
Sergiy wrote:
Actually, a single scan would be just fine:
SELECT ID
FROM Response r
GROUP BY ID
HAVING MAX(result) <> MIN(result);
You've just gotta love the old ways. 😀
--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 5, 2020 at 4:14 pm

#3786601
Reply To: Retrieving the total number of records in a SQL instance

Ok... I have a question, especially seems to be coming up a lot lately.
To what end does someone need this type of information? What will the information ultimately be 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 4, 2020 at 4:41 pm

#3786454
Reply To: Changing nvarchar to varchar

Sergiy wrote:
The words might be strong, but apparently not strong enough, considering how the masses of developers mindlessly follow the pattern (by default from MS) and clustering everything by ID
True...
--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 4, 2020 at 4:29 pm

#3786451
Reply To: Changing nvarchar to varchar
terry999 wrote:
So if I were going to change the table's fields from Nvarchar to varchar as long as they are not executing
```
example: SELECT ... FROM ... WHERE...
```
--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 4, 2020 at 2:44 pm

#3786316

Viewing 15 posts - 6,451 through 6,465 (of 59,072 total)