Jeff Moden

Forum Replies Created

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

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
RE: Unable to Kill Process :dbcc inputbuffer

Lynn Pettis (4/7/2014)
Almost a four year old thread.
BWAAA-HAAAA!!! (Sorry... did that come out loud?) 😛
--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:32 pm

#1703935
RE: Transpose data?

kwaldman 36287 (4/7/2014)
Hi all,
I'm new to SQL and these forums, but I'd love some help! I have a table that has data on drugs that people receive during hospital stays....
--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:30 pm

#1703933
RE: Help need in Avoiding Loop

born2achieve (4/7/2014)
Hi Jeff,
Quick Query about if i have 60000 + records to process with this logic will it break anywhere with timeout issue. could you please suggest me
It should run...
--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:26 pm

#1703929

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