Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 59,067 total)

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, 3 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
Reply To: Employee Overtime Design

spilo wrote:
Hi, thank you for your replies.
We already have a legacy software to keep track of time/attendance. But it has some limitations.
It can monitor employee hours, absence , overtime, etc.
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 22, 2023 at 7:01 pm

#4152940
Reply To: Pagesplits question

vsamantha35 wrote:
Thanks Jonathan. A followup question, why shouldn't care about index fragmentation on indexes which has 1000-5000 page count ? I have read somewhere or some video, i dont remember. ...
--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 6:46 pm

#4152930
Reply To: Allowing non-sysadmin user access to xp_cmdshell via Certificates

Just to be sure....
For the love of all that is holy in SQL Server, do not give individual users privs to execute xp_CmdShell in an unsupervised manner. Have them write...
--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 6:08 pm

#4152911
Reply To: BULK INSERT PROBLEM for CAV file

Awesome and thank you kindly for the feedback. Nicely done on your part, as well.
--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 5:12 am

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

If this isn't a prelude to spam (like I think it may be), then don't target salary... target what you like to do because you're going to have to do...
--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 2:09 am

#4152581

Viewing 15 posts - 1,816 through 1,830 (of 59,067 total)