Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,491 through 38,505 (of 59,072 total)

RE: Using " IN " inside " WHERE " clause

c_kavya_shri (5/9/2010)
Hello ,
The data inside the " IN Clause" is hard coded and I want the output in the same...
--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)

May 9, 2010 at 10:15 pm

#1164804
RE: A good way to do an update statement in 1000 row chunks

Jeffrey Williams-493691 (5/9/2010)
I don't see any reason to worry about which rows you have updated and/or tracking that in the temp table.
Keeps the locking localized to just a couple 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)

May 9, 2010 at 10:08 pm

#1164803
RE: Help with sizing for document storage

I want to start out with a database about 500GB
Heh... I know some large companies that don't need that much storage space even after 5 years. I thought 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)

May 9, 2010 at 10:05 pm

#1164801
RE: Advice Needed for MS SQL DBA Changing to a career with Oracle

Heh... Oracle... I'm SO glad to be back in a 100% Microsoft SQL Server environment. 😛
--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)

May 9, 2010 at 9:58 pm

#1164798
RE: What is the most efficient way to delete records?

Very cool and very thoughtful... thanks for letting us know how it went.
--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)

May 9, 2010 at 9:53 pm

#1164794
RE: What S.M.A.R.T. goals should I list in my evaluation?

Heh... SMART goals. The last time I had to fill one of those out, I listed some major accomplishments for the year and then asked them a question...
1. ...
--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)

May 9, 2010 at 9:49 pm

#1164793
RE: Best Companies To Work For ---> India - MS SQL DBA

Loner (6/17/2008)
Don't go to HCL. My old company outsourced to HCL, they had the worst developers.
Heh... be careful. You might want to spend a little time with 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)

May 9, 2010 at 9:12 pm

#1164780
RE: Best Companies To Work For ---> India - MS SQL DBA

rajdba (6/4/2008)
Highest Number Position Opened in A Year For SQL Server DBA
1. Wipro Infotech
2. Wipro Tech.
3. TCS
Like the above, any body have any list???? :unsure:
Heh... beware the companies with...
--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)

May 9, 2010 at 9:09 pm

#1164779
RE: importing data to a table having a unique key (moving records not inserted to a log table) and not aborting the operation

Have you already shredded the XML files into regular columns in the temp table?
--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)

May 9, 2010 at 9:02 pm

#1164778
RE: A good way to do an update statement in 1000 row chunks

huston.dunlap (5/9/2010)
I have a temp table and a main business table I am working with. The main business table has one column I am updating. I cannot add any additional...
--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)

May 9, 2010 at 8:58 pm

#1164777
RE: CTE performance

Oh yeah... almost forgot... it would be the easiest to build a permanent Tally table for this one so we don't have to figure out how to keep the Table...
--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)

May 9, 2010 at 8:14 pm

#1164775
RE: CTE performance

kazim.raza (5/9/2010)
Thank you, thank you so much, it did work with #a I'll try with #Hie too. I'll keep you posted on it. Once I am done with the deployment...
--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)

May 9, 2010 at 8:09 pm

#1164774
RE: CTE performance

This will run like greased lightning because we're NOT calculating the Tally table on the fly...
WITH
ctePreNumber AS
( --=== Add a row number to each "a" so we can repivot after...
--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)

May 9, 2010 at 7:48 pm

#1164769
RE: CTE performance

BTW... the code will suck for performance because we tried to build in the code for the Tally table.
--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)

May 9, 2010 at 7:46 pm

#1164768
RE: CTE performance

kazim.raza (5/9/2010)
Please take your time I am here...b/w, I am going to apply this thin on #HIE or the CTE , just doing a dry run on #a with 3...
--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)

May 9, 2010 at 7:44 pm

#1164767

Viewing 15 posts - 38,491 through 38,505 (of 59,072 total)