Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,151 through 9,165 (of 59,067 total)

Reply To: Availability Groups vs. Transactional Replication

This post was previously mistaken for SPAM and removed. It may not have even appeared on the "Active Threads" list. With that in mind, I'm bumping this post for 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)

June 13, 2019 at 1:39 pm

#3653242
Reply To: If possible need a more elegant solution to a current brute force view
Much like Des Norton, I don't see the need for CASE in this case (pun intended).
```
--===== Create a table of random PeriodID's.
     --...
```
--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)
June 13, 2019 at 3:22 am

#3653071
Reply To: If possible need a more elegant solution to a current brute force view
DesNorton wrote:
You can also use the following, which will take care of teh leap year
```
DECLARE @Year int = 2019;

SELECT PeriodID, EOMONTH(PeriodID + ' 01 ' + CONVERT(VARCHAR(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)
June 13, 2019 at 3:06 am

#3653070
Reply To: If possible need a more elegant solution to a current brute force view

randyetheridge wrote:
thanks for all the posts. I have it now, and it works great. I really appreciate all of you posting these options. As you can tell I am not...
--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)

June 12, 2019 at 8:56 pm

#3652959
Reply To: 15466 error when executing xp_cmdshell with non sysadmin user

denisa wrote:
So I created a proxy account and gave execute to this user on the xp_cmdshell...
NEVER give a non-DBA privs to execute xp_CmdShell directly. You have the proxy account setup...
--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)

June 12, 2019 at 8:51 pm

#3652958
Reply To: Are the posted questions getting worse?

below86 wrote:
I was just under the 'Active threads' view/forum. For this topic I saw there was an update, so I clicked on the time of the last update '26 minutes...
--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)

June 12, 2019 at 5:56 pm

#3652862
Reply To: formatting T-SQL

ed.elliott wrote:
Break down those barriers! I've been on the opposite side where we have had DBA's who always looked busy and were never interested in what we did unless there...
--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)

June 12, 2019 at 5:47 pm

#3652861
Reply To: Are the posted questions getting worse?

BrainDonor wrote:
MS have added database diagrams back into SSMS - https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017
Other than Windowing functions, this is one of the best moves MS has ever done. It certainly made my...
--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)

June 12, 2019 at 2:12 pm

#3652758
Reply To: Need help with query where i need to aggregate an aggregate

jcelko212 32090 wrote:
An identifier cannot be a numeric since it is a nominal scale.
Heh... you changed your form of rubbish. And, yes, you CAN do some very necessary math with...
--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)

June 12, 2019 at 1:59 pm

#3652752
Reply To: 2016 SP2 CU6 & tempdb

Haven't made it to CU6, yet (we try to stay off the bleeding edge) so thanks for the heads up. Hopefully, this will also bump your post back close to...
--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)

June 11, 2019 at 7:42 pm

#3652475
Reply To: Randomly being logged out

Just confirming that it's happened to me as well. Intermittent problems are the worst things to troubleshoot.
--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)

June 11, 2019 at 7:39 pm

#3652473
Reply To: script d'olla IN RDS

Heh... What??!! RTFM???!! That works??!! 😀 😀 😀
--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)

June 11, 2019 at 7:36 pm

#3652472
Reply To: LOOP vs CTE vs NUMS function
There are a couple of things we need to be able to help you.
1. Post the "MCS_ClarionDateToSQL" function so we can figure out what it is that you're trying to...
--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)
June 11, 2019 at 7:33 pm

#3652471
Reply To: How to Retrieve a Substring From a Larger String of Varying Length

Totally agreed that in real life, order does matter. I'll also state that it also matters in "relational theory". If it didn't, indexes wouldn't do a bloody thing for us...
--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)

June 10, 2019 at 10:13 pm

#3651988
Reply To: How to Retrieve a Substring From a Larger String of Varying Length

Matt Miller (4) wrote:
Unfortunately - I don't think STRING_SPLIT will work From the BOL for String_split:
The output rows might be in any order. The order is not guaranteed to match the order...
--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)

June 10, 2019 at 8:06 pm

#3651953

Viewing 15 posts - 9,151 through 9,165 (of 59,067 total)