Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,681 through 37,695 (of 59,098 total)

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
RE: Page split with Clustered index

RakeshRSingh (7/13/2010)
I am testing Page Split with Clustered Index and Non-clustered Index.
I have created Single Clustered Index on a table and Inserted incremental values in the table. I do have...
--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:10 am

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

gserdijn (7/14/2010)
Dutch Anti-RBAR League
I've just gotta love a signature line like that. 😉
--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:06 am

#1192589
RE: Select a minimum number of rows

john-902052 (7/13/2010)
I would love to understand your code.
The code makes use of an on-the-fly "Tally" Table and it's a powerful tool/skill to have under your belt. Take a 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 14, 2010 at 12:33 am

#1192574
RE: Character type number convert

Heh.... I've really got to learn to read the other posts before posting. :blush:
--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:28 am

#1192573

Viewing 15 posts - 37,681 through 37,695 (of 59,098 total)