Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,831 through 1,845 (of 59,082 total)

Reply To: slow performing query

vsamantha35 wrote:
RCSI is enabled for this database. However, writers are blocking writers. INSERTs and DELETE's,
Sometimes, even a good healthy dose of magic pixie dust can't break through a mountain of...
--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)

March 1, 2023 at 7:51 pm

#4155606
Reply To: Writing a line for each day of month???

jbalbo wrote:
I see ur point, but wouldn't I be safe if I ran it thru something like Ssrs using a date parameter?
In a word, No. There are much better ways...
--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)

March 1, 2023 at 1:33 am

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

frederico_fonseca wrote:
regarding https://www.sqlservercentral.com/forums/topic/writing-a-line-for-each-day-of-month
can someone post a link to an older thread the OP created that does what it's asking (again) to be given to them.
older thread is https://www.sqlservercentral.com/forums/topic/how-do-i-write-a-record-for-each-day-in-a-date-range
I can't reply...
--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)

February 28, 2023 at 11:13 pm

#4155224
Reply To: Writing a line for each day of month???

jbalbo wrote:
Thank You Michael,
The saddest part of the answer is I submitted the question 5 years ago!!! LOL!!!!
Shows how long I haven't used it...
Thanks Again
I recommend that you don't make...
--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)

February 28, 2023 at 10:58 pm

#4155220
Reply To: slow performing query

p.s. I also notice in one of your previous posts above that the table has 4 non-clustered indexes... that's likely where the page splits are coming from. Considering the very...
--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)

February 28, 2023 at 7:50 pm

#4155194
Reply To: slow performing query

vsamantha35 wrote:
Yes. Its a small table. Question is , when there is 0 rows in the table, and when we say SELECT * FROM <Tname> , why SQL Server 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)

February 28, 2023 at 7:44 pm

#4155193
Reply To: What is ChatGPT – Is it the rise of the Skynet era?

@eliob ,
Your post actually sounds like it was created by ChatGPT. 😀 And then we see the SPAM link that you included. 😀 So that others may learn, here's 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)

February 27, 2023 at 3:51 pm

#4154663
Reply To: Shifting from New Relic Monitoring to AWS Cloudwatch to save costs

Yeah... that's what I thought. First post was a "setup" for the spam. I left the original post so that people can see what one of these setups looks like.
--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)

February 27, 2023 at 3:43 pm

#4154659
Reply To: Will ChatGPT Write Our Queries?

I agree that ChatGTP operates from a "consensus of opinion that exists in the internet". While I'm equally impressed as Eric, that means that it's frequently seriously incorrect, just like...
--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)

February 27, 2023 at 2:45 pm

#4154629
Reply To: Arithmetic overflow error converting expression to data type smallint. The state
rajemessage 14195 wrote:
This is the code which is creating the problem (bridgid is bigint ,remaks is varchar(250) status smallint) in both the tables mentioned below.
```
 INSERT INTO KKR
...
```
--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)
February 27, 2023 at 12:07 am

#4154392
Reply To: Are senior SQL developer interview questions too difficult?
Previous post deleted.. I just realized that this is spam.
I also took a look at just one of the questions and answers (question 8)... I didn't look at all the...
- This reply was modified 3 years, 5 months ago by Jeff Moden. Reason: Sudden realization of what this post really 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)
February 25, 2023 at 1:53 am

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

Steve Jones - SSC Editor wrote:
... but there is a BBPress upgrade, that requires a WP upgrade, which depends on a PHP upgrade, which was held for an OS upgrade.
Good lord.
--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)

February 24, 2023 at 12:27 am

#4153517
Reply To: Microsoft Sql Server DBA Salary - Full time vs Contract

noob2023 wrote:
@JeffModen: I wasn't trying to spam - I just search for salary comparison and that site came up showing me the levels. That's why I referenced it.
Thanks for 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)

February 23, 2023 at 8:34 pm

#4153417
Reply To: Can't start SQL Server

I don't have an answer. "Bumping" this bad boy for you.
--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)

February 22, 2023 at 9:20 pm

#4152989
Reply To: Schedule a PowerBI dataset refresh on the "quarter" hour ???

sgmunson wrote:
That's handy, Michael, but we're not ready as a company to embrace the use of PowerShell. I'm going to create a new table that we can refresh via a...
--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)

February 22, 2023 at 8:53 pm

#4152975

Viewing 15 posts - 1,831 through 1,845 (of 59,082 total)