Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,916 through 30,930 (of 59,101 total)

RE: Performance issue with large number of rows

okbangas (3/2/2012)
Jeff Moden (3/2/2012)
Now that you've found out what the massive overhead is, can't you just bypass it and build a report of your own?
You mean create a web 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 2, 2012 at 10:55 am

#1454306
RE: How to pad a string with spaces when size of data is unknown

R.P.Rozema (3/2/2012)
Just for the sake of the discussion, because this is a useless alternative for the OP's question. You could make it execute the max(len()) only once like this:
SELECT LEFT(t2.TEXTFIELD...
--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 2, 2012 at 10:50 am

#1454302
RE: Dividing a list of filenames into roughly equal batch sizes in KB

Elliott Whitlow (3/2/2012)
Mutual Admiration Society?
CEWII
BWAA-HAAA!!! Well thank you Elliott. You are DA MAN! :-):-D:-P
--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 2, 2012 at 10:45 am

#1454300
RE: How to pad a string with spaces when size of data is unknown

R.P.Rozema (3/1/2012)
Jeff Moden (3/1/2012)
It sounds like the OP has unknown length data and wants to size the output based soley on the max width of the unknown data.
That's not what...
--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 2, 2012 at 6:44 am

#1454128
RE: CTE Problem

Henrico,
Heh... you've been around long enough... Post some data for folks to use. 😉 See the first link in my signature for how to make it easy for...
--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 2, 2012 at 6:38 am

#1454125
RE: KILL

MysteryJimbo (3/2/2012)
It is possible to get a hung spid in this state which will never end. The only way to get rid of it is to restart the service.
That'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)

March 2, 2012 at 6:34 am

#1454124
RE: Performance issue with large number of rows

Now that you've found out what the massive overhead is, can't you just bypass it and build a report of your own?
--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 2, 2012 at 6:32 am

#1454123
RE: Setting Flag

Remember the "old" ways... one less SORT and no 3 scan worktable behind the scenes. 😉
SELECT ID, Name, SomeDate,
Flag = (ROW_NUMBER()...
--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 1, 2012 at 8:39 pm

#1453992
RE: how to change the name of stored procedure?

For all of the reasons in Jacob's article, I'll copy the definition and use it to create a newly named stored procedure and then drop the old one. Saves...
--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 1, 2012 at 8:14 pm

#1453990
RE: Work out which column value is repeated the most

ColdCoffee (3/1/2012)
I must also ask a question here. What should happen if there are 2 LocationIDs with same number of appearances for a particular OrgID ?
Hey there folks. ...
--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 1, 2012 at 8:09 pm

#1453987
RE: Best approach to let users create and manage their own tables and data

agustingarzon (2/29/2012)
Both databases would be on the same SQL Server instance, in case I forgot to mention :unsure:
Then, no need for a linked server. Create a wad of SYNONYMs...
--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 1, 2012 at 8:01 pm

#1453985
RE: deploy stored procedure from dev/test to production with different linked server names

Elliott Whitlow (3/1/2012)
Lowell beat me to the SYNONYM point. I prefer to use that, the code never changes and the SYNONYM is defined at the database level given you...
--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 1, 2012 at 7:32 pm

#1453974
RE: Filling 'blank' with data from previous month for reporting purposes

donbuz (3/1/2012)
Wow I'm stunned - I just tweaked your code a little so that 'CLOSED' statuses are not repeated.
CTE are of great interest - I suspected that someone answering me...
--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 1, 2012 at 7:27 pm

#1453972
RE: Newbie question about scripting deployments

Red Gate's SQL Compare product would pretty much do it all for you. If data is also involved, the use of Red Gate's Data Compare product would do that....
--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 1, 2012 at 7:08 pm

#1453967
RE: Outputting a word in a procedure

ram_kamboz2k7 (3/1/2012)
I have used bcp before, and it is pretty simple to extract to a file,
However this is a code that was assigned to me for a specific task...
--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 1, 2012 at 7:06 pm

#1453966

Viewing 15 posts - 30,916 through 30,930 (of 59,101 total)