Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,651 through 37,665 (of 59,072 total)

RE: The Private Cloud

I just left a "lecture" on "Azure". I have to say I'm a bit disappointed in some of the restrictions and lack of features (like a backup) even though...
--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 14, 2010 at 10:19 pm

#1193231
RE: SSIS - importing 1000 tables

mazzz (7/14/2010)
Thank you for your responses, Jeff and Todd.
Even using the wizard to create the initial package I would still have to go in and manually edit about 2000 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)

July 14, 2010 at 10:13 pm

#1193230
RE: Are the posted questions getting worse?

CirquedeSQLeil (7/14/2010)
LutzM (7/14/2010)
OUCH!!!!
I immediately blacklist vendors with such a philosophy as soon as I'm getting aware of it...
I agree with you on that one.
What "philosophy" are you good...
--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 14, 2010 at 9:35 pm

#1193225
RE: Only customer accounts with + & - balances

smive2003 (7/14/2010)
Yes Jeff
I have up to 11 accounts per customer some with credit balances others in debit and need to limit my data to where they have both + &...
--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 14, 2010 at 2:12 pm

#1193110
RE: Try Catch alters behaviour of existing procedures

doobya (7/14/2010)
I am bored of this topic now
But still expect anybody saying that BOL is *not* ambiguous to provide a quote to prove it
(I cannot provide a quote to prove...
--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 14, 2010 at 2:08 pm

#1193108
RE: Are the posted questions getting worse?

Steve Jones - Editor (7/13/2010)
I usually say "never do x.... until you have to"
In the v6/6.5 days, temp tables where an issue. So we told all developers to "never" 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 14, 2010 at 12:56 pm

#1193078
RE: Function in Joining column degrades performance in 2008

kchant (7/14/2010)
It may be worth checking your physical join operators as well, as I've encountered performance issues with stored procedures during migrations from 2000 to 2008...
Can you elaborate a bit...
--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 14, 2010 at 12:44 pm

#1193068
RE: Function in Joining column degrades performance in 2008

kchant (7/14/2010)
It may be worth checking your physical join operators as well, as I've encountered performance issues with stored procedures during migrations from 2000 to 2008...
Can you elaborate a bit...
--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 14, 2010 at 12:43 pm

#1193067
RE: History Table

Take a look at the following in your decision making process. It may help ...
http://en.wikipedia.org/wiki/Slowly_changing_dimension
--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 14, 2010 at 12:41 pm

#1193066
RE: How to Increase Query Speed by 3 Orders of Magnitude with no Indexes

Joey Bagodonuts (7/14/2010)
User perception is that they should not be involved in development but I usually end this resistance by saying that if it is important enough for me 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)

July 14, 2010 at 12:22 pm

#1193049
RE: How to Increase Query Speed by 3 Orders of Magnitude with no Indexes

gary.strange-1058508 (7/14/2010)
I can't believe this even made it into sqlservercentral. If this dribble is the quality of articles to come I think I will look for a better provider.
If 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)

July 14, 2010 at 12:17 pm

#1193041
RE: Page split with Clustered index

I took a look at the code you posted and see nothing obvious for why you should be getting such page split indications. I won't be anywhere near 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 14, 2010 at 11:50 am

#1193015
RE: The Private Cloud

ben.mcintyre (7/14/2010)
As far as I can tell, the real future for cloud lies in SaaS (software as a service).
The seasonal example was great for showing a compelling reason for buying...
--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 14, 2010 at 1:19 am

#1192599
RE: SQL DBA to BI Developer Role

Generally speaking, SSIS is for ETL... SSAS is for BI. Are you sure it's SSIS you're looking for? Actually, if you really want to get into BI, 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)

July 14, 2010 at 1:15 am

#1192594
RE: Page split with Clustered index

changbluesky (7/14/2010)
page split will happen when the page is full and also you want to insert data continually.
Not if the data is inserted in the same order as the clustered...
--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 14, 2010 at 1:11 am

#1192593

Viewing 15 posts - 37,651 through 37,665 (of 59,072 total)