Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,576 through 1,590 (of 59,067 total)

Reply To: SQL to set date/time period to 1600-1559 (dynamic)

Thom A wrote:
That (now removed) ChatGPT "solution" was amazing garbage...
I saw that post and I wish they hadn't deleted it as "spam"... it provided an excellent example of just how bad...
--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)

April 10, 2023 at 12:32 am

#4171398
Reply To: Indexing Tables

frederico_fonseca wrote:
water490 wrote:
if this is why you do it then a index reorg is needed ONLY to cleanup the deletes and recompress the deltastores. see https://www.red-gate.com/simple-talk/databases/sql-server/performance-sql-server/hands-on-with-columnstore-indexes-part-3-maintenance-and-additional-options/ for further info
Just 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)

April 10, 2023 at 12:14 am

#4171389
Reply To: Blocking query

vsamantha35 wrote:
Jeff Moden wrote:
From the nature of some of the code, it looks like all parameters are being passed as NVARCHAR(4000).
It doesn't matter how well code may be written, that generally...
--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)

April 9, 2023 at 1:44 am

#4171115
Reply To: Blocking query

ScottPletcher wrote:
Of course we don't know the proc parameter types, nor the column types, but I think those are critical to properly understanding whether or not SQL can properly use...
--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)

April 9, 2023 at 1:41 am

#4171114
Reply To: Blocking query

From the nature of some of the code, it looks like all parameters are being passed as NVARCHAR(4000).
It doesn't matter how well code may be written, that generally means 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)

April 8, 2023 at 5:41 pm

#4171023
Reply To: What are some SQL commands that data scientists should be familiar with ?

Please understand that, due to the nature of your question, I believe this post is the first of one-two spam punch.
If you are not a spammer or a bot, then...
--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)

April 8, 2023 at 5:23 pm

#4171013
Reply To: Indexing Tables

water490 wrote:
Jeff Moden wrote:
You cannot do INCLUDEs on Clustered Indexes, period. The reason why is that the Clustered Index IS the table and it already includes all the data.
I posted 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)

April 8, 2023 at 3:13 pm

#4170978
Reply To: database schema and permissions

@lan2022nguyen ,
Thank you for the feedback.
--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)

April 8, 2023 at 2:56 pm

#4170977
Reply To: Indexing Tables

You cannot do INCLUDEs on Clustered Indexes, period. The reason why is that the Clustered Index IS the table and it already includes all the data.
I posted a link further...
--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)

April 8, 2023 at 4:45 am

#4170815
Reply To: Keeping Things Running

Speaking of volunteers, the Ohio North SQL Saturday (formally SQL Saturday Cleveland) by the Ohio North Data Training group (formally, a PASS group that continues because of people like Grant...
--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)

April 8, 2023 at 3:56 am

#4170800
Reply To: database schema and permissions

I've not ever had to do this before. I started at sys.schemas and worked by way up to the other two sys views but, like I said, I've not done...
--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)

April 8, 2023 at 2:48 am

#4170790
Reply To: Performance Tuning with SQLFacts Tools

Wingenious wrote:
There are three text files of documentation (about 100K total), including one titled README that tells what the code is supposed to do.
Ah. Got it. Thanks.
You might want 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)

April 8, 2023 at 12:32 am

#4170762
Reply To: Performance Tuning with SQLFacts Tools

First, let me say that I have a grand and genuine appreciation for people that write tools and share them.
I don't, however, have an appreciation for code that doesn't even...
--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)

April 7, 2023 at 4:30 pm

#4170604
Reply To: How to get top 100 values of a col concatenated in a variable in sqlserver?

@rajemessage ,
I've found that most people that want to know how to do this are solving a problem the wrong way. What is the end use of this concatenated string...
--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)

April 6, 2023 at 5:59 pm

#4170160
Reply To: Index rebuild / stats update taking lot of disk space.

Arsh wrote:
@AG , It was running as legacy. I just took over..I have removed 'Index Maint' from the activities..and also i m not getting any complaints on performance, suggesting ,...
--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)

April 6, 2023 at 5:45 pm

#4170155

Viewing 15 posts - 1,576 through 1,590 (of 59,067 total)