Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,406 through 6,420 (of 59,072 total)

Reply To: CONVERT COLUMN VALUES TO COMMA SEPARATED ONE ROW VALUE..

drew.allen wrote:
PS: You do realize that this thread is almost six years old.

An updated answer to an old question is still a good thing. Someone has already benefited from it.
--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)

September 15, 2020 at 9:45 pm

#3788694
Reply To: CONVERT COLUMN VALUES TO COMMA SEPARATED ONE ROW VALUE..

You've posted in a 2005 forum. What version of SQL Server do you actually have?
--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)

September 15, 2020 at 7:55 pm

#3788669
Reply To: Wanting to learn

Grant and many others will seriously disagree with me but... My recommendation is that you don't spread your learning too thin. I've found that a whole lot of what people...
--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)

September 15, 2020 at 7:41 pm

#3788667
Reply To: The Challenges of Splitting a Table

I think the first step towards "vertical partitioning" is actually "proper normalization of a table".
I also think that people that have the following 3 columns (as identified in the Reddit...
--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)

September 15, 2020 at 4:18 pm

#3788599
Reply To: How do I utilise fewer cores?

Rhys wrote:
Hi - I would like to decrease the performance of SQL for certain users or specific queries.
The majority of users will be running very quick queries that last less...
--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)

September 15, 2020 at 3:53 pm

#3788587
Reply To: Writing a software development Proposal.

Brian hit a nail on the head that I totally forgot about and that's to be sure you include what he said about support, what's supported or not, and 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)

September 15, 2020 at 3:48 pm

#3788586
Reply To: Sql Queries

I could be wrong but most of the code looks like it takes in some form of CSV and splits it. Since you're using SQL Server 2019, lookup the STRING_SPLIT...
--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)

September 15, 2020 at 3:41 pm

#3788584
Reply To: restore from azure blob
Johan Bijnens wrote:
- Can you show the result of
```
Restore HeaderOnly from url= ... ?
```
  ?
- Keep in mind 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)
September 15, 2020 at 3:32 pm

#3788577
Reply To: Complex Join

I'm not talking about ISNULL speeding anything up, Scott. I'm talking about the use of a Clustered Index slowing things down. I'll try to come up with an example other...
--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)

September 14, 2020 at 2:47 pm

#3788337
Reply To: Writing a software development Proposal.

Write a section that identifies the purpose/problem this will solve. (Problem Overview)
Write a section on how the spreadsheets, etc, will solve the problems. If you have additional advantages, such as...
--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)

September 14, 2020 at 4:00 am

#3788175
Reply To: How to write query for multiple rows into a single row for different columns

That should do it, Mr. Williams.
--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)

September 14, 2020 at 3:48 am

#3788174
Reply To: Can't delete auto created statistics on SQL Server 2019

kaluza wrote:
Hi,
my problem was, that I have been connected to the wrong datebase with mit script.
Thank you very much for your help.
Thanks for the feedback and pretty darned honest of...
--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)

September 13, 2020 at 12:55 am

#3788115
Reply To: Automation is a Key Skill for the Modern DBA

Automating things has always been a key skill of good DBAs and, so far as I'm concerned, has absolutely nothing to do with "DevOps", which is becoming a more 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)

September 12, 2020 at 7:36 pm

#3788103
Reply To: Retrieving the total number of records in a SQL instance

tarr94 wrote:
Hi Jeff,
I was asked to pull this information because our cyber insurance company wants an approximation of the total number of rows across all SQL instances. I imagine this...
--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)

September 12, 2020 at 12:51 am

#3788041
Reply To: Remote Work Benefits

amy.holzinger wrote:
My office let me bring home an additional monitor when they sent me home to work. Very helpful! However, after 9 weeks my home office chair was giving me...
--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)

September 12, 2020 at 12:03 am

#3788037

Viewing 15 posts - 6,406 through 6,420 (of 59,072 total)