Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,766 through 6,780 (of 59,102 total)

Reply To: Change color scheme for Admin account in SSMS

pietlinden wrote:
I was reading one of Brent Ozar's posts about SSMS, and he was talking about "never use the sa/admin account unless you need to", so I was wondering if...
--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)

July 21, 2020 at 11:05 pm

#3771920
Reply To: A faster way to parse QueryPlan XML???

Wouldn't it be easier to take a snapshot of sys.dm_db_index_usage_stats from one day till the next and do a comparison? The added benefit here is that it includes indexes from...
--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)

July 21, 2020 at 11:00 pm

#3771914
Reply To: Trying to Make combinations within a bracket in SSMS column
carsten.saastamoinen wrote:
```
CREATE TABLE dbo.t
(
    TxtVARCHAR(8000)
);

INSERT dbo.t (Txt) VALUES
('A[CL]'),
('B[HQUW]'),
('C[1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ]'),
('D2'),
('E[1]');
GO
WITH Result
AS
(
SELECTLEFT(Txt, 1) AS Constant,-- all strings with [...]
SUBSTRING(Txt, 3, 1) AS Variable,
SUBSTRING(Txt, 4, LEN(Txt) - 4)...
```
--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)
July 21, 2020 at 7:36 pm

#3771858
Reply To: Table Partition in Sql Server

Strong second to Grant's post.
I'll also add that partitioning a table can actually make performance worse like it did for me but was acceptable because of what I was trying...
--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)

July 21, 2020 at 7:10 pm

#3771854
Reply To: SQL Query Help - CHARINDEX

I've been through this more times than I can shake a stick at. With the utmost respect for those that provided them, none of the solutions offered are SARGable and...
--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)

July 21, 2020 at 1:25 am

#3771619
Reply To: Rebuild or Reorganize index

ScottPletcher wrote:
Erland Sommarskog wrote:
But, yes, depending in which way your index is disorganised, REORGANIZE can mean a lot of operations, as it performs a bubble sort of the file.
I don't think...
--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)

July 21, 2020 at 1:11 am

#3771618
Reply To: Changing Computer Retail

Ralph Hightower wrote:
Ah, nostalgia. I miss BYTE magazine.
And "Computer Shopper".
--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)

July 20, 2020 at 1:39 pm

#3771326
Reply To: Loading 20% of an index in to memory to get a small % of the table's data

Actually, 100% can be generated using a little dynamic SQL, sys.columns, and sys.indexes. I wrote some code for work that people are using. I'll see if I can find 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)

July 20, 2020 at 12:56 pm

#3771300
Reply To: Rebuild or Reorganize index

Man, thanks for the example, Erland. Great stuff and timely, as well. We just installed some 3rd party software where they required the database the software uses to be snapshot...
--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)

July 19, 2020 at 4:12 pm

#3771154
Reply To: Rebuild or Reorganize index

Erland... Before I spend a lot of time looking for it, do you have a link handy that talks about that problem?
--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)

July 18, 2020 at 11:25 pm

#3771111
Reply To: Rebuild or Reorganize index

Erland Sommarskog wrote:
Another thing, I that I did not observe until today, which is a quite important difference is this: If you have any form or snapshot enabled (and that includes...
--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)

July 18, 2020 at 11:19 pm

#3771110
Reply To: SSMS v.18 slow? Is it me or....?

imgn8sn wrote:
I also have been having so many issue with SSMS load times, 30 seconds or more to refresh Tables list, or to Edit table, right-click and wait a life...
--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)

July 18, 2020 at 9:13 pm

#3771102
Reply To: spill to tempdb problem

zamani 41951 wrote:
Friends, I've reached to a good improvement.
I destroyed fragmentation for table Groups_Roles Table. Result was very good. My goal procedure removed from SQL Serve Profiler with more than 3...
--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)

July 18, 2020 at 8:40 pm

#3771101
Reply To: spill to tempdb problem

zamani 41951 wrote:
I've removed PK of LegalReferrence Table. Logical Read reduced for this table very good.
I'm thinking the reason why that worked is simply because that caused a rebuild of related...
--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)

July 18, 2020 at 8:39 pm

#3771100
Reply To: Practice identifying results from dml queries

Phil Parkin wrote:
dbgaragedays wrote:
Identifying results meaning...
Given a sample database schema and DML query provided, I have to come up with the results of the sample query.
This is a section of 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)

July 18, 2020 at 8:07 pm

#3771098

Viewing 15 posts - 6,766 through 6,780 (of 59,102 total)