Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,136 through 3,150 (of 59,067 total)

Reply To: Quantums

Heh... Lordy. How did I remember this? It's definitely an SQL "Oolie".
--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 22, 2022 at 5:41 am

#4066732
Reply To: The Limited Cloud

Ah... awesome. Thanks for the links, Eric.
--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 21, 2022 at 9:17 pm

#4066628
Reply To: A Culture That Allows Mistakes

I have a friend DBA where there's no real blame for anything and that's good but there's no real push to get smarter about things, either. They're going through 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 21, 2022 at 4:52 pm

#4066535
Reply To: Performance problem

Grant Fritchey wrote:
wrote:
How fix SQL performance issues? Start by checking your wait stats
2-Make sure you're running index maintenance frequently.
Everything Jeff said.
But, one exception, columnstore indexes. Reorganization and rebuild do...
--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 21, 2022 at 4:40 pm

#4066533
Reply To: How to compare a list of numbers, kind of like lottery results

wrote:
Hey there!
Each winning/drawn number has its own row, however you would probably unpivot the data in both tables so that you have a key for which group of numbers...
--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 21, 2022 at 4:34 pm

#4066531
Reply To: The Limited Cloud

Eric M Russell wrote:
Steve Jones - SSC Editor wrote:
licensing is extra confusing in the cloud. Sometimes licensing is included in an Azure SQL, sometimes not. You could easily be double licensed as not licensed at all
Azure...
--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 21, 2022 at 1:31 pm

#4066451
Reply To:

wrote:
Does anyone know any good database archive software/tools out there?
We are looking into a tool that will archive data off of the OLTP databases into an archive database. 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 20, 2022 at 2:04 pm

#4066001
Reply To: Scanning on different Index

What is the datatype of @P8? If it's not NVARCHAR(), it will ALWAYS do an index SCAN because it first has to convert all of the rows in the entire...
--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 20, 2022 at 1:58 pm

#4065971
Reply To: Parsing a lange XML data-column from one server to another

Just an opinion but using XML to transfer data between servers seems counter productive to me. Instead, I'd have a common area that all the servers could write to 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)

July 19, 2022 at 3:12 pm

#4065357
Reply To: The Limited Cloud

You also have to remember about licensing of SQL Server on spin-ups. I've never seen anything written about that but, disclaimer, I've not looked for such a thing. I only...
--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 19, 2022 at 3:01 pm

#4065355
Reply To: Slow performance after the upgrade

Chitown wrote:
After changing just the compatibility level, queries are running efficiently. Thanks all...
That also means that you may be missing out on some newer technology in the database engine. 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 19, 2022 at 2:51 pm

#4065350
Reply To: Parse SQL data

Steve Collins wrote:
To split out the pd_id's you could try STRING_SPLIT to separate based on space delimiter. Since some 'PD-[0-9]' values are encompassed by other extra characters a conditional substring 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)

July 19, 2022 at 2:58 am

#4065077
Reply To: how to call a scalar function without schema in sqlserver 2019

rajemessage 14195 wrote:
i understood in case of storedporcedure , but in case of the function.
I logged in using the user "login s2" then executed the function "s1.xyz" which is in schema...
--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 17, 2022 at 9:46 pm

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

Grant Fritchey wrote:
Question for the smart people, and the rest of you.
Would you endorse or get behind the statement: Some deadlocks are healthy. or Some level of deadlocks is healthy.
Or 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)

July 17, 2022 at 5:51 pm

#4064496
Reply To: Merge Replication or Back up and Restore

p.s. There's no way that I'd take all the time to upgrade 2012 to 2019. 2019 is already 3 years old and 2022 has some fairly handy new things 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)

July 17, 2022 at 4:14 pm

#4064482

Viewing 15 posts - 3,136 through 3,150 (of 59,067 total)