Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,256 through 3,270 (of 59,086 total)

Reply To: Cumulative count distinct for a period of 3 months
Post removed: Ed B. is correct. I made the mistake of counting distinct counts per month and then adding those counts... I needed to treat each 3 month unit as...
- This reply was modified 4 years, 1 months ago by Jeff Moden. Reason: Finally realized my mistake
--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 1, 2022 at 7:39 pm

#4057693
Reply To: what minimum permission i should give to new login , new user and new schema.

rajemessage 14195 wrote:
that i will read, but can i get a rough idea.
...
pls give me one example ( a rough one) for the above need.
It's a funny thing... I've been working...
--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 1, 2022 at 5:41 pm

#4057653
Reply To: Working with T-SQL function AVG ()

It's nice to see articles on the basics of SQL server without it being a simple regurgitation of whats in the MS documentation and this is a nice one. Thanks...
--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 1, 2022 at 5:10 pm

#4057638
Reply To: Replace calendar table multiplier column with date logic

Just a tweak to Drew's awesome rendition...
Drew uses the MONTH() function. I believe (I've not tested it) that will limit his good code to being used against only 1 year...
--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 30, 2022 at 9:00 pm

#4057270
Reply To: Retrieving date from next from to fill in column on row above

If you'd like a tested coded answer, please read and heed the first link in my signature line below.
--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 30, 2022 at 7:57 pm

#4057234
Reply To: How to export SQL database tables into multiple XML Files?

If the files are to be used with "near enough" version of SQL Server, then using XML, JSON, CSV, or TSV is just nuts. The absolute fastest way to 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)

June 30, 2022 at 5:10 pm

#4057182
Reply To: Interviewing for a SQL Server DBA role, any tips?

So, enquiring minds want to know, how'd it go on the interview?

--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 30, 2022 at 3:50 pm

#4057142
Reply To: Blue Question Mark on Remote SSMS

Perhaps you need to right click on the SSMS icon and select "Execute as Administrator".

--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 29, 2022 at 10:00 pm

#4056784
Reply To: Replace calendar table multiplier column with date logic

I'm really curious about this request. What is the intended use of the computed "Multiplier" column?
If the answer is to determine which day is (for example) "3 business days away", ...
--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 29, 2022 at 5:03 pm

#4056686
Reply To: Alerts and default font

Looks like they fixed the posting problem this morning (fonts, icon menu bar) but they still have problems with email notifications. I only get notifications for people that I follow.
We've...
--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 29, 2022 at 4:59 pm

#4056684
Reply To: Azure Pricing, SQL Server seems pretty high?

keven11 wrote:
I've got an SQL database I'm wanting to put in Azure.
WHY? What problem are you trying to solve and why do you think Azure is going to help?
--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 29, 2022 at 4:09 pm

#4056680
Reply To: Designing a table

Johnson330 wrote:
I have a scenario where: a company can have many workers(01,02) & worker can have multiple jobs (jb01, jb02) within the company, and in each job the worker can...
--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 29, 2022 at 4:07 pm

#4056679
Reply To: Default trace file error

When you open SSMS, you may have to right click on the icon and select "Run as Administrator".
--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 29, 2022 at 3:04 pm

#4056640
Reply To: Convert Datetime to other format

I looked back through this thread and found the following.
Bruin wrote:
Looks like I could do this:

switchoffset (CONVERT(datetimeoffset, jobstarted), '+04:00')
But how can I get just date\time and automate the offset based...
--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 29, 2022 at 4:05 am

#4056363
Reply To: Convert Datetime to other format

No guarantees but I'll try to take a look tonight. I'll use your original post as an example. I still maintain that if you ship them with UTC'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 28, 2022 at 8:52 pm

#4056279

Viewing 15 posts - 3,256 through 3,270 (of 59,086 total)