Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,361 through 33,375 (of 59,099 total)

RE: Performance Issue - CTE

yasubmj (7/5/2011)
So the big question here is, the anchor only executes once, then why is this making such a big difference?
Because recursive CTE's suck. 😀 They're actually worse than...
--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)

July 5, 2011 at 9:11 am

#1348346
RE: Drop and Create Primary Keys, Foreign Keys, Indexes Dynamically and improve SSIS Performance

If you have to drop PK's, FK's, and/or Indexes for ETL, then you're doing something drastically wrong.
--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)

July 5, 2011 at 8:52 am

#1348328
RE: Is there a way to know, from which database a temporary table has been created in TempDB?

steveb. (7/5/2011)
sanjeev_krs2004 (7/5/2011)
sometimes because of memory issue otherwise space issue.
Thanks,
Sanjeev.
to be honest this sounds like an 'ambulance at the bottom of the cliff' solution , you should look...
--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)

July 5, 2011 at 5:41 am

#1348206
RE: Rookie DBA

Along with the other good suggestions on this thread, please take the time to read the articles at the link that Gila-Monster posted above. It should be required reading...
--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)

July 5, 2011 at 5:22 am

#1348190
RE: T-SQL

lepoto.masedi (7/5/2011)
What is the quickest and most effective way of learning T-SQL?
As boring as it sounds, do the one thing that most people do not do when beginning their studies...
--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)

July 5, 2011 at 5:13 am

#1348183
RE: Code Ownership - DBA vs. Developer

Craig Farrell (7/4/2011)
Who owns it? One of the five DBA's already working 50 hrs a week each on maintenance and has never seen this code other then an 'F5'...
--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)

July 4, 2011 at 10:26 pm

#1348052
RE: Running Total Issue - ANything New On this Aside from Jeff Modens "Quirky Update"?

TheSQLGuru (7/4/2011)
Given that a flaw was found what, a two years or more, after the "quirky update" was first put out there how many incorrect results were calculated?
So, what'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)

July 4, 2011 at 12:58 pm

#1347997
RE: How to give answers of some frequent questions

turner.phillip3 (7/4/2011)
hello members,
Several times I have faced the questions like- What is reason for change?
At most cases one does it for hike in salary, but you cant...
--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)

July 4, 2011 at 12:54 pm

#1347996
RE: How to select one column as multiple columns..

crackbridge (6/27/2011)
but trust me best practice to help in the forum is do not issue banal views when the answer is not known
Actually, it IS a best practice to "issue...
--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)

July 4, 2011 at 8:51 am

#1347905
RE: Best practice to move SQL Server databases to a new location

I'm no SAN or storage expert but I have to ask... Is there a reason why the new disks can't simply be assigned to the current "E" drive or why...
--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)

July 4, 2011 at 8:35 am

#1347894
RE: Running Total Issue - ANything New On this Aside from Jeff Modens "Quirky Update"?

CELKO (7/4/2011)
T-SQL is about a decade behind Oracle and DB2. We only got part of the window clause for aggregates; the full syntax is:
You said a mouthful 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)

July 4, 2011 at 8:27 am

#1347887
RE: Code Ownership - DBA vs. Developer

BWAA-HAA!!! Actually, that's a pretty good definition! Well done.
However, I'd bet credits to Navy beans that if something goes wrong, the Business User will blame the Developers and...
--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)

July 4, 2011 at 8:17 am

#1347880
RE: CTE/View definition

amit_adarsh (7/4/2011)
Hi
How to change the view definition ?
I have a table with all columns having not null values when I create a view on this my all columns...
--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)

July 4, 2011 at 8:09 am

#1347872
RE: How to get SUM of Current day amount minus SUM of Previous day amount

bhargava.sumansiram (7/4/2011)
Hi frd's,
here the tables
In table t1
columns : sys_id (char)= abc , abc
product_code (char)=0.000 , 0.000
...
--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)

July 4, 2011 at 8:06 am

#1347871
RE: Running Total Issue - ANything New On this Aside from Jeff Modens "Quirky Update"?

Lynn Pettis (7/3/2011)
Is there a link to the updated code with saftey checks? I haven't been on ssc as much as I'd like to be so I think 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)

July 3, 2011 at 4:48 pm

#1347578

Viewing 15 posts - 33,361 through 33,375 (of 59,099 total)