Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,071 through 2,085 (of 59,082 total)

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
Reply To: Case expression with NULL

Now THERE'S and SQL "Oolie" if I ever saw one! Nice job, Mr. Collins. And, yep, it IS clearly documented.
--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 1:45 am

#4140615
Reply To: Looking Back at Software Development Trends

Rod at work wrote:
This topic interests me intensely. I've been reading about software development trends for many years, with a view to improve myself and to suggest better ways for those 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)

January 23, 2023 at 1:27 am

#4140608

Viewing 15 posts - 2,071 through 2,085 (of 59,082 total)