Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,926 through 23,940 (of 59,102 total)

RE: Is there a way?

I haven't tried it but (no pun intended) check out CHECKSUM_AGG in Books Online. It might be just what the docter ordered.
--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, 2014 at 9:54 pm

#1704018
RE: Partition key should be part of Primary key

Fredy James (4/7/2014)
I know this is an old post, but completeness of this thread I would like to add the below comments.
DBA as well as Jeff.Mason was partially correct in...
--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, 2014 at 9:39 pm

#1704016
RE: Partition key should be part of Primary key

jeff.mason (10/4/2010)
This is just wrong. I know of no requirement like that. Partitioning has nothing to do with referential integrity and it shouldn't even enter into the discussion.
I...
--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, 2014 at 9:23 pm

#1704013
RE: LINQ vs SQL Questions

john.deprato (4/7/2014)
Not saying that at all. We use stored procedures when it makes sense. I was just making sure that no one was implying they were the only way to...
--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, 2014 at 8:09 pm

#1704002
RE: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

Apologies. I really had to think about this.
First, I guess I don't understand why you would need an order in the output. The output bears no resemblence to...
--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, 2014 at 5:51 pm

#1703988
RE: Help need in Avoiding Loop

born2achieve (4/7/2014)
Hi Jeff,
Finally i am able to create 500000 mock records as test data and i did test. it took 20 seconds. hope this is quick result. Any comments or...
--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, 2014 at 5:09 pm

#1703984
RE: Team Reputation

I have to disagree a bit with the aspect of not saying anything if someone doesn't meet expectations. There's no doubt that not everyone on a Team is going...
--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, 2014 at 5:00 pm

#1703983
RE: Help need in Avoiding Loop

born2achieve (4/7/2014)
How can i create 60000 + dummy records on the above table format to test. any help please
With the idea of teaching a man to fish, please see 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 7, 2014 at 4:41 pm

#1703980
RE: LINQ vs SQL Questions

john.deprato (4/7/2014)
From my experience, it's how you write the LINQ query that makes the biggest difference. Whether you are using lambda expressions or writing from selects, etc... I have 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)

April 7, 2014 at 4:38 pm

#1703979
RE: Insert Into with nested Selects

Sean Lange (4/7/2014)
Jeff Moden (4/7/2014)
Why are we inserting into an IDENTITY column???? :ermm::blink::crying::pinch::sick:
Sounds to me like the OP is going inserting data that was missed in the original programming. Therefore...
--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, 2014 at 4:32 pm

#1703978
RE: Doubt on Dynamic SQL

balasach82 (4/7/2014)
I have a set of 5 queries as 5 rows in a table. I am looping 1 by 1 and execute the queries, 5 in all, using sp_exectuesql
what is...
--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, 2014 at 4:27 pm

#1703977
RE: Find and Replace Injection String in Server 2005

Lynn Pettis (4/7/2014)
I know what it is and I also know if you take the time to do things correctly that tools like IronSpeed are just as good for development...
--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, 2014 at 4:24 pm

#1703975
RE: Insert Into with nested Selects

Why are we inserting into an IDENTITY column???? :ermm::blink::crying::pinch::sick:
--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, 2014 at 1:47 pm

#1703942
RE: Moving over from Oracle

hboswell (4/7/2014)
If I just want to move a table, or a set of tables, between two servers that aren't able to connect to each other, is BCP the proper tool...
--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, 2014 at 1:43 pm

#1703940
RE: Number of columns in table

ScottPletcher (4/7/2014)
If you really want to use a single table, you could use a single smallint or int column with a bit assigned to each newsletter. That isn't necessarily...
--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, 2014 at 1:40 pm

#1703938

Viewing 15 posts - 23,926 through 23,940 (of 59,102 total)