Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,761 through 2,775 (of 59,086 total)

Reply To: Fixing Impostor Syndrome

Steve Jones - SSC Editor wrote:
I think Imposter Syndrome is a good driver, and has been for me.
However, it can be crippling, it can lead people to shy away from and avoid taking chances...
--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:44 am

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

izhar-azati wrote:
Install QGIS and use ogr2ogr utility to load the SHAPE file to SQL server:
ogr2ogr --debug ON -f "MSSQLSpatial" "MSSQL:server=.;database=GovilLoad;trusted_connection=yes" "PARCEL_ALL\PARCEL_ALL.shp" -a_srs "EPSG:2039" -overwrite -unsetFieldWidth -progress --config MSSQLSPATIAL_USE_BCP FALSE
for me...
--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:35 am

#4087381
Reply To: DBA Volunteer Opportunity

Thanks, Jason. I'm currently working my "dream job" and so I wasn't asking for me. I was asking hoping that you'd answer just as you did to give the job...
--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:33 am

#4087380
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

Viewing 15 posts - 2,761 through 2,775 (of 59,086 total)