Jeff Moden

Forum Replies Created

Viewing 15 posts - 541 through 555 (of 59,069 total)

Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Ah, double spacing. Forgot about that. The quoting is a real annoyance as well.
So, are you leaving all of this up to us to contact @marketing, etc?
--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)

June 3, 2024 at 2:03 pm

#4425918
Reply To: On Being an "Expert"

IMHO, true experts have enough knowledge about a particular subject to know when they don't know something about that subject and aren't afraid to say so. Saying "I don't know"...
--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)

June 1, 2024 at 10:43 pm

#4425639
Reply To: Enhancing Web Application Performance through Database Optimization: A Comprehensive Study

Lordy... even that response seems artificial, especially considering that the author supposed posted that response. Doesn't pass the "Turing Test", IMHO.
I also expected to see some actual data in 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)

May 31, 2024 at 9:04 pm

#4425483
Reply To: How to change password

Go to your first post above.
Click on your name. That will take you to a different screen at the top level of your profile.
Click on "Edit Profile".
Follow your nose 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)

May 30, 2024 at 3:43 am

#4424815
Reply To: Enhancing Web Application Performance through Database Optimization: A Comprehensive Study

I have to ask... are the middle two letters in the author name indicative of what wrote this article?
--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)

May 30, 2024 at 3:30 am

#4424814
Reply To: DB stuck in restoring state
LearningDBA wrote:
ALTER DATABASE MyDB SET OFFLINE WITH ROLLBACK IMMEDIATE;
RESTORE DATABASE MyDB FROM DISK = 'D:\Backup\MyDB.bak' WITH REPLACE, STATS = 10;
Restore command
Interesting. I've never using the SET OFFLINE...
--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)
May 30, 2024 at 3:02 am

#4424809
Reply To: DB stuck in restoring state

Please obfuscate the database name and then post the exact command(s) you're using to do the restore.
--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)

May 29, 2024 at 11:54 pm

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

Brandie Tarvin wrote:
Quick interuption: 5+ gallons of blueberries from my bushes. First picking. And oh, do they taste good.
More berries to come in a few weeks, possibly just as many.
What 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)

May 29, 2024 at 11:49 pm

#4424789
Reply To: What is new in Copilot, the new features available

Jonathan AC Roberts wrote:
Jonathan AC Roberts wrote:
Jeff Moden wrote:
Here's just one of the many proofs... Both the direct conversion from DATETIME2 to DATETIME and the faulty answer above produce the "silent failures" that I'm...
--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)

May 27, 2024 at 11:26 pm

#4424307
Reply To: What is new in Copilot, the new features available

Jonathan AC Roberts wrote:
Just out of interest, what is the method you use for converting a DATETIME2 value to a DATETIME?
I thought I had a good one but then found a "silent...
--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)

May 27, 2024 at 6:00 pm

#4424259
Reply To: What is new in Copilot, the new features available

Jonathan AC Roberts wrote:
Yes, well ChatGPT generates its responses one word at a time, using each preceding word and the context of the conversation, including its own partially completed sentences, to predict...
--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)

May 27, 2024 at 3:30 pm

#4424221
Reply To: What is new in Copilot, the new features available

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Heh... ask it how to convert a DATETIME2 value to a DATETIME value in SQL Server. 😉
I haven't got Copilot, but I thought I'd try it on ChatGPT
--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)

May 27, 2024 at 3:07 pm

#4424216
Reply To: What is new in Copilot, the new features available

Heh... ask it how to convert a DATETIME2 value to a DATETIME value in SQL Server. 😉
--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)

May 27, 2024 at 3:20 am

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

Steve Jones - SSC Editor wrote:
.
I don't see any other big bugs...
Post links that go to the wrong post because spam notifications are no longer considered to be posts and are not counted 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)

May 27, 2024 at 2:55 am

#4424120
Reply To: Table partitioning best practice
All of the other folks have brought up great points on this thread and there's really nothing to add. To emphasize, though...
1. Partitioning does not improve query performance and will...
--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)
May 24, 2024 at 12:13 am

#4423653

Viewing 15 posts - 541 through 555 (of 59,069 total)