Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,576 through 19,590 (of 59,072 total)

RE: Speed up Setting Drill Through Parameters

With the understanding that I know little of SSIS, is there no way to do this auto-magically from some data somewhere based on some criteria?
--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 15, 2015 at 8:15 am

#1826751
RE: Commercial Software with All Tables as Heaps and Terrible Performance

robinwilson (9/14/2015)
I was going to say I'm sure that the software house will admit full responsibility for their shoddy work and give me a script to quickly create all 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 15, 2015 at 7:08 am

#1826720
RE: Commercial Software with All Tables as Heaps and Terrible Performance

Eirikur Eiriksson (9/14/2015)
Someone has leaked the details
SPOM!!! 🙂
--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 15, 2015 at 6:49 am

#1826713
RE: JSON

sknox (9/11/2015)
Manic Star (9/10/2015)
Jeff Moden (9/9/2015)
Manic Star (9/9/2015)
JSON is evil incarnate. XML's bastard sibling at best.
😀
I LOVE IT! A kindred spirit!!!! 🙂
My first encounter with it was...
--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 15, 2015 at 6:44 am

#1826711
RE: CACHESTORE_SQLCP consuming all memory in an instance

TheSQLGuru (3/12/2015)
Please don't respond to 4-year old threads Steve. Thanks!
Why not? If someone has a solution to even a really old thread, why not post it? It's...
--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, 2015 at 11:59 am

#1826493
RE: Need Help in Recursive Query in SQL using CTE

So to summarize, given any DetailComponent, you want to return both the "upline" and the "downline" of that component?
How many rows will end up in this table and how often...
--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, 2015 at 9:26 am

#1826415
RE: Commercial Software with All Tables as Heaps and Terrible Performance

It's not Oracle. It's unaware front-end developers creating tables using Visual Studio. It's amazing what a poor job it does if you don't actually specify things explicitly.
--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, 2015 at 8:40 am

#1826384
RE: Optimisation of unpivot/insert code

Indexes probably won't help at all because you're looking at the whole table.
Thanks for the feedback on the true UNPIVOT method. I'll give that a try, as well.
--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, 2015 at 8:02 am

#1826369
RE: Commercial Software with All Tables as Heaps and Terrible Performance

Eirikur Eiriksson (9/13/2015)
Using heap to speed the inserts is like a very bad Credit Card deal, no transaction fees but X000% Annual interest rate:pinch:
😎
Jeff Moden (9/12/2015)
It's a really good...
--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, 2015 at 12:44 am

#1826282
RE: Optimisation of unpivot/insert code

Because it's still an estimate of cost, I don't trust even the Actual Execution Plan when trying to determine which code will be faster or use fewer resources. It's...
--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, 2015 at 9:52 am

#1826247
RE: convert rows to columns in query

Along with JLS's fine answer above, please see the following article to understand how it works.
http://www.sqlservercentral.com/articles/T-SQL/63681/
For your next post, please see the following article for the best way to post...
--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, 2015 at 8:22 am

#1826245
RE: Save query results directly using variables and date/time

Grant Fritchey (9/8/2015)
Jeff Moden (9/4/2015)
Grant Fritchey (9/2/2015)
I would focus on using PowerShell. You can make the call to the procedure, capture the output to file. It's the most direct mechanism...
--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, 2015 at 10:00 pm

#1826229
RE: SQL syntax help - this should be simple

mw112009 (9/8/2015)
cool
good job.
i am happy with the reply
Now... what did you learn?
--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, 2015 at 9:54 pm

#1826228
RE: Commercial Software with All Tables as Heaps and Terrible Performance

robinwilson (9/12/2015)
Hello
I recently moved to a new organisation and one of my first tasks was to work out why the main software the organisation uses is, and has always been,...
--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, 2015 at 9:37 pm

#1826227
RE: Percentage of Fragmentation increased after 6 hours

Kristen-173977 (9/11/2015)
Jeff Moden (9/11/2015)
What format is that column stored in?
I'm guessing again ... but a normal GPS message starts with a code (which might not change) immediately followed by 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, 2015 at 12:55 am

#1826192

Viewing 15 posts - 19,576 through 19,590 (of 59,072 total)