Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,371 through 41,385 (of 59,098 total)

RE: TSQL Question about getting data

Brad Allison (10/26/2009)
Thanks again. I was not thinking about the version that we are using. When the time comes, I hope it is not going to be 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)

October 26, 2009 at 10:09 am

#1070803
RE: Need help to write a loop store procedure

Krasavita (10/26/2009)
Thank you, I don't want to pause anytime,just wanted to know for future if I need too. So, I have 48 mil to update in production, If I write...
--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)

October 26, 2009 at 10:06 am

#1070799
RE: TSQL Question about getting data

Brad,
Just change CompletedDate and CompletedShift aliases to ScheduledDate and ScheduledShift because those are what you seek.
As for the other thing, I assumed you were using SQL Server 2005 because 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)

October 26, 2009 at 7:57 am

#1070707
RE: Any Cons to long column names.

Silverfox (10/26/2009)
Hungarian notation has its place, Jeff, but it was more widely used for variable naming rather than table or column definition. I used Hungarian notation for over 12 years...
--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)

October 26, 2009 at 6:13 am

#1070636
RE: Rebuild also reorgs?

GilaMonster (10/26/2009)
Jeff Moden (10/25/2009)
OK... I'm confused... I thought that one of the major reasons for having a Clustered Index was so that it would reorg the data so that it...
--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)

October 26, 2009 at 6:02 am

#1070631
RE: Merging 3 query results

You may want to avoid PIVOTs in favor of the old fashioned but tried and true crosstab after reading the following article...
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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)

October 25, 2009 at 10:37 pm

#1070528
RE: Any Cons to long column names.

I can click and drag a column name both in QA and SSMS so I don't really care how long they are.
What I do care about is a column name...
--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)

October 25, 2009 at 10:29 pm

#1070527
RE: Import Data to Excel

Yep... create a new role on the database that has no privs to anything except the view and use that role to "Get External Data" in Excel.
--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)

October 25, 2009 at 10:10 pm

#1070525
RE: IF statement using a Date range

Why not just drop the date ranges into a table and forget the month stuff?
--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)

October 25, 2009 at 10:06 pm

#1070524
RE: Help me to create a view

Jay_dba (10/25/2009)
I have a table
CREATE TABLE #IMaster (ID INT, ITEM1 VARCHAR(100))
GO
INSERT #IMaster
SELECT 1,'pencil'
UNION
SELECT 2,'pen/pencil'
UNION
SELECT 3,'ink'
UNION
SELECT 4,'pen/pencil/ink/'
I need to create a view like this
IDid1 ITEM1
11pencil
21pen
22pencil
31ink
41pen
42pencil
43ink
We are still...
--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)

October 25, 2009 at 10:02 pm

#1070522
RE: Help me to create a view

Oh... be careful, Johan... XML splits are relatively slow compared to many other methods.
--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)

October 25, 2009 at 10:00 pm

#1070521
RE: Calculated Columns- Best standards

One "best practice" is to make sure the calculated column results in a "Determinant" result so that it can be indexed if you need it to be.
--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)

October 25, 2009 at 9:57 pm

#1070520
RE: Is Decimal best Datatype for data with 2 decimals?

repent_kog_is_near (10/25/2009)
For data like percentage,Ratios,Rates, liters, kilometers etc with 2 decimals, is decimal always the best bet for a data type, in SQL Server 2005?
Example of these data:
50.6%
6.50% tax
1025.25...
--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)

October 25, 2009 at 9:53 pm

#1070518
RE: Rebuild also reorgs?

OK... I'm confused... I thought that one of the major reasons for having a Clustered Index was so that it would reorg the data so that it wasn't fragmented 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)

October 25, 2009 at 9:48 pm

#1070514
RE: The Value of Experience

dbo.benyos (10/24/2009)
BWAA-HAAAA!!!! So does any decent word processor!
I don't think you'd let any word processor enter any scheduled, unattended process inside production environments... My example was to show that in...
--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)

October 24, 2009 at 9:44 am

#1070389

Viewing 15 posts - 41,371 through 41,385 (of 59,098 total)