Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,471 through 34,485 (of 59,099 total)

RE: Separate db copy for reporting

chetanr.jain (3/28/2011)
I would prefer Log SHipping in this case.
As the primary server is in Clustering mode and Secondary server is in stand-alone mode.
If you had a SAN that would 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)

March 28, 2011 at 7:05 am

#1304328
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

The total (SUM) column in the example I gave is works by day and will work across many years but I suspect you mean something different. Can you be...
--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 28, 2011 at 7:01 am

#1304326
RE: Updating millions of records

SQLRO (3/28/2011)
Thanks Jeff! We have changed the database recovery model to Simple for this database. I will check how much the log grows after the respective team runs their matching...
--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 28, 2011 at 12:34 am

#1304186
RE: Need to insert column with Table name in table

I'm not sure what the question is. Create the new table and when you do inserts into it from the other tables, hardcode the 3 letters from each 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)

March 28, 2011 at 12:26 am

#1304180
RE: Query Req: student & attendance table

waqarnaeem2 (3/28/2011)
Now i tried ,
Thanks to you all
So show us what you tried. 😉
--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 28, 2011 at 12:22 am

#1304175
RE: Updating millions of records

SQLRO (3/27/2011)
Hi Jeff,
We do srhink the log but not every night. We receive the data in lots (45K to 400k) which needs to be matched with the data in this...
--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 28, 2011 at 12:20 am

#1304174
RE: pls help newbie re averaging values hourly

Your narrative is great but you might want to check the first link in my signature line below to get better help in the future.
--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 28, 2011 at 12:14 am

#1304173
RE: Query Tuning - Update Satement

Marvin Maralit (3/27/2011)
Hi Guys,
I'm having trouble on tuning this update statements.
UPDATE CASE_DETAILS_V
SET USER_DATA3= LEFT(INDUSTRYDESC,105),--INDUSTRY,
USER_DATA1= TEST_PROGRAM--TEST PROGRAM
FROM (
SELECT DISTINCT ACCTNO,CIFNO,TEST_PROGRAM,INDUSTRYDESC
FROM #TBL_HAND_OFF_TMP HAND_OFF
LEFT OUTER JOIN
(
SELECT DISTINCT T2.LTDM_CTGDESC_C TEST_PROGRAM,T1.APP_ID_C APPID
FROM VIEW_LOS_APP_TAGS T1
INNER...
--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 28, 2011 at 12:11 am

#1304172
RE: Stored Procedure inside a Trigger?

lukus_g (3/27/2011)
Hey Jeff,
Luckily, i only ever add one row at a time... which as i type it sounds a little RBAR... but that's how i'm fed the data.
ps: love...
--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 28, 2011 at 12:07 am

#1304171
RE: T-SQL problem. Is it possible to get the result that I am looking for?

See? I do pay attention once in a while. 😛
--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 28, 2011 at 12:02 am

#1304168
RE: T-SQL problem. Is it possible to get the result that I am looking for?

Craig Farrell (3/27/2011)
Look into the OUTPUT clause...
Isn't this an SQL Server 2000 post? 🙂
--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 27, 2011 at 5:46 pm

#1304140
RE: Temp DB

ALZDBA (3/27/2011)
I didn't say it doesn't use model db, I said it doesn't just use model.
Which is not the same as "it just doesn't use model".
Ah... my bad. Sorry,...
--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 27, 2011 at 5:39 pm

#1304139
RE: Finding unique values in strings

Let's try something similar but different. 😀
First, it's impossible to determine if what we've done will have the correct performance without a wad of test data. With that in...
--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 27, 2011 at 5:20 pm

#1304138
RE: Finding unique values in strings

David Krauus (3/26/2011)
Yes Lynn, that is what I am wanting to end up with.
I have made this work with some pattern matching queries in a while loop. Again, not very...
--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 27, 2011 at 4:49 pm

#1304137
RE: Dates must be shown as string with comma separtor

sujavani.l (3/26/2011)
I have table
User ID Date
1 01\03\2011
1 02\03\2011
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)

March 27, 2011 at 3:30 pm

#1304132

Viewing 15 posts - 34,471 through 34,485 (of 59,099 total)