Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,606 through 1,620 (of 59,082 total)

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
Reply To: Index rebuild / stats update taking lot of disk space.

Ant-Green wrote:
The 5% / 30% values that where "supposed" best practise are actually a "worst" practise.
BTW and just to be sure... I totally agree with that statement and so 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)

April 6, 2023 at 3:12 pm

#4170077
Reply To: Failover in Availability Group wipes data from sys.dm_db_index_usage_stats

askcoffman wrote:
Thanks for the reply Grant. I agree using this data must be used with caution. My goal now is to make the stored results more aware of these situations...
--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 3:05 pm

#4170074
Reply To: Domain Extension Splitting Based on Dot(.)

Thanks, Steve. Thank you for the feedback.
I'd also considered doing the REVERSE thing and using 4 CHARINDEXes, for such a few elements, it's usually faster than a splitter and re-pivoting,...
--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 2:53 pm

#4170073
Reply To: Domain Extension Splitting Based on Dot(.)

Your posted example is great but please Read'n'Heed the article at the first link in my signature line below for future posts for how to post "Readily Consumable" data 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 6, 2023 at 12:11 am

#4169740
Reply To: What is your opinion on Outsourcing?

GiaGlad wrote:
Just hire a skilled professionals or a company that can do back office task for you and you can just focus on your core operations.
I've found that to be...
--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 5, 2023 at 7:43 pm

#4169667
Reply To: SQL to set date/time period to 1600-1559 (dynamic)
Thom A wrote:
If you're on 2022 then you could use DATE_BUCKET:
```
WHERE YourDateTimeColumn >= DATE_BUCKET(DAY,1, GETDATE(), CONVERT(datetime,'19000101 16:00:00'))
  AND YourDateTimeColumn < DATEADD(DAY, 1, DATE_BUCKET(DAY,1, GETDATE(), CONVERT(datetime,'19000101 16:00:00')))
```
Another method...
--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 5, 2023 at 7:36 pm

#4169666
Reply To: Import DataBase from Access to SQL server 2014

Salwa wrote:
When doing (upsizing wizard), problems appeared in copy (sql server), so I deleted it and installed it again, and after I tried (import), it worked and the database 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)

April 5, 2023 at 7:21 pm

#4169661
Reply To: SQL AlwaysOn configuration completely disappear

onetsql,
Nice link. Thanks.
--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 5, 2023 at 2:26 pm

#4169537
Reply To: Tracking of Accounts data and Stored procedures

Grant Fritchey wrote:
I did attempt to import your bacpac, ...
I'll likely never make the attempt on these forums because it's not permanent to this forum. If it goes away, any answer...
--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 5, 2023 at 2:11 pm

#4169530
Reply To: reads for DMVs

Stephanie226 wrote:
vsamantha35 wrote:
Created a table in such a way, each rowsize is one 8K page.
Now when I execute this
SELECT T.name as 'Table', ix.index_id, ix.[name] AS IndexName, ix.type_desc AS IndexType, [ips].[index_level],...
--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 5, 2023 at 2:00 pm

#4169515

Viewing 15 posts - 1,606 through 1,620 (of 59,082 total)