Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,286 through 3,300 (of 59,098 total)

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
Reply To: explicite alternative to FORMAT() concerning DATE

Zidar wrote:
Q: Sorry, but I'm not seeing it. How would such a thing be used to improve the performance of the query the OP posted?
Valid point, chances are good it...
--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:23 pm

#4055271
Reply To: Shared Work Spaces: Hell, Heaven, Both?

Ohhh... no extended comment from me... none of it would pass HR. Let's just say that "I'm lovin' the lockdown" and seriously enjoy working remotely on all fronts.
--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 8:57 pm

#4055270
Reply To: Interview question to test beginner SQL competency?

Sounds like a prelude to spam... why would anyone in their right mind try to take an average on such an identifier column? Really bad question and, since you say...
--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 5:35 pm

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

One of the fastest methods ever created for doing this type of thing is documented in the following article.
https://blogs.solidq.com/en/sqlserver/packing-intervals/
It's an older article so solution #3 can be made work in...
--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 5:17 pm

#4055239
Reply To: how to remove duplicate rows in sysobjvalues

This was an interesting subject that I'd not heard of before. I checked and found the following article by Paul Randal. What most interesting is his answer to one of...
--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 4:32 pm

#4055227
Reply To: how to remove duplicate rows in sysobjvalues

Just out of curiosity sake, can you post the entire CREATE UNIQUE INDEX statement you were running to get this error?
--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 4:17 pm

#4055226
Reply To: SQL Server 2016 SP3?

Matthew145 wrote:
Looking for a close to issue. Expecting more reply.
Be advised that your post looks and smells like a precursor to spam, especially considering your other replies, which hadspam links...
--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 1:17 am

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

Jonathan AC Roberts wrote:
With a table of that size it might be better to look at partitioning the table.
Heh... yeah... but you'd first have to rebuild the index to partition it. 😀
--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 12:05 am

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

JasonO wrote:
My developer recently execute an index creation job...
Just exactly what does that "job" consist of?
And, yes... there's a way to do this (I do it all the time) but...
--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 24, 2022 at 7:38 pm

#4054550

Viewing 15 posts - 3,286 through 3,300 (of 59,098 total)