Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,776 through 2,790 (of 59,098 total)

Reply To: Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1

Sidebar/Errata:
It doesn't affect any of the outcomes in this article, but I said the following in the article...
Since the numbers above are BIGINTs and the “magic number”...
--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)

September 14, 2022 at 4:06 am

#4087375
Reply To: DBA Volunteer Opportunity

Which DB engine are they using, Jason?
--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)

September 13, 2022 at 9:14 pm

#4087295
Reply To: world map and errors loading map for VS 2022

Welcome back and good to "meet" you.
--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)

September 13, 2022 at 9:11 pm

#4087294
Reply To: All spids showing resource semaphore waits

askcoffman wrote:
Following up on this, we gave up trying to pinpoint what query/queries were causing the issues. Threw 64 GB of RAM at it which resolved the issue. We spotted...
--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)

September 13, 2022 at 8:59 pm

#4087293
Reply To: Stored procedure getting blocked and deadlocked

SQL Guy 1 wrote:
Thanks all for your replies.
Some of you are asking for full DDL and/or execution plan. Unfortunately, I cannot do that. At our place we have very strict rules 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)

September 13, 2022 at 8:48 pm

#4087289
Reply To: Large table, clustered columnstore index and NO perf. improvements.
Look at the first line in the query you're using...
```
SELECT TOP 1000000 dbo.IMS_APT.ID_vard,
```
What makes you think that even a columnstore index is going to change the amount...
--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)
September 13, 2022 at 5:24 pm

#4087212
Reply To: world map and errors loading map for VS 2022

Jason Wilks wrote:
Jeff,
oh sorry I mistakenly took that link out when I edited it for the error message. Which makes this thread no longer makes sense. And I should have created...
--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)

September 13, 2022 at 5:13 pm

#4087211
Reply To: world map and errors loading map for VS 2022

Jason Wilks wrote:
[Updated 9/6/22]
What is the easiest way to get a world map into the map gallery so that I can embed into my report?
Also, Using Visual Studio 2022. Any map...
--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)

September 13, 2022 at 3:16 pm

#4087157
Reply To: Waits on temp db

astrid 69000 wrote:
Thanks to everyone but the input.
No new code, nor report was released. I also don't get any blocks.
We found yesterday that we had we had the tempdb and the...
--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)

September 13, 2022 at 3:10 pm

#4087152
Reply To: Waits on temp db

astrid 69000 wrote:
Hello,
I would like some input and ideas on my issue.
I have two virtual servers. Prod and Test.
A couple of weeks ago, out of the blue without any deployment 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)

September 12, 2022 at 10:22 pm

#4086831
Reply To: get column names and values in each row in SQL Server

dhanekulakalyan wrote:
The Answer is that is how our vendor asked us to send our weekly files going forward. I think they are using SAS programming and their system accepts the...
--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)

September 12, 2022 at 9:54 pm

#4086824
Reply To: Pivot columns to get 0 /1 flag columns

Jeffrey Williams wrote:
...but you actually get a mix of DMY and MDY the insert will fail. If you use TRY_CONVERT however, the insert will be successful and those values that cannot...
--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)

September 12, 2022 at 9:53 pm

#4086823
Reply To: query take long time when execute it so how to solve issue ?

The "pre-aggreation" I spoke of earlier is identical to what you're suggesting. I'm just trying to get the OP to provide some extra information.
I'll also tell you there is no...
--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)

September 12, 2022 at 5:26 pm

#4086753
Reply To: query take long time when execute it so how to solve issue ?

In a very real "get real" moment, I have to ask... how many times per day will this be used and how often will the underlying data be modified.
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)

September 12, 2022 at 1:00 am

#4086446
Reply To: query take long time when execute it so how to solve issue ?

In the ExtractReports.dbo.TechnologyPlPartsFeaturValuesOrg table, what does the FeatureValue column contain in reference to the PartId? Also, is FeatureValue a unique value by FeatureID or does it change with each part...
--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)

September 12, 2022 at 12:50 am

#4086445

Viewing 15 posts - 2,776 through 2,790 (of 59,098 total)