Jeff Moden

Forum Replies Created

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

RE: Uptime = Downtime? (Database Weekly, Aug 3, 2009)

mike brockington (8/5/2009)
Heh... that's why I'm able to make a living.
And how many times to you get brought in to sort out a system that had been 'upgraded' 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)

October 26, 2009 at 9:20 pm

#1071005
RE: Are the posted questions getting worse?

WayneS (10/26/2009)
That's a bummer Jeff... but is the new job going good?
Thanks for asking, Wayne. The new job is going great... except that I can't get time...
--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 8:44 pm

#1071002
RE: Are the posted questions getting worse?

RBarryYoung (10/26/2009)
Bob Hovious 24601 (10/25/2009)
Good to hear, Jack 🙂 🙂 🙂
Barry, congratulations on getting my question right on the first try. I predict it will be very profitable for...
--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 8:40 pm

#1071001
RE: Are the posted questions getting worse?

Crap... I can say "crap" on this post, right? Crap, crap, crap... it's happened again same as last year and for the same reason. Started a new job...
--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 8:00 pm

#1070994
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

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