Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,476 through 5,490 (of 59,089 total)

Reply To: How to ALTER COLUMN without SELECT and UPDATE permissions

It's an amazing thing... I've been working with SQL Server since before SQL Server 7 came out and it just dawned on me that I've never tried to alter 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)

March 27, 2021 at 8:50 pm

#3862777
Reply To: SQL Server 2008 R2 Audit Log

veeramani-408723 wrote:
In my sql server instance I renamed 'sa' account and disabled. I confirmed no sa account. I configured server side audit log and I can see some sa activities....
--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 27, 2021 at 1:58 pm

#3862706
Reply To: How to ALTER COLUMN without SELECT and UPDATE permissions

Hi Pete,
This is interesting. I've never seen such a thing before. The reason for my question is I'm looking for something else that might be causing this problem 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)

March 27, 2021 at 1:44 pm

#3862704
Reply To: How to ALTER COLUMN without SELECT and UPDATE permissions

Does 'tablename' in the errors you're getting match the tablename in the ALTER TABLE statement?
--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 27, 2021 at 1:08 am

#3862596
Reply To: Query Issues - pageiolatch_sh wait high clustered index insert cost

PebbleRock978 wrote:
Hi
Accidental DBA here
We have an application that runs a select * on a table upon starting the application. There are 2.4 million rows in the table. Today it was...
--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 26, 2021 at 3:59 pm

#3862461
Reply To: Global Git Ignore

BWAAAA-HAAAA-HAAA!!! Great title... and that's exactly what I'm doing! 😀
--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 26, 2021 at 7:51 am

#3862318
Reply To: Question on BCP

itmasterw 60042 wrote:
HI Jeff,
I apricate your wanting to know I did not want to bother you with it, but I would like to get the SSIS to work. As I said...
--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 26, 2021 at 2:02 am

#3862259
Reply To: group parts by row count

Crud... I went to hit QUOTE and, instead, hit REPORT by mistake. My apologies, Joe. I'll contact the webmaster and let them 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)

March 26, 2021 at 1:27 am

#3862255
Reply To: group parts by row count

Your code fairs no better, Joe. Try running it and see the error.
Also, the columns in your CREATE TABLE statement don't match the columns in your SELECT statement.
And, your code...
--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 26, 2021 at 1:24 am

#3862253
Reply To: Question on BCP

If you avoid "batching", it can be done with "minimal logging", which also nearly doubles the performance.
--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 25, 2021 at 8:47 pm

#3862173
Reply To: Count Null Records with Group BY

The title of this thread threw me... I thought we were trying to count the NULLs in a given column... which is different than the original script, 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)

March 25, 2021 at 8:28 pm

#3862171
Reply To: group parts by row count

Heh... you didn't try the code you posted. It's missing commas and the VALUES are not correct.
Be advised that the data you posted has nothing other than partid and serial...
--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 25, 2021 at 6:02 pm

#3862107
Reply To: Question on BCP

I believe you'll find that and INSERT/SELECT from an OPENQUERY across a linked server will work with some pretty good performance.
--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 25, 2021 at 5:33 pm

#3862103
Reply To: Count Null Records with Group BY

Wouldn't it be easier just to take the difference between the count of a column that will never be NULL (like the PK column) and the column in question?
--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 25, 2021 at 5:17 pm

#3862099
Reply To: Your Code Is Your Standards

The typical reason why there are typically no standards, particularly when it concerns databases and the related code, is because of the "code first" mentality that I've seen at oh...
--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 25, 2021 at 5:00 pm

#3862083

Viewing 15 posts - 5,476 through 5,490 (of 59,089 total)