Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,241 through 3,255 (of 59,067 total)

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
Reply To: Convert Datetime to other format

Jeffrey Williams wrote:
I would recommend working with the receivers of the data to allow sending UTC directly instead of trying to perform the conversion for them. If you send UTC they...
--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 7:33 pm

#4056254
Reply To: Convert Datetime to other format

Bruin wrote:
Could a function be created where I pass in my date and it outputs my desired date
For 2012, yes, but that doesn't change step 1. You need 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)

June 28, 2022 at 6:00 pm

#4056211
Reply To: Convert Datetime to other format

BTw... the easier thing to do would be to convert your local dates and times to UTC and let the users fix their stuff. 😉

--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 1:05 am

#4055803
Reply To: Convert Datetime to other format

Bruin wrote:
If I was SQL 2016 then...
JobStarted AT TIME ZONE 'Eastern Standard Time' AT TIME ZONE 'Central European Standard Time' AS JobStarted_TimeZoneCET
That server will be moving to 2016 but need...
--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 1:03 am

#4055802
Reply To: explicite alternative to FORMAT() concerning DATE

TheNewbie wrote:
"does it REALLY need to be at the single row level of detail?" not necessarily
"they can tell you what aggregates they need to analyze and do that pre-aggregation for...
--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 27, 2022 at 12:59 pm

#4055545
Reply To: Creating index for a very huge table

If you ran out of log file space on that NCI build, you're simply going to need more disk space for the log file. I also suspect you may have...
--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 27, 2022 at 7:08 am

#4055402
Reply To: T-SQL : Slicing time Islands and gaps

MrRobot wrote:
... and if you have any elegant solution it will be great
I posted a link in my previous response as to what I think "the" elegant solution would be. ...
--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 26, 2022 at 11:28 pm

#4055297
Reply To: Randomizing the Day Inside a Month Using T-SQL

Stuff like this worries me. Just obfuscating the day part of a birthday still allows someone to determine that rough age of a person and, if they have a couple...
--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 26, 2022 at 9:48 pm

#4055283
Reply To: explicite alternative to FORMAT() concerning DATE
TheNewbie wrote:
here is an (simplified) example below
```
SELECT tab1.a      
tab1.b,             
tab2.c,...
```
--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 26, 2022 at 9:40 pm

#4055282

Viewing 15 posts - 3,241 through 3,255 (of 59,067 total)