Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,311 through 17,325 (of 59,098 total)

RE: Need help to modify XML file using T-SQL

Duplicate post. Please, let's keep all the answers in one spot. Don't post on this thread. Go to the thread already accumulating answers here http://www.sqlservercentral.com/Forums/Topic1800658-3412-1.aspx instead.
Thanks folks.
--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)

July 9, 2016 at 9:00 am

#1889296
RE: Forum Etiquette: How to post data/code on a forum to get the best help

And thanks for the early morning cover on this, John. I appreciate 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)

July 8, 2016 at 7:17 am

#1889174
RE: t-sql 2012 use like statement

wendy elizabeth (7/7/2016)
In t-sql 2012, I want to compare the values of 2 columns the values of [Identity].MiddleName to ALF.SPA1_MiddleName. The [Identity].MiddleName will always have the correct name but 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)

July 7, 2016 at 10:01 pm

#1889096
RE: Date Range overlaps

ChrisM@Work (7/7/2016)
You might find this version a little easier to follow than the IBG original and it only reads the data once, so it's quite a bit quicker:
;WITH DateSequence AS...
--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)

July 7, 2016 at 5:54 pm

#1889082
RE: SSIS - Flat file data error

Tava (7/7/2016)
Jeff Moden (7/7/2016)
Tava (7/6/2016)
Since the export process can not change...
It comes from a computer. It can be changed. It's ok to do a temporary work around 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)

July 7, 2016 at 8:50 am

#1888962
RE: Simple CLR request

Alan.B (7/7/2016)
Forgive my CLR noobness (I create about 1 CLR/year)...
You're ahead of me, there. My record has been an average of about -1 per year. That's not...
--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)

July 7, 2016 at 8:43 am

#1888959
RE: problem converting date on procedure.

Just my humble opinion... ignore it if you want but it's worked wonders for me...
The ANSI and ISO Standards quickly limit what you can actually do. For example, write...
--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)

July 7, 2016 at 8:25 am

#1888950
RE: Improvements in SQL Server Environment

Luis Cazares (7/7/2016)
Was that post a downgraded version of this one: https://www.brentozar.com/archive/2012/06/sql-server-poor-performance-checklist/ ?
Wow. It would certainly seem so. It would have been better if they posted that link...
--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)

July 7, 2016 at 8:13 am

#1888941
RE: Justify DBA access to production

jasona.work (7/7/2016)
Jeff Moden (7/6/2016)
jasona.work (7/6/2016)
On the topic of backups, I'd suggest pressing them for information on *HOW* they're going to be doing the backups. We (briefly) were looking at moving...
--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)

July 7, 2016 at 7:56 am

#1888926
RE: SSIS - Flat file data error

Tava (7/6/2016)
Since the export process can not change...
It comes from a computer. It can be changed. It's ok to do a temporary work around but they need to...
--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)

July 7, 2016 at 1:10 am

#1888853
RE: Can I recover Missing Database File From Backup?

SQL Programmers (7/6/2016)
Open Microsoft SQL Server Management Studio. Right-click on the Database and select 'Restore Database'. A popup window will appear. Paste the backup file location in the option 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)

July 7, 2016 at 1:05 am

#1888851
RE: Improvements in SQL Server Environment

Welcome aboard but...
SQL Programmers (7/6/2016)
•CHECK THE SQL SERVER VERSION
Check for the latest SQL server version, which has the latest version of the SQL query optimizer. This will have enhanced development...
--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)

July 7, 2016 at 12:55 am

#1888848
RE: Justify DBA access to production

jasona.work (7/6/2016)
On the topic of backups, I'd suggest pressing them for information on *HOW* they're going to be doing the backups. We (briefly) were looking at moving our servers (SQL...
--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)

July 6, 2016 at 9:16 pm

#1888836
RE: How to Put a MAX(Date) from a Table into an SSIS Variable

dirkdirden (7/5/2016)
Holy Crap baskets that is a lot of steps for such a seemingly easy task.
Goes right along with the Holy Snappin' Ducksh!t that you have to fill...
--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)

July 6, 2016 at 8:08 pm

#1888833
RE: Finding a substring and extracting a number associated with it

My customized solution would be to hunt down the idiot(s) that are creating the mess in the files and take them to a nice, sit down, pork chop dinner. 😉
--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)

July 6, 2016 at 8:01 pm

#1888831

Viewing 15 posts - 17,311 through 17,325 (of 59,098 total)