Forum Replies Created
Viewing 15 posts - 2,761 through 2,775 (of 59,098 total)
-
Reply To: How to change STRING_AGG to stuff xml to split feature value by pip?
p.s. Ask the fellow that made the XML suggestion for the code. 😉
--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) -
Reply To: How to change STRING_AGG to stuff xml to split feature value by pip?
You don't understand... it's not the STRING_AGG that's the issue (it's a symptom of the real problem) and using XML to do the same thing isn't going to solve 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) -
Reply To: i have to increase the size of all my stored procedure's varchar
I'm pretty sure that you want to change to NVARCHAR(), instead. IIRC, UTF-8 is a Unicode encoding.
--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) -
Reply To: backup practice/strategy/risks
lan2022nguyen wrote:only Log for those full recovery model.
To echo one of Johan's questions, how often do you do those?
--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) -
Reply To: How to change STRING_AGG to stuff xml to split feature value by pip?
This appears to be a near duplicate post from the following...
Good luck in getting this OP to answer questions. I still have a few outstanding questions there but, to 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) -
Reply To: To Which Experts Should You Listen?
Grant Fritchey wrote:Jeff Moden wrote:Grant Fritchey wrote:larry.blake wrote:Grant does a great job of presenting both Redgate and non-Redgate topics btw.
Cheers!
Very kind of you to say. Could you share it with my boss?...
--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) -
Reply To: Get AD data and load to SQL
Bruin wrote:I get this error:
Get-ADUser : The supplied distinguishedName must belong to one of the following partition(s):
any ideas ???
You've still not explained what you intend to glean from the AD...
--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) -
Reply To: To Which Experts Should You Listen?
Grant Fritchey wrote:larry.blake wrote:Grant does a great job of presenting both Redgate and non-Redgate topics btw.
Cheers!
Very kind of you to say. Could you share it with my boss? Ha!
You 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) -
Reply To: Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1
Thanks, Peter... Those are the basic formulas we ended up with in the article. They're just "DRY"ed out a bit 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) -
Reply To: To Which Experts Should You Listen?
sean redmond wrote:As far as I see it, there are two points here: how much of an expert on the topic in question the presenter is and to what extent is...
--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) -
Reply To: To Which Experts Should You Listen?
larry.blake wrote:Steve, I appreciate you not ending a sentence proposition with.
Seriously though, we wouldn't have so many great events if it weren't for the vendors. I've been to a 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) -
Reply To: To Which Experts Should You Listen?
dsor wrote:Personally I almost exclusively watch talks online, which has the added benefit of being able to skip the first and last 20% of it.
I couldn't care less about who...
--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) -
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) -
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) -
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)
Viewing 15 posts - 2,761 through 2,775 (of 59,098 total)