Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,756 through 25,770 (of 59,102 total)

RE: Inline Valued Function query...

dwain.c (10/3/2013)
Jeff Moden (10/3/2013)
Rather, it's an mTFV (Multiline Table Valued Function) and those can be as bad or worse than a Scalar Function.
They can?
Not that I'm...
--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)

October 3, 2013 at 8:55 pm

#1655728
RE: Are the posted questions getting worse?

WayneS (10/3/2013)
Who is going to the Summit this year? (I need to figure out who to meet up with...)
Not going. Prepping for the "great migration" from 2005 to 2012...
--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)

October 3, 2013 at 4:53 pm

#1655712
RE: Performance When dropping multiple tables

Steve Smith-163358 (10/3/2013)
Thank you all very much for your replies, and thank you Jeff for the excellent article that Alan linked to earlier.
I had often read about the merits of...
--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)

October 3, 2013 at 1:28 pm

#1655673
RE: Need help with Charindex function..

Luis Cazares (9/30/2013)
Just another possible solution.
SELECT *
FROM DelimitedSplit8K(@test, ' ') x
WHERE CHARINDEX( '@', x.Item) > 0
For the code of DelimitedSplit8K please read the following article:
http://www.sqlservercentral.com/articles/Tally+Table/72993/
🙂
--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)

October 3, 2013 at 8:01 am

#1655572
RE: SQL 2012 Import wizard VERY slow - what to do?

I'd check for blocking and a couple of other things before I killed the job so that I could understand what's happening a little better because the same thing could...
--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)

October 3, 2013 at 7:59 am

#1655570
RE: select decimals after calculations, weird display

dwain.c (10/2/2013)
CAST before you divide:
SELECT CAST(c1 AS DECIMAL(8,6)) / CAST(c2 AS DECIMAL(8,6))
FROM #t;
Or not:
SELECT 1.*c1 / c2
FROM #t;
You can also cheat if you're not too worried about precision (more on...
--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)

October 3, 2013 at 7:56 am

#1655566
RE: Pro Active DBA

Tony Savoie (10/2/2013)
A little knowledge is a dangerous thing....be careful.
First off, my advice is: Change nothing.
Monitor monitor monitor. Get to know the environment. Check all of the agent jobs,...
--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)

October 3, 2013 at 7:47 am

#1655560
RE: Performance When dropping multiple tables

Steve Smith-163358 (10/2/2013)
It appears to me that the Drop Table command has a higher overhead than looping through the cursor.
Therefore the performance isn't particularly different whether I run through 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)

October 3, 2013 at 7:40 am

#1655558
RE: Inline Valued Function query...

Just so you know, Function2 is NOT an iTVF (Inline Table Valued Function). Rather, it's an mTFV (Multiline Table Valued Function) and those can be as bad or worse...
--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)

October 3, 2013 at 7:27 am

#1655552
RE: Is this right if i will do my project this way?..

Lynn Pettis (10/3/2013)
enriquezreyjoseph (10/2/2013)
Jeff Moden (10/2/2013)
enriquezreyjoseph (10/1/2013)
Hi Everyone..I hope everyone is having a nice day:-)
Is this right if i will do my project this way?
Please see my attachment
If it's strictly...
--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)

October 3, 2013 at 7:03 am

#1655546
RE: Need Help on Fastest Search Logic

Haven't abandoned this and still working on a test data generator that everyone could use on this problem. [font="Arial Black"]Is the Product_Name in Table1 UNIQUE in Table1? Or can...
--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)

October 2, 2013 at 7:48 pm

#1655368
RE: Support of JET OLEDB

pawana.paul (10/2/2013)
Thanks Jeff.
I tried to find ACE Drivers details but not able to find much. Please let me know the web links where I can gain more inforamtion.
Regards,
Paul
Gosh. ...
--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)

October 2, 2013 at 7:27 pm

#1655364
RE: Support of JET OLEDB

pawana.paul (10/2/2013)
Thanks very much Alan.
Management don't want to move Access data to SQL Server. It would be great if you could help me in using JET OLEDB in SQL 2012.
Regards,
Paul
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)

October 2, 2013 at 2:55 pm

#1655337
RE: T-SQL counts

I struck out my previous comments. I don't know what happened last night but I can't seem to duplicate the problem today. I hate it when this happens.
--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)

October 2, 2013 at 8:15 am

#1655225
RE: Is this right if i will do my project this way?..

enriquezreyjoseph (10/1/2013)
Hi Everyone..I hope everyone is having a nice day:-)
Is this right if i will do my project this way?
Please see my attachment
If it's strictly an ETL project, maybe. ...
--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)

October 2, 2013 at 8:09 am

#1655223

Viewing 15 posts - 25,756 through 25,770 (of 59,102 total)