Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,351 through 34,365 (of 59,099 total)

RE: Very slow query (over 100 sec.) runs in no time with temp tables: why?

What you've done is a technique that I use all of the time. It's called "Divide'n'Conquer". To put it in simple terms, think of a plate juggler... which...
--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)

April 7, 2011 at 7:20 am

#1308503
RE: dual six core processor TSQL

clement.store (4/7/2011)
Dear all,
I wonder if I m working on some heavy calculation with TSQL. Would SQL server be automatically leverage all the 12 cores in the server? Or some changes...
--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)

April 7, 2011 at 7:13 am

#1308498
RE: Creating Delimited Strings

I think the article of mine that you're looking for is here...
http://www.sqlservercentral.com/articles/Test+Data/61572/
HOWEVER, I believe that the very nice canned solution that Lowell provided is the better way and is VERY...
--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)

April 7, 2011 at 7:08 am

#1308491
RE: Updating ANSI NULLS setting on a stored procedure.

David McKinney (4/7/2011)
Hi,
When a stored procedure is created the settings for ANSI NULLS and QUOTED IDENTIFER which were set at creation time are 'saved with the stored procedure' and 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)

April 7, 2011 at 6:53 am

#1308480
RE: Floats and abuses, and business to technical conflicts

Are there any known limits for the data so you can remove the human element?
--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)

April 7, 2011 at 6:43 am

#1308470
RE: What columns should be chosen when partitioning a table?

kwoznica (4/1/2011)
Jeff,
What would be the best way to do that though?
We already have millions of records. Also would it need to be part of the front end application?
First, no,...
--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)

April 7, 2011 at 6:34 am

#1308465
RE: Query Performance Tuning

GilaMonster (4/5/2011)
Jeff Moden (4/5/2011)
Ordinarily I'd still insist on an MS URL because most people don't actually prove what they say but Gail sure did. I love demonstrable code! ...
--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)

April 6, 2011 at 4:45 pm

#1308316
RE: Moving Data... does it really need to be so complicated?

opc.three (4/6/2011)
I trust you're just looking for opinions and not some concrete answer...I can imagine a couple scenarios where it might be useful:
1. I could see using the approach from...
--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)

April 6, 2011 at 4:34 pm

#1308315
RE: Gadgets

I absolutely don't mind. What is the basis of the study and how can I learn more about it and maybe even convince Dad to provide all the information...
--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)

April 5, 2011 at 11:10 pm

#1307807
RE: How To Fix Connect

philcart (4/5/2011)
:-D:-D Love that idea Jeff
But seriously, I reckon they need a more stringent posting process so the numerous superfluous cases don't get lodged. If people had to think more...
--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)

April 5, 2011 at 10:39 pm

#1307801
RE: IF EXISTS Trigger QUERY

Also, you need to explain which table you want the trigger on and what you want to fire 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)

April 5, 2011 at 10:31 pm

#1307799
RE: IF EXISTS Trigger QUERY

So... let's say that everyone has a Status of 1 and you suddenly insert 100 rows. Do you want John to have all 100 rows?
--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)

April 5, 2011 at 10:29 pm

#1307797
RE: Table Input Parameter Question

It's a "language barrier" thing, Gail. Replace the question mark with the word "do" and you'll see what I mean.
Lot's of folks automatically put a question mark after 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)

April 5, 2011 at 10:22 pm

#1307795
RE: How To Fix Connect

BWAA-HAA!!!! I know why they rejected all those things as a "low priority".... they're building a "ribbon bar" for SSMS! :-):-D;-):-P:hehe:
--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)

April 5, 2011 at 10:17 pm

#1307790
RE: Row Transpose to column using SSIS

IIRC, it's known as a "Matrix" in SSIS and doesn't actually require the use of PIVOT but will have the same affect.
--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)

April 5, 2011 at 5:15 pm

#1307766

Viewing 15 posts - 34,351 through 34,365 (of 59,099 total)