Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,996 through 8,010 (of 59,091 total)

Reply To: Finding Motivation to Learn

Doctor Who 2 wrote:
Almost a year ago Microsoft mothballed their Microsoft Virtual Academy. .
Man, that was a bloody shame. They actually had some good stuff on there and I can't find hide...
--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)

January 3, 2020 at 1:22 am

#3712017
Reply To: The Time to Patch

Considering the absolute idiocy that occurred in SQL Server 2012 until the finally fixed {almost} everything they broke in the SPs and CUs prior to SP3 and the SSIS nightmares...
--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)

January 3, 2020 at 1:10 am

#3712015
Reply To: Setting flexible security for reporting
1. Create the procedures that support the reporting with EXECUTE AS OWNER. (This can easily be added existing procs)
2. Create a new role in the reporting database called db_Execute.
3. Grant...
--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)
January 3, 2020 at 12:44 am

#3712011
Reply To: T-SQL Query Help

Thanks, Joe. I appreciate the feedback. I guess my next question would be rhetorical but I'm thinking it... When was the last time you actually had to port a database?...
--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)

January 3, 2020 at 12:21 am

#3712004
Reply To: TempDB won't shrink
LearningDBA wrote:
I mean I just didn't run just DBCC shrinkfile. This is the complete command I ran for all 8 files but still no luck.
```
USE [tempdb]
GO
DBCC SHRINKFILE...
```
--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)
January 2, 2020 at 7:11 pm

#3711945
Reply To: Error converting data type varchar to numeric.

Explicitly convert the SKU to something like a VARCHAR(10) using CAST or CONVERT.
--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)

January 2, 2020 at 6:49 pm

#3711936
Reply To: Delaying the code

Right there with you on the "test the heck out of anything".
To be absolutely honest, I have no idea how you even came across this especially since it's not a...
--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)

January 2, 2020 at 6:37 pm

#3711933
Reply To: Exporting Data with PowerShell

Steve Jones - SSC Editor wrote:
Feel free to add that. dbatools is an open project.
Heh... or just do it 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)

January 2, 2020 at 6:00 pm

#3711905
Reply To: Delaying the code

BWAAAA-HAAAA-HAAAA!!!! I'm thinking that this question is the result of someone learning something the hard way! 😀 😀 😀
Great "gotcha" question, Steve!
--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)

January 2, 2020 at 4:10 pm

#3711835
Reply To: Exporting Data with PowerShell

This is a great introduction to exporting files with PoSh, Steve. I gave it a 5. That and the mention of how to do it with DBATools is great. 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)

January 2, 2020 at 3:46 pm

#3711826
Reply To: How to calculate income tax for a slab based taxation system?
If you add just one more column to the table, you can avoid the Triangular Joins that are created to calculate things that will not change for a given year. ...
- This reply was modified 6 years, 8 months ago by Jeff Moden. Reason: Double up on the single quotes so that the awful forum software doesn't make it all look like dynamic SQL (and none of it is)
--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)
January 1, 2020 at 11:53 pm

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

Lynn Pettis wrote:
Happy New Year to all.
Same back at ya, Lynn.
--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)

January 1, 2020 at 11:15 pm

#3711656
Reply To: Data Migration to S/4 Hana

frederico_fonseca wrote:
really annoys me when people don't even bother searching for what they need.
hana studio and Hana client are required - you get those from SAP
first link google returned https://blogs.sap.com/2016/08/05/how-to-connect-microsoft-ssis-with-sap-hana/
yes...
--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)

January 1, 2020 at 11:06 pm

#3711654
Reply To: T-SQL Query Help

jcelko212 32090 wrote:
>> Joe, do you convert back to numeric to get your next successive order number and then convert back to character data? With all the back and forth about...
--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)

January 1, 2020 at 10:57 pm

#3711651
Reply To: Date Dimension

My personal opinion is that people put entirely too much into Calender/DateDim tables. An example of this is people that store the full name of the days of the week,...
--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)

January 1, 2020 at 4:21 pm

#3711633

Viewing 15 posts - 7,996 through 8,010 (of 59,091 total)