Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,141 through 1,155 (of 59,072 total)

Reply To: Creating a subquery which conflicts with the where clause...

Sorry... second look at the code I posted said it was wrong and took it down.
--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 12, 2023 at 1:35 pm

#4285004
Reply To: index fragmentation basics

vsamantha35 wrote:
The intention was to know the reason do we need to bother about fragmentation for tables with 10's or few 100's of pages. I see dev team asking question...
--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 12, 2023 at 1:27 pm

#4285001
Reply To: Move DB

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Jonathan AC Roberts wrote:
If you are only moving the application databases (not the system databases). You can just detach the databases, move the database files to a different location 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)

September 11, 2023 at 9:36 pm

#4284446
Reply To: Sources of Inspiration

Just remember... your favorite bloggers may not actually be correct. 😉
--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 11, 2023 at 9:33 pm

#4284445
Reply To: index fragmentation basics

My recommendation is this... go to all of the BBFAATT (a "Moden-ism for Books, Blogs, Forums, Articles, AI, Talks, and 'Tubes and is pronounced as "bee-bee-fat" and can be bleated...
--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 11, 2023 at 8:32 pm

#4284421
Reply To: Rename-Item

As a bit of a sidebar, renaming backup files destroys the ability to use the backup information stored in MSDB for research. If you want to name something, it should...
--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 11, 2023 at 7:48 pm

#4284391
Reply To: How do I keep the cost of an Azure SQL Database down?

Rod at work wrote:
So, I've thought that what I could do is migrate one of the apps I'm responsible for, into an Azure instance, using my Visual Studio Subscription monthly credits.
My...
--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 11, 2023 at 7:06 pm

#4284388
Reply To: Move DB

Jo Pattyn wrote:
Link https://learn.microsoft.com/en-us/sql/relational-databases/databases/move-database-files?view=sql-server-ver16
I've found out the hard way in my early days that "Moving the Files" <> "Successfully moving the 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 11, 2023 at 5:21 pm

#4284323
Reply To: Move DB

Jonathan AC Roberts wrote:
If you are only moving the application databases (not the system databases). You can just detach the databases, move the database files to a different location then just Attach...
--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 11, 2023 at 5:17 pm

#4284322
Reply To: How to create a SQL Server presentation in 5 minutes using AI

Who who or what was it that wrote "Reorganizes or Rebuilds index to optimize data base performance"? The human author or the AI? 😀
Anyway, thanks for the article, Daniel. I...
--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 11, 2023 at 5:38 am

#4283946
Reply To: The Team You Want

DavidJParsons wrote:
If I am interviewing for a new position, I always ask if I can be shown round the office and see some of the team. Whether existing people are...
--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 10, 2023 at 7:55 pm

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

Dennis Jensen wrote:
Jeff Moden wrote:
Between that and the GENERATE_SERIES() defeating Minimal Logging (article coming out on that on the 18th) and the DATETIME rounding issues into the next day that started 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)

September 10, 2023 at 7:51 pm

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

Sorry. Post deleted.

--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, 2023 at 10:09 pm

#4283331
Reply To: Move DB

@Frederico,
As you know, MS doesn't make it easy to find the correct documentation for doing certain things. Do you have a link that might help the OP out?
--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, 2023 at 5:05 pm

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

Good Lord! I've got more testing to do but I ran a simple "Tally CTE Function" test in 2017 and 2022 on my laptop. The results are REALLY disappointing.
--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, 2023 at 4:49 pm

#4283217

Viewing 15 posts - 1,141 through 1,155 (of 59,072 total)