Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,466 through 42,480 (of 59,067 total)

RE: Page SPlit Errors

Page split erros? Do you really mean "Torn Page" errors?
--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)

August 6, 2009 at 1:24 pm

#1035638
RE: Need help to move 99 lacs records

SELECT INTO will not work on an existing table. 99 Lacs is 9.9 million rows. No matter how you slice it, that will take some time especiall if SIMPLE...
--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)

August 6, 2009 at 1:22 pm

#1035637
RE: What would be the cheapest query for this?

virgilrucsandescu (8/6/2009)
If I have a table / view like this :
ID ATTR1 ATTR2 ... ATTRn
--------------------------
id1 , attribute fields line 1
id1 , attribute fields line 2
id2 , attribute...
--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)

August 6, 2009 at 1:17 pm

#1035633
RE: Moving Average Column / Commulative Average

Read the article at the first link in my signature below. Provide a CREATE TABLE statement and the code to populate it with 10 rows of data using 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)

August 6, 2009 at 1:12 pm

#1035628
RE: Update column with itself plus value of column in another table -- accumulating?

hugh.hemington (8/5/2009)
The "Create Some Data" part of the "tutorial" is complete gibberish since it avoids showing how to assign static values to ANYTHING! (Kee-rist, who comes up with 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)

August 6, 2009 at 1:02 pm

#1035622
RE: Substring statement

tiffany.franks (8/6/2009)
Thank you Ken, you are a genius! This works great, I'm still learning, I appreciate the help!
Tiffany
Tiffany,
Just for further reference, the method Ken used is known as a...
--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)

August 6, 2009 at 12:57 pm

#1035616
RE: Same tables different counts

Mitch2007 (8/6/2009)
It's a many to many relationship. Although there are duplicate Account numbers in table one and duplicate account numbers in table 2 there can only be one account 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)

August 6, 2009 at 12:49 pm

#1035609
RE: Disable and enabling index frequently

GilaMonster (8/6/2009)
It was a feature added in SQL 2005 for cases where an index needs to be dropped for data loads. It means that the index can be recreated without...
--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)

August 6, 2009 at 12:46 pm

#1035606
RE: Are the posted questions getting worse?

Grant Fritchey (8/6/2009)
Jeff Moden (8/6/2009)
Grant Fritchey (8/6/2009)
Jeff Moden (8/5/2009)
He's mine, please... all mine... pork chops in progress. I don't want to start a dog pile on him, but he'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)

August 6, 2009 at 12:43 pm

#1035604
RE: How to be notified when a insert/update happens?

Gianluca Sartori (8/6/2009)
Jeff Moden (8/5/2009)
I cheat on things like this... xp_CmdShell to a batch file with a NETSEND.
LOL!
Haven't heard of NET SEND in the last 5 years!
It's disabled...
--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)

August 6, 2009 at 12:36 pm

#1035598
RE: Optimiser estimating wrong number of actual rows.

Rahul N (8/6/2009)
Those are not estimated rows. When you open a query plan and hover over the arrows it actually shows you Actul and Estimated row contribution of every branch.
Heh......
--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)

August 6, 2009 at 12:32 pm

#1035591
RE: Date Range within a Date Range

jcrawf02 (8/6/2009)
aktikt (8/6/2009)
Jeff,
I have listed the results of running your query against existing Claims data containing
35923 records, below. I have added a WHERE clause to restrict the values...
--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)

August 6, 2009 at 12:27 pm

#1035587
RE: Date Range within a Date Range

aktikt (8/6/2009)
Jeff,
I have listed the results of running your query against existing Claims data containing
35923 records, below. I have added a WHERE clause to restrict the values to...
--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)

August 6, 2009 at 12:24 pm

#1035586
RE: Date Range within a Date Range

jcrawf02 (8/6/2009)
Jeff, condolences to you and your friend's family.
Thanks. I very much appreciate that. I don't normally air my personal stuff but this one really got to 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)

August 6, 2009 at 12:21 pm

#1035585
RE: Date Range within a Date Range

nigel (8/6/2009)
Jeff Moden (8/5/2009)
Nigel will probably beat me to it, though.
Not a chance, I was sleeping while you were working on this.
Nice solution Jeff, I think I just about get...
--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)

August 6, 2009 at 12:19 pm

#1035581

Viewing 15 posts - 42,466 through 42,480 (of 59,067 total)