Forum Replies Created
Viewing 15 posts - 32,101 through 32,115 (of 59,099 total)
-
RE: SSIS - PITA
Lynn Pettis (10/31/2011)
You wouldn't use a butter knife to cut a 2' x 4' would you? :hehe:In the hands of an artisan, anything is possible.
--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) -
RE: SSIS - PITA
isuckatsql (10/31/2011)
I have a simple SSIS package that reads a SQL DB input file, runs thru a script and does some parsing using regex, then updates a different SQL table...--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) -
RE: Are the posted questions getting worse?
Ninja's_RGR'us (10/31/2011)
GilaMonster (10/31/2011)
Ninja's_RGR'us (10/31/2011)
We all knew this was coming....:w00t: :hehe: 😀
Worth noting, the top 3 are all within 100 posts of each other, surprising with the total post counts involved.
Yes...
--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) -
RE: Strip HTML Tags
mister.magoo (10/31/2011)
Jeff Moden (10/30/2011)
I tried turning it into an iTVF instead of a scalar function and it took twice as long to run.I also tried and it took half 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) -
RE: Help with performance - aggregating a lot of data
Kiara (10/31/2011)
Jeff Moden (10/29/2011)
Kiara,Any interest in a bit of table redesign that will greatly improve performance for this particular query? One that will give the reporting performance you seek...
--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) -
RE: Strip HTML Tags
I refactored the function that I found at the following URL... look for the answer posted by "dudeNumber4"...
CREATE FUNCTION dbo.StripHtmlTags(@HtmlText XML...
--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) -
RE: Strip HTML Tags
Got it. Thanks.
--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) -
RE: Database email isn't sending email anymore.
I went through this at a previous company. Even the SQL Alerts couldn't send mail after they made the move and I left the company before I found out...
--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) -
RE: Get result based on competition like FIFO
BWAAA-HAAA!!! Oh, not to worry... I got all the rest of it. 🙂 I just wanted to know what the "MatrixNo" was. Basically, it's just the "StudentID"?...
--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) -
RE: Extract multiple files from multiple directories with a data flow task
Nope... not having problems getting it to run because I haven't actually tried it. 😉 What I want to know is just exactly what I asked but I'll change...
--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) -
RE: Strip HTML Tags
Understood. Let's nail the requirements right to the floor now. If you have the following string, what precisely do you want to get back?
<data1>somedata1a</data1><data2>somedata2a</data2><data1>somedata1b</data1><data2>somedata2b</data2>
<data1>somedata1c</data1><data2>somedata2c</data2>
--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) -
RE: Restricting IMPERSONATE permissions only to certain stored procedures
I missed the nuance myself. Thank you for taking the time to post the feedback.
The other nuance of the Certificate login having the "ALTER ANY USER" priv also appears...
--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) -
RE: Help with performance - aggregating a lot of data
ChrisM@home (10/30/2011)
Here's a few preliminary results from queries posted so far, and another which I'm guessing is Jeff's preaggregate. The preaggregate works fastest but not by a fat lot.I ran...
--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) -
RE: Index Rebuild - Job running over 16 hours.....
jackimo (10/30/2011)
Thanks Jeff - It's Standard Edition. I'll add the clustered index tomorrow on EventTime and look into indexed views.Once I have something to report I'll update...
--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) -
RE: Index Rebuild - Job running over 16 hours.....
Alright... while we're waiting for that answer, let me just come right out and tell you what I'm thinking...
The word is "partitioning" and you have the perfect candidate "key" 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)
Viewing 15 posts - 32,101 through 32,115 (of 59,099 total)