Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,561 through 34,575 (of 59,102 total)

RE: SQL Query taking long time

Best_boy26 (3/19/2011)
Hi Experts,
I have a SQL Table.
And I have written againest of it lot of math Calculations and for each calculations I created views and finally I joined all...
--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)

March 19, 2011 at 9:57 pm

#1300999
RE: Storing HTML into a XML-field

I can't help here but I have to ask... why would anyone store either XML or HTML in a database?
--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)

March 19, 2011 at 9:52 pm

#1300998
RE: REPLACE Multiple Spaces with One

jcrawf02 (3/18/2011)
Daniel Bowlin (3/18/2011)
I have a database filled with extra spaces and I have been using this nested replace method for sometime now. However I have always been concerned...
--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)

March 18, 2011 at 11:23 pm

#1300890
RE: REPLACE Multiple Spaces with One

anglincis (3/18/2011)
Hi,
I've been coding for a few years now but still not with the level of technical expertise as shown in some of these posts. So can someone please comment...
--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)

March 18, 2011 at 11:21 pm

#1300889
RE: REPLACE Multiple Spaces with One

Mad Myche (3/18/2011)
I will remember this method for future usage, could have used it a few months ago. Most of the data I work with is from various text editors...
--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)

March 18, 2011 at 11:12 pm

#1300888
RE: Delete 1000 records randomly

Ah... what the heck. Here's what I stored in my notes for the example.
/**********************************************************************************************************************
The goal is to delete 10 randomly selected rows from a table. It doesn't...
--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)

March 18, 2011 at 9:11 pm

#1300877
RE: Delete 1000 records randomly

As a bit of a sidebar, add one more reason to why I avoid the use of Table Variables as a general rule with very, very few exceptions. 😉
--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)

March 18, 2011 at 9:04 pm

#1300876
RE: Delete 1000 records randomly

opc.three (3/18/2011)
That is bizarre...I don't like that at all, it seems like it could be a bug. I hope someone chimes in with an explanation.
It's a simple case of "Halloweening"....
--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)

March 18, 2011 at 9:02 pm

#1300875
RE: Delete 1000 records randomly

adonetok (3/18/2011)
To test a program, I need to delete 1000 records randomly in TableOrder.
How to code to do it if there is a ID column in TableOrder?
This almost sounds malicious....
--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)

March 18, 2011 at 2:45 pm

#1300811
RE: REPLACE Multiple Spaces with One

Koen Verbeeck (3/18/2011)
Thanks for the update, Jeff.
You bet. Thanks for stopping by, Koen.
--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)

March 18, 2011 at 6:32 am

#1300445
RE: REPLACE Multiple Spaces with One

hodgy (3/18/2011)
Thanks, Jeff. Also some interesting stuff about control characters, something I've never really considered before.
Tom
Thanks, Tom. If you'd like to know a bit more about ASCII control...
--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)

March 18, 2011 at 6:23 am

#1300438
RE: REPLACE Multiple Spaces with One

chris.stuart (3/18/2011)
I have written a procedure a while back which replaces 2 space with 1 while in loop of max 30 occurances. Not rbar, but still not the best solution...
--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)

March 18, 2011 at 6:07 am

#1300432
RE: Split Comma Seperate Column Problem

😛
--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)

March 18, 2011 at 6:05 am

#1300430
RE: delete records from table2 that are not in table1

Krasavita (3/17/2011)
Hello, I need to delete records from table2 that are not in table1
I have a table1 and table2
table1
DB, CODE, RATE, MAX(CONV_DATE) AS MaxConv_Date
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)

March 17, 2011 at 10:30 pm

#1300310
RE: Split Comma Seperate Column Problem

David Burrows (3/17/2011)
Koen Verbeeck (3/17/2011)
Jeff, stop interfering in SSIS threads. 😛 😀
Ahhh!!! Be nice to Jeff, he can't help it if he is stuck in a T-SQL sandbox and can't...
--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)

March 17, 2011 at 10:22 pm

#1300309

Viewing 15 posts - 34,561 through 34,575 (of 59,102 total)