Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,686 through 2,700 (of 59,099 total)

Reply To: undocumented syntax?

Actually, SELECT INTO is very explicitly documented and incredibly useful (especially for building Temp Tables without having to use CREATE TABLE). See the following link...
https://learn.microsoft.com/en-us/sql/t-sql/queries/select-into-clause-transact-sql
To quote from the FROM...
--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)

October 2, 2022 at 8:08 pm

#4094608
Reply To: How to calculate orders historically, during month
It would be nice if the example data script actually worked. 😉 Here are the results then I try to load the data for the Customer_Orders.
```
Msg 2627,...
```
--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)
October 1, 2022 at 10:27 pm

#4094438
Reply To: How and where did you learn SQL from?

VladBar wrote:
Could you give me advice on where I should learn SQL and Python to become high-skill engineer?
Most tutorials and courses seem here to focus on the querying part 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)

October 1, 2022 at 10:07 pm

#4094436
Reply To: Clearing the pending transaction from the Replication logs before taking the bkp

SQL_Hunt wrote:
Hello,
Before migrating the databases to the new servers, if I need to make sure that all the pending transactions from the Replication queue logs are cleared, so that 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)

October 1, 2022 at 4:38 pm

#4094386
Reply To: Clearing the pending transaction from the Replication logs before taking the bkp

wrote:
This works really well for us, thank you!
Smells like a preamble to SPAM.
--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)

October 1, 2022 at 4:37 pm

#4094385
Reply To: Query plans

sqlguru wrote:
There is more than 1 plan for a particular query. I suspect it could be auto stats is sampling too low so enabling the persistent sampling. Any thoughts?
It could...
--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)

October 1, 2022 at 4:33 pm

#4094384
Reply To: Query plans

wrote:
A commitment of appreciation is all together for the method, it turned out just immeasurable for me moreover!
Yeah... I'm thinking pre-amble to SPAM here.
--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)

October 1, 2022 at 4:30 pm

#4094383
Reply To: TCP Provider: A connection attempt failed for target server

The first thing to do is to see what login the stored procedure was running under and then look at the settings for the linked server connection to see if...
--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)

October 1, 2022 at 4:29 pm

#4094382
Reply To: How Important is Software?

From the Article:
"I urge developers to have others look at what they present on the screen, and spend time learning from users, both experienced and novice. "
I've found 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)

October 1, 2022 at 4:20 pm

#4094381
Reply To: 2 almost identical queries (with a TVF) produce wildly different performance!

Thanks. That's just fascinating to me because I've never seen such a thing before.
Any chance of you posting the TVF so I can try to make an experiment that duplicates...
--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 30, 2022 at 5:57 pm

#4094103
Reply To: 2 almost identical queries (with a TVF) produce wildly different performance!

Since you're right there and have a handy test setup, I'd be curious what happens with the same query with the comments in the following form...
SELECT SUM(results)
/* comment1 */
/* comment2...
--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 30, 2022 at 2:33 pm

#4094029
Reply To: Why does antivirus stops I/O and SQL sees it as a full backup, during AV check

peter2501 wrote:
Hello,
We use Sentinel AV software. And yes, when disabled the entries for the FULL backups are gone as well.
Peter
Thanks, Peter. Lordy... that's a bit crazy. Apologies for asking and...
--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 30, 2022 at 2:21 pm

#4094021
Reply To: Insert data into multiple tables after each batch of 100000 rows

I also have to ask "WHY"? Why do you need to "batch" this instead of just doing all 2 million rows, which most servers can easily handle?
And the reason why...
--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 30, 2022 at 2:06 pm

#4094017
Reply To: backup practice/strategy/risks

Thanks, Jeffrey.
--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 29, 2022 at 11:33 pm

#4093734
Reply To: backup practice/strategy/risks

Interesting... Just one more question, please... have you ever done a restore to test all of that (including log files)? Knowing you, I'm sure you have but I've got 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 29, 2022 at 11:22 pm

#4093722

Viewing 15 posts - 2,686 through 2,700 (of 59,099 total)