Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,966 through 4,980 (of 59,089 total)

Reply To: Let SQL profiler and Extended event can't capture the sql statement.

Mr. Brian Gale wrote:
I read your question a little differently than Grant and Jeff...
I didn't read it that way so went back and read it again... and, yeah... I agree... you might...
--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 12, 2021 at 10:57 pm

#3907162
Reply To: Create a View with Index

robertopmorris wrote:
I use a common table expression to produce a list of bill of materials but this slows down due to lack of an index - can this be done?
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)

July 12, 2021 at 4:48 pm

#3907063
Reply To: Let SQL profiler and Extended event can't capture the sql statement.

I've found that the biggest reason for SQLProfiler not capturing items is someone writing the wrong filter.
--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 12, 2021 at 4:33 pm

#3907061
Reply To: Index fragmentation on all databases

Heh... I make mistakes of that nature prior to having at least 2 full 12 oz mugs of coffee. That means it's been happening a whole lot to me lately...
--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 12, 2021 at 4:29 pm

#3907058
Reply To: Index fragmentation on all databases

Rune Bivrin wrote:
You know, I kind of prefer the kinds of questions where there is a way to answer the question 😀
This wasn't someone posting a question. This site allows folks...
--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 12, 2021 at 2:42 pm

#3907021
Reply To: text column in date format in excel to datetime column in sql server via SSIS

Jeffrey Williams wrote:
Since SSIS is not SQL - it isn't the same - and the code is not processed as SQL code. Since the data is in the file - 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)

July 11, 2021 at 10:04 pm

#3906762
Reply To: Cursor replacement suggestions

Go back to your first post... see that cursor definition you posted? Yeah... we need to know what you're trying to do with the data that cursor gathers. We don't...
--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 11, 2021 at 9:57 pm

#3906761
Reply To: Split String into columns
Jeffrey Williams wrote:
Here is a little different take on the solution:
```
 Select [Code]        = ltrim(substring(v.Item, 1, p01.pos - 2))
  ...
```
--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 11, 2021 at 9:04 pm

#3906752
Reply To: Split String into columns
Steve Collins wrote:
Similar to the accepted solution but without the common table expression. It appears Jeff began to code it one way and then switched
```
select max(case when sp2.ItemNumber=1...
```
--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 11, 2021 at 7:28 pm

#3906742
Reply To: Do We Need to Learn Linux?

Heh... "Do We Need to Learn Linux?"
I guess the obvious joke here would be "GOOD SIR!!! CONTAIN YOURSELF!!!"

--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 10, 2021 at 11:21 pm

#3906577
Reply To: Permissions needed to run query on master db

My take on it all this is not only "No" but "Hell No".
First of all, it would be a security violation to have a bunch of "unknowns" running a bunch...
--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 10, 2021 at 9:25 pm

#3906541
Reply To: Rows to Column
Thank you for the readily consumable test data. Details for one solution are in the comments in the code below...
```
--===== One solution.
     --...
```
--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 10, 2021 at 8:25 pm

#3906528
Reply To: text column in date format in excel to datetime column in sql server via SSIS
I don't know much about SSIS but there MUST be some easy way to do the following in SSIS just like it's easy in T-SQL.
```
  ...
```
--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 10, 2021 at 7:38 pm

#3906511
Reply To: Split String into columns
```
--===== Test string 
DECLARE @String VARCHAR(8000) = 
' ;T41,Vending,9000011;T42,Laundry,9000012;T43,Car Wash,9000013;T44,Amusement,9000014;T45,Promotion,9000015;T46,Transit,9000016;T47,Other,9000017;T73,?,9000011'
;
--===== Solution
   WITH cteSplit1 AS
(--==== Split the groups out based on the ";" delimiter, not returning...
```
--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 9, 2021 at 5:18 pm

#3906151
Reply To: Clustered vs Nonclustered Columnstore Update Performance

MadOwl wrote:
Add to that that we have ~4000 tables to maintain...
Are they mostly ColumnStore or RowStore?

--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 9, 2021 at 4:45 pm

#3906144

Viewing 15 posts - 4,966 through 4,980 (of 59,089 total)