Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,461 through 5,475 (of 59,072 total)

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
Reply To: how to checkf if SQL Server CPU/RAM has bottleneck

892717952 wrote:
how to checkf if SQL Server CPU/RAM has bottleneck? thanks!
There are a ton of decent articles out there on this subject. You really need to do a little "googlin'". ...
--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 24, 2021 at 11:00 pm

#3861814
Reply To: SQL Server Agent issue

Mr. Brian Gale wrote:
Try changing the SQL Server Agent startup type to "automatic (delayed start)" to make it start after SQL Server.
This is what fixed us a long time ago. I just...
--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 24, 2021 at 10:50 pm

#3861810
Reply To: Statistics Update Frequency

Yeah... there's always something when it comes to stats. Like you said, ascending date columns can be quite the rub, as well. We have a whole lot of tables that...
--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 22, 2021 at 7:19 pm

#3860939
Reply To: Tool Limits

My original thought in response to this article is "It Depends on the 'tool' in the chair!" 😀
--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 22, 2021 at 4:13 pm

#3860870
Reply To: Tool Limits

pwhoyt wrote:
As an infrastructure guy and former consultant, one universal truth that I've observed over the years is the tendency for useful tools that are controlled locally to be replaced...
--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 22, 2021 at 4:12 pm

#3860868
Reply To: Copy tables from one db to another db

Don't give the privs to the user. Instead, write a stored procedure that uses EXECUTE AS OWNER and give the user privs to execute that stored procedure.
--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 22, 2021 at 4:09 pm

#3860865
Reply To: Working in a Distributed Fashion

In all seriousness, we've always worked in a "distributed fashion". And, yeah, databases are necessarily a bit different simply because of their size and the fact that they contain sensitive...
--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 22, 2021 at 3:27 pm

#3860846

Viewing 15 posts - 5,461 through 5,475 (of 59,072 total)