Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,086 through 2,100 (of 59,099 total)

Reply To: DB Size

It sounds to me like the database was defined that large to begin with. And, no... SQL Server doesn't reduce the file size when data is deleted, either.
--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)

January 30, 2023 at 2:21 am

#4143086
Reply To: ROUND or CONVERT the output of the POWER function

And do remember that the resulting number is actually huge coming in at E33 and isn't just 3.97. Because of that, I'm seriously doubting this whole formula... especially since 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)

January 29, 2023 at 5:40 pm

#4143021
Reply To: Blocking by select against sys.dm_db_index_physical_stats

Josh B wrote:
Ran a test after enabling TF 692 and continued to see blocking by the select against sys.dm_db_index_physical_stats, unfortunately.
Ooooo lordy. My apologies for missing your reply to your now 3...
--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)

January 28, 2023 at 4:22 pm

#4142819
Reply To: ROUND or CONVERT the output of the POWER function

Not being a math genius by any means, I'm still deeply interested in what the formula solves for?

--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)

January 28, 2023 at 12:39 am

#4142627
Reply To: ROUND or CONVERT the output of the POWER function

NM... Jonathan pulled it off mathematically. (Nicely done, Jonathan!!!)
I'd still like to know what question the math resolves. Thanks.
p.s. I know all the gazintas that Jonathan used to solve 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)

January 27, 2023 at 11:02 pm

#4142609
Reply To: Weird Log Backup Failure message

Lee Linares wrote:
I found the same error message in the SQL Error log on 3 dozen different SQL 2019 Standard instances. The message was:
BACKUP failed to complete the command BACKUP LOG...
--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)

January 27, 2023 at 7:22 pm

#4142552
Reply To: Roles in cluster

PJ_SQL wrote:
Hello!
When we failover one node from another, does the roles from the node failover to another node too?
Thanks
Test it. Even if someone says "yeah", you MUST test it!
I'd also...
--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)

January 27, 2023 at 7:14 pm

#4142551
Reply To: what does the backup log init do?

vpmaciel wrote:
what does the backup log init do?
It compels me to point out that folks should read the documentation. 😀 Here's the link...
https://learn.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?#-noinit--init-

--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)

January 27, 2023 at 7:11 pm

#4142550
Reply To: Interview Question

Since the interviewer specifically stated "what if the developer does any typo error", I'm thinking he was looking for the "mapping table" that Phil spoke of in his post.
That 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)

January 27, 2023 at 4:46 pm

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

Yeah... there's the other part of a 2 part SPAM thread.
--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)

January 24, 2023 at 8:14 pm

#4141386
Reply To: How to Reseed an Identity Column on Temp Table After data has been removed

To be honest, I'll never understand the idea of creating a Temp Table and then deleting rows from 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)

January 23, 2023 at 11:50 pm

#4141009
Reply To: Exit Lines

citrowske wrote:
I was at a company that hired a new IT director. He made it very clear at the beginning that he wanted to bring in his own people, so...
--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)

January 23, 2023 at 7:22 pm

#4140929
Reply To: Conventions when writing queries/stored procedures

jcelko212 32090 wrote:
I wrote an entire book on this topic, based on the work I did at AIRMICS. Look at ISO-11179 and the Metadata Committee stuff. We found that with good...
--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)

January 23, 2023 at 7:18 pm

#4140928
Reply To: How to Reseed an Identity Column on Temp Table After data has been removed

If the looping is necessary, just add a column (maybe call it ProcessOrder) to the temp table and populate it with ROW_NUMBER() OVER (ORDER BY ID).
--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)

January 23, 2023 at 5:45 pm

#4140892
Reply To: Conventions when writing queries/stored procedures

Thom A wrote:
Jeff Moden wrote:
Also, to support Thom on his claim that 3 and 4 part naming has been deprecated, take a look at the following article written by a really smart...
--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)

January 23, 2023 at 5:32 pm

#4140890

Viewing 15 posts - 2,086 through 2,100 (of 59,099 total)