Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,046 through 9,060 (of 59,067 total)

Reply To: Are the posted questions getting worse?

TomThomson wrote:
Grant Fritchey wrote:
Chris Harshman wrote:
I don't trust anyone... not even myself! 🙂
My name is Grant Fritchey and I endorse this message. Except I'd change it slightly: I don't trust anyone......
--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, 2019 at 1:56 am

#3661821
Reply To: Filegroups, data files best practices?

Lordy. I, unfortunately, found what I was looking for at item #12 at the following URL...
https://www.mssqltips.com/sqlservertip/1875/best-practices-when-using-filestream-feature-of-sql-server/
... which states...
Disable antivirus software from scanning FILESTREAM volumes if it's not mandatory within...
--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, 2019 at 1:18 am

#3661817
Reply To: Filegroups, data files best practices?

Never mind... I looked it up. It would appear that if you allow it, the files become a part of the backups... basically, using SQL Server to backup part 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)

July 10, 2019 at 11:58 pm

#3661798
Reply To: Filegroups, data files best practices?

Grant Fritchey wrote:
My experience with, and knowledge, filestream is somewhat limited, so I'm hesitant to pronounce too strongly on this approach. I do know that files within databases leads to all...
--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, 2019 at 11:41 pm

#3661791
Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop

david.holley wrote:
Young man (or woman), Implicit joins are evil. Always. Even in examples or practice exercises. Repent of your wicked ways.
BWAAA-HAAAA!!!!! Someone needs to tell MS that. Properly written correlated...
--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, 2019 at 11:28 pm

#3661786
Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop
tom 69406 wrote:
A minor point I came across today - your "favourite way" to produce the Tally table does not work in an Azure database:
```
SELECT TOP 11000 --equates...
```
--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, 2019 at 11:11 pm

#3661783
Reply To: How to compress indices without rebuilding them

svenflock wrote:
Hi guys, sorry for the late reply. I had email notification turned off and the post was out of my mind.Thanks for the input about not dropping compression. I...
--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, 2019 at 1:13 pm

#3661569
Reply To: Inserting 6 nullable comma separated fields into a single value?

drew.allen wrote:
Jeff Moden wrote:
drew.allen wrote:
Most of these methods don't correctly handle situations where the final value is null (leaving a trailing comma). It's simpler to handle this using leading commas rather...
--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, 2019 at 2:19 am

#3661431
Reply To: Inserting 6 nullable comma separated fields into a single value?

drew.allen wrote:
Most of these methods don't correctly handle situations where the final value is null (leaving a trailing comma). It's simpler to handle this using leading commas rather than trailing...
--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, 2019 at 8:20 pm

#3661355
Reply To: Debug is not visible in sql management studio

Alejandro Santana wrote:
They have removed the debugger in the latest version of SQL Server Management Studio 18+, download earlier versions for the SSMS with debugger. 🙁 Greetings,
I wish MS would stop...
--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 8, 2019 at 7:16 pm

#3660910
Reply To: Building Helpful Commit Messages

peter.row wrote:
Oh in that case you won't lose anything. JIRA is a task management system it is not a VCS. We use SVN for VCS and JIRA for task management.
Ah......
--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 8, 2019 at 12:24 pm

#3660731
Reply To: Building Helpful Commit Messages

Awesome. Thanks for the tips on the use of Crucible.
As far as losing comments in our VCS goes, we don't. What we are going to lose is ALL 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 8, 2019 at 12:11 pm

#3660726
Reply To: Create tables from metadatatable

I guess I just don't understand why anyone would do such a thing.
For deployments, it's easier to go with a script.
For documentation, it's easier to go with what SQL Server...
--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 8, 2019 at 10:42 am

#3660710
Reply To: Building Helpful Commit Messages

Heh... good comments both simplify and rule the world. It's too bad that people don't understand that comments external to the code, even in a VCS, are too easily lost. ...
--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 8, 2019 at 10:31 am

#3660709
Reply To: query with CTE

nooshin wrote:
Hello, I need help to write a query with CTE. I wanna write a query for TotalPrice of Last Sunday of each month between some years.
Use a Tally Table...
--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 7, 2019 at 2:46 pm

#3660577

Viewing 15 posts - 9,046 through 9,060 (of 59,067 total)