Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,936 through 4,950 (of 59,071 total)

Reply To: Importing a CSV into SQL Server Shouldn't Be This Hard

As strange as it may strike some, I've not even downloaded DBATools, yet. I'm sure it's documented on the site one way or the other but, just to ask 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 14, 2021 at 4:20 am

#3907650
Reply To: Configure DBMail to send the email to a local folder?

Actually, the email system in SQL Server is quite robust and a copy of every email is stored in the msdb.dbo.sysmail_allitems table. In fact, it's a bit of a pain...
--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 13, 2021 at 5:23 pm

#3907467
Reply To: Create a View with Index

That would be an rCTE (Recursive CTE). If the recursion in based on incremental values and RBAR proceessing, a well written WHILE Loop will be faster and less resource intensive.
--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 13, 2021 at 2:00 pm

#3907406
Reply To: Create a View with Index

robertopmorris wrote:
Apologies - I'm not sure what you mean - there is no cte in the above SQL statement.
Actually, there are 3. The first one starts right after the word...
--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 13, 2021 at 1:41 pm

#3907394
Reply To: Create a View with Index
robertopmorris wrote:
```
WITH SubQuery AS
(
SELECTjh.Company, jh.JobNum, ja.AssemblySeq, jo.OprSeq, jo.OpCode, 
            CAST(CASE WHEN NOT jh.Date03 IS NULL 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)
July 13, 2021 at 1:37 pm

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

WebTechie wrote:
I do appreciate all of the feedback. However, you are fussing at the DBA who is the low man on the totem pole. AVPs and managers have already made...
--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 13, 2021 at 2:32 am

#3907202
Reply To: Excessive run time

To be honest, this sounds like a case of the bad type of parameter sniffing.
--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 11:42 pm

#3907174
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

Viewing 15 posts - 4,936 through 4,950 (of 59,071 total)