Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,376 through 33,390 (of 59,099 total)

RE: ETL/Warehousing & Cross DB Queries

Thanks for the feedback.
You did perfect except for one thing... it's a "Pass-Through View"... there is absolutely no need to index the view because any query you use...
--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:46 pm

#1347577
RE: Cloud Barriers

bitbucket-25253 (7/3/2011)
Jeff Moden
None of these restrictions or limitations are new to us old farts. The only real difference that I can see between the Cloud and an old IBM Mainframe...
--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:39 pm

#1347576
RE: Code Ownership - DBA vs. Developer

BWAA-HAAA!!! Ok, Craig... you started this. 😛 What are the answers to the two questions above?
--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:29 pm

#1347574
RE: Code Ownership - DBA vs. Developer

PaulB-TheOneAndOnly (7/3/2011)
I think we are on the same page - just saying things in a different way.
Onwership of the data does not equates with ability to manipulate the data; morevoer,...
--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:27 pm

#1347573
RE: binary tree transversal

You posted an SQL Server 2000 problem on an SQL Server 2008 forum and that's part of the reason you're not getting much help. Also, if it were 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)

July 3, 2011 at 8:49 am

#1347540
RE: Are the posted questions getting worse?

Unfortunately, I won't be at the Summit this year. None of my abstracts were accepted as "primaries" and, since I pay my own way, I can't afford to go...
--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 2, 2011 at 11:36 pm

#1347513
RE: Increasing CPUs hurts Perf

as2higpark (7/2/2011)
Also wanted to add that we are seeing the CPUs (average of all 24) spike to around 50 - 70% sporatically throughout the work day. The spikes generally last...
--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 2, 2011 at 10:49 pm

#1347512
RE: Finding Gaps in a Sequential Number Sequence

Martin Grape (7/2/2011)
Here is another thing i found and modified a little.
Takes under a second for 1 millon rows and returns gaps size sorted 😉
Change tables and fields surrounded by...
--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 2, 2011 at 10:35 pm

#1347511
RE: need debtors outstanding report

ruby.malik (7/2/2011)
It is SQL
It is Oracle SQL, though. SQL Server has no NVL function nor a SYSDATE function.
It would also be helpful if we knew what you thought needed...
--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 2, 2011 at 10:10 pm

#1347509
RE: ETL/Warehousing & Cross DB Queries

If it were Cross-Server calls, then I'd be might concerned. 🙂 But, for Cross-Database calls, there's no concern about performance issues.
First, you posted a query for a Cross Database...
--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 2, 2011 at 9:22 pm

#1347508
RE: Cloud Barriers

None of these restrictions or limitations are new to us old farts. 😀 The only real difference that I can see between the Cloud and an old IBM Mainframe...
--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 2, 2011 at 8:18 pm

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

YSLGuru (7/1/2011)
Jeff Moden (7/1/2011)
Craig Farrell (6/30/2011)
Jeff Moden (6/30/2011)
I don't know if it'll make people feel any better about the "Quirky Update" but Tom Thompson and Paul White added a couple...
--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 2, 2011 at 4:40 pm

#1347498
RE: Are the posted questions getting worse?

Thanks for the fine compliment, Jim. 🙂 Nah... no banners required. 🙂 Just raise a beer and toast this fine community of friends and professionals that we...
--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 2, 2011 at 4:17 pm

#1347497
RE: Bug in CTEs?

Ken McKelvey (7/2/2011)
Sorry for not getting back earlier but I was diverted.
Lamprey13 - Thanks for working out what was wrong.
Jeff - Thanks for your code which is exactly what 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 2, 2011 at 4:07 pm

#1347496
RE: Sql tables for all countries States and Cities

info 57591 (6/29/2011)
For the latter, you should not consider anything with over 100,000 entries, because otherwise you run the risk that the script will either freeze the browser dead or...
--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 2, 2011 at 3:59 pm

#1347495

Viewing 15 posts - 33,376 through 33,390 (of 59,099 total)