Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,106 through 45,120 (of 59,095 total)

RE: Help, my database is corrupt. Now what?

GilaMonster (2/17/2009)
Jeff Moden (2/16/2009)
How much of this applies to the system's databases (not including TempDB, of course)?
MSDB can be repaired, I believe (haven't tried it). Master I would...
--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)

February 17, 2009 at 6:23 pm

#945593
RE: Are the posted questions getting worse?

Bruce W Cassidy (2/17/2009)
[font="Verdana"]A friend of mine wrote a book on why IT projects fail. One of the points he made (which I remember vividly) was that there are...
--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)

February 17, 2009 at 6:15 pm

#945589
RE: Are the posted questions getting worse?

Bruce W Cassidy (2/17/2009)
[font="Verdana"]A friend of mine wrote a book on why IT projects fail. One of the points he made (which I remember vividly) was that there are...
--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)

February 17, 2009 at 6:13 pm

#945587
RE: Are the posted questions getting worse?

Lynn Pettis (2/17/2009)
GilaMonster (2/17/2009)
<Sigh> Why don't people read the manuals?
Thinking and Reading that would mean. On silver plater answer should be.
Heh... "STAR"... Start Thinking And Reading. Or, "RATS"......
--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)

February 17, 2009 at 5:58 pm

#945586
RE: Advise for complete Beginners

louisevb (2/17/2009)
Hey Jeff, thanx man another great website and a freebie . . bonus!!
You bet... thanks for the feedback.
--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)

February 17, 2009 at 10:58 am

#945330
RE: How to add cost percentage to product

AFCC Inc. Com (2/17/2009)
Come to find out the window treatment supplier has this grid in an excel format.. Oh well,, live and learn..
Did I post enough info to loop 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)

February 17, 2009 at 10:56 am

#945327
RE: Help Me !!!

I think so... just remember that it's NOT geared specifically to T-SQL (MS SQL Server dialect of SQL).
--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)

February 17, 2009 at 10:51 am

#945323
RE: retrieving all customers whose surname begins with a certain letter

fergek (2/16/2009)
Additionally, instead of using subqueries, try to rewrite the sentence using CTE.
Why? Other than readability, it's not going to perform any better... it's just an inline view either...
--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)

February 16, 2009 at 9:48 pm

#944934
RE: Rollback the job running very long time

I usually don't turn it on either... especially when I know which proc is causing the problem.
--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)

February 16, 2009 at 8:49 pm

#944929
RE: Advise for complete Beginners

Also, keep in mind that there are different "dialects" of SQL. "Basic" SQL is called "ANSI SQL" and is supposed to be standard. The real fact of the...
--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)

February 16, 2009 at 8:47 pm

#944928
RE: Advise for complete Beginners

louisevb (2/16/2009)
Could someone PLEASE provide me with advice as to where to start? I have decided to change my career from accounting to Database Developer (BIG change . . BIG...
--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)

February 16, 2009 at 8:43 pm

#944927
RE: In way over my head

I believe that Andrew pretty much has it. The only shortcoming would be turning it into a matrix. You only need a Cross-Tab for 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)

February 16, 2009 at 8:31 pm

#944926
RE: SQL or Oracle

Max (2/16/2009)
Not yet... but that helps some. 😛
--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)

February 16, 2009 at 5:38 pm

#944913
RE: Are the posted questions getting worse?

Alvin Ramard (2/16/2009)
Michael, did he end up on MythBusters?
😀
Heh... I would think more like "MouseBusters". 😉
--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)

February 16, 2009 at 4:33 pm

#944903
RE: Passing a Table to A Stored Procedure

As a possible alternative...
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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)

February 16, 2009 at 4:21 pm

#944901

Viewing 15 posts - 45,106 through 45,120 (of 59,095 total)