Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,761 through 47,775 (of 59,102 total)

RE: Assigning current of _Cursor to local @variable

rgillings,
Thanks for the feedback, I appreciate it. If you really want to get a handle on that particular logic, take a gander at the article in the link 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)

October 14, 2008 at 5:21 am

#884536
RE: db size grow when using index defrag-HELP!!

amit (10/14/2008)
There is no transaction logs backup running. Is there any script to complete the same? Because i had scheduled this index defrag. I can complete the transaction log back...
--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)

October 14, 2008 at 5:15 am

#884534
RE: Primary Key

Heh... this has been a lot of fun, but the funny thing about this whole thing is that people keep talking about everything except the original post.
Yes, I agree 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)

October 14, 2008 at 5:05 am

#884528
RE: Nested while is not working

You need to include the intial value of @j-2 in the @I loop or it just counts down in one iteration of @I and stays there.
--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)

October 13, 2008 at 9:11 pm

#884397
RE: Nested while is not working

You should tell us why you'll need nested While loops... typically, that's a recipe for a huge RBAR performance problem and it can usually be avoided. 😉
--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)

October 13, 2008 at 9:05 pm

#884396
RE: Using Column Values from Table to Query Another Table

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

October 13, 2008 at 8:53 pm

#884395
RE: Count SQL statement in script task

ayemya (10/13/2008)
I found a way to make it works. I have to close this question.
You should continue the question because you're still using a loop and a function to do...
--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)

October 13, 2008 at 8:03 pm

#884392
RE: Import CSV data into a table in SQL Server 2005 CE

You're trying to reinvent the wheel. 🙂 Use BCP or Bulk Insert, instead.
--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)

October 13, 2008 at 8:02 pm

#884391
RE: Assigning current of _Cursor to local @variable

This is a "simple" :hehe: "running total" problem except instead of a running total that carries the previous balance of each row forward, we'll just carry the previous value of...
--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)

October 13, 2008 at 7:57 pm

#884390
RE: Assigning current of _Cursor to local @variable

rgillings (10/13/2008)
I wouldn't feel right if I didn't offer a non-cursor alternative.
Heh... it's still RBAR on steroids, though. A cursor with Forward Only Read Only will be just as...
--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)

October 13, 2008 at 7:45 pm

#884387
RE: db size grow when using index defrag-HELP!!

I believe you can add something like "Sort In TempDB" to your commands and only TempDB will change size, then. Lookup the reindexing commands you're using in Books Online...
--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)

October 13, 2008 at 7:35 pm

#884386
RE: Convert rows into columns

Shree (10/13/2008)
Hi, do you think can we write without the XML?
Yep... see the following article...
http://www.sqlservercentral.com/articles/Test+Data/61572/
Also, the folks in charge of the database have made a bloody huge error in not...
--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)

October 13, 2008 at 7:27 pm

#884385
RE: To get rows in CSV format

See the following for a basic "how to" and some pitfalls to avoid...
http://www.sqlservercentral.com/articles/Test+Data/61572/
... and, in most cases, the biggest pitfall is the task itself. CSV data shouldn't be stored...
--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)

October 13, 2008 at 7:16 pm

#884384
RE: Loading column having $ sign to SQL Server Destination

Greg Charles (10/13/2008)
The dollar sign isn't stored in SQL Server. If you need to display the money columns with the symbol, it should be applied in the application.
Heh... true...
--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)

October 13, 2008 at 7:13 pm

#884383
RE: Dangers of using MYSQL...What are they?

DBADave (9/23/2008)
Sounds like our DBA team won't be able to offer any arguments against it.
Thanks for the quick response.
Dave
Actually there is an argument against 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)

October 13, 2008 at 7:00 pm

#884381

Viewing 15 posts - 47,761 through 47,775 (of 59,102 total)