Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,551 through 14,565 (of 59,097 total)

RE: Practical usage of SQLCLR: Building QueryToHtml function

Darko Martinovic - Tuesday, June 6, 2017 12:45 AM
Orlando Colamatteo - Monday, June 5, 2017 6:40 AM
--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)

August 22, 2017 at 9:43 pm

#1956274
RE: Practical usage of SQLCLR: Building QueryToHtml function

Sergiy - Monday, June 5, 2017 5:50 AM
Once again - Thank you so much Microsoft for ditching sp_makewebtask.
12 years on - people...
--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)

August 22, 2017 at 9:41 pm

#1956272
RE: Practical usage of SQLCLR: Building QueryToHtml function

Darko Martinovic - Tuesday, June 6, 2017 12:42 AM
Theo Ekelmans - Monday, June 5, 2017 1:20 AM
--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)

August 22, 2017 at 9:41 pm

#1956271
RE: Practical usage of SQLCLR: Building QueryToHtml function

Orlando Colamatteo - Monday, June 5, 2017 6:40 AM
Well done. I appreciate the effort required to put an article like this together...
--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)

August 22, 2017 at 9:28 pm

#1956269
RE: Downside of a large number of script tasks in SSIS projects?

ash.j.hoff - Monday, July 17, 2017 5:26 PM
Hi Folks,
I am currently working on a SSIS project that has many sub packages, being...
--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)

August 22, 2017 at 9:00 pm

#1956268
RE: Data flow concept - Thoughts wanted

So how'd things work out for 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)

August 22, 2017 at 8:50 pm

#1956266
RE: Flat File with out headers

So how'd things work out for 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)

August 22, 2017 at 8:48 pm

#1956265
RE: How to access another server temp table without any Linked server

Heh... or just do it all in T-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)

August 22, 2017 at 8:43 pm

#1956264
RE: Importing a Long named Excel Sheet with Spaces

Thom A - Thursday, August 17, 2017 8:33 AM
So, I felt like trying something "stupid". The file is definitely an xls (1997-2003)...
--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)

August 22, 2017 at 8:39 pm

#1956263
RE: Polling and determine the status of a job?

Jeff Moden - Tuesday, August 22, 2017 8:32 PM
info 58414 - Monday, August 14, 2017 9:29 AM
--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)

August 22, 2017 at 8:34 pm

#1956262
RE: Polling and determine the status of a job?

info 58414 - Monday, August 14, 2017 9:29 AM
Hi,
I want to get a message from a RemoteServer when a certain SQL 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)

August 22, 2017 at 8:32 pm

#1956261
RE: Audit table

Chris Harshman - Tuesday, August 22, 2017 1:19 PM
the problem is this isn't so straightforward in SSIS as you might want 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)

August 22, 2017 at 8:29 pm

#1956260
RE: Send and save a copy of an email (as .msg)

Thom,
I might have found the answer for you and, believe it or not and despite the fact that all of the original code in the examples at 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)

August 22, 2017 at 7:44 pm

#1956259
RE: Audit table

I notice this post is 2 weeks old and you never got an answer. I don't even know how to spell "SSIS" but I do think that this is 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)

August 22, 2017 at 9:35 am

#1956191
RE: Using The SQL Server Debugger

TheSQLGuru - Tuesday, August 22, 2017 7:35 AM
IMHO the SQL Server debugger is essentially useless. Which is a damn shame...
Heh... I actually...
--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)

August 22, 2017 at 9:29 am

#1956190

Viewing 15 posts - 14,551 through 14,565 (of 59,097 total)