Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,986 through 9,000 (of 59,067 total)

Reply To: Date formula that adds hours and changes date

uahmed90 wrote:
Hi, I'm in need of a formula that would account for next day change. I am working on a view that adds 2 hours (due to changing time zone)...
--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 20, 2019 at 7:27 pm

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

Didn't know much about SSDs (I'm not a hardware guy anymore). Turns out that SATA SSDs aren't nearly as fast as PCle SSDs. If I calm down my hard drive...
--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 20, 2019 at 6:35 pm

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

Now there's an option I'd not considered, Eirikur! Thanks for the EXCELLENT tip!
Also, how do folks feel about a Thunderbolt 3 port? I don't personally see the need, especially 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)

July 20, 2019 at 4:13 pm

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

Thanks, Jason. Nice to hear from someone that's "actually been there and done that".
And, yeah... I picked up on the fact that they used partners as Amazon does.
Here's what I'm...
--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 20, 2019 at 3:07 pm

#3664756
Reply To: Are the posted questions getting worse?
Has anyone had any dealings with NewEgg.com? They've got 1 heck of a deal on a laptop that I'd like to get but...
1. They are not BBB accredited.
2. They've got...
--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 20, 2019 at 3:53 am

#3664713
Reply To: Generate Random alphanumeric value based on timestamp

Siva Ramasamy wrote:
Hi All, Thank you for looking into my question. Does anyone have a script that could take the current timestamp and convert that into a random alphanumeric value (30+...
--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 20, 2019 at 3:49 am

#3664712
Reply To: Stored Procedure code understanding

ng_rai wrote:
Hi, I am working on a already written stored procedure and need to understand what exactly it means: Here is the script: set @query =' if object_id (lib.dbo.ABC...
--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 19, 2019 at 7:23 pm

#3664643
Reply To: Reduce size of tempdb file mdf files

To be totally honest, this will likely be a futile exercise.
First, unless you can guarantee that the MDF files will be located on separate physical disks, there will be little...
--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 19, 2019 at 2:32 pm

#3664550
Reply To: Store Procedure...

ns550 wrote:
in what kind of scenario I would need to use output parameters in my store procedures.
According only to personal experience, I've found that the usual thing is 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)

July 19, 2019 at 12:50 pm

#3664503
Reply To: Summarize several SQL lines according to the year

John Mitchell-245523 wrote:
It's difficult to help you without any table DDL and sample data. However, if you don't want the debit and credit amounts to appear separately in your result set,...
--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 19, 2019 at 12:38 pm

#3664498
Reply To: Software need db owner permission to master database (sql2016)

Desperados900 wrote:
Hi Guys, thank you all for your reply. another manufacturer is no alternative according to the department. However, I also want to prevent the db from doing mysterious things....
--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 19, 2019 at 12:35 pm

#3664497
Reply To: Monitoring Change in SSRS

IMHO, the auditors are incorrect here and need to be trained that your controls are much more finite than their broad recommendation.
--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 19, 2019 at 12:33 pm

#3664496
Reply To: Software need db owner permission to master database (sql2016)

What does the software do?
--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 19, 2019 at 2:26 am

#3664388
Reply To: SQL and T-SQL for Beginners in 229 minutes

The future date is the date the article is supposed to be released.
--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 18, 2019 at 11:28 am

#3664101
Reply To: Separate Money Value By "/" Character

I hate posting on SO because people can edit your stuff and the moderators can be idiots but I thought I'd take a chance and post a performance test along...
--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 18, 2019 at 3:13 am

#3663982

Viewing 15 posts - 8,986 through 9,000 (of 59,067 total)