Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,696 through 43,710 (of 59,097 total)

RE: Do You Have a Problem?

bob.willsie (5/21/2009)
Is there a certification for DBAs?
If so, is the testing process kept up to date? (Years ago I almost went for CDPM certification until I found out half...
--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)

May 23, 2009 at 8:50 pm

#999406
RE: Query Help

Thanks for the feedback, Allister.
--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)

May 23, 2009 at 8:33 pm

#999405
RE: Copying a SQL 2005 database

Most flavors of a SAN come with "snapshot" capabilites that solve these types of problems.
--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)

May 23, 2009 at 8:24 pm

#999404
RE: Are the posted questions getting worse?

GilaMonster (5/23/2009)
<sigh>
"I detached the DB, deleted the log file and it won't attach. Backups not working either"
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=126304
Head-desk
Why???????????
Ah, ah! There you go again... 😛 No wonder you get 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)

May 23, 2009 at 8:04 pm

#999403
RE: NATURAL JOIN

RBarryYoung (5/23/2009)
Say what!!! You're quoting ANSI standards??? ...
Alright buddy, Who are you and what have you done with Jeff!
😀
BWAA-HAAA!!! No, I haven't lost my tin hat,...
--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)

May 23, 2009 at 8:01 pm

#999401
RE: NATURAL JOIN Syntax IN SQL Server 2005

The author of that article didn't do his homework on joins. There is no Natural Join in SQL Server. And, if you research it a bit, if such...
--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)

May 23, 2009 at 7:41 pm

#999399
RE: To write a query

Florian Reischl (5/23/2009)
Also very clean to use an tab-lock and an index hint to ensure the order!
Just so long as no one thinks they can do that with a non-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)

May 23, 2009 at 7:31 pm

#999398
RE: To write a query

Very cool, Flo. We're getting all of the running total methods out in the open. Care to write a CLR for this bad boy?
The INNER JOIN method, which...
--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)

May 23, 2009 at 7:18 pm

#999396
RE: NATURAL JOIN

Heh... curiously enough, Microsoft and Oracle have two different descriptions of what a "natural" join is.
http://support.microsoft.com/kb/136699
[font="Arial Black"]The Equi-Join and Natural Join[/font]
Almost all joins, including all examples given so far, 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)

May 23, 2009 at 6:40 pm

#999389
RE: To write a query

The inline code jumped from 41 seconds at 10,000 rows to 170 seconds for 20,000 rows. In other words, the amount of time increases by a factor of 4...
--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)

May 23, 2009 at 2:55 pm

#999381
RE: To write a query

Florian Reischl (5/23/2009)
Good point Jeff. If there are more than four rows 😀 an inline query gets a bad performance.
One question:
Did you figure out if a cross join performs better...
--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)

May 23, 2009 at 2:35 pm

#999378
RE: To write a query

That's a "running total" problem. Inline queries are ok for only the smallest of collections. See the following for why...
http://www.sqlservercentral.com/articles/T-SQL/61539/
If you have more than small collections of data...
--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)

May 23, 2009 at 1:22 pm

#999370
RE: Introduction to Bitmasking in SQL Server, Part 2

First, this series of articles is good and I won't take anything away from the author on it. Well done.
But, I agree with many of the others when 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)

May 23, 2009 at 1:14 pm

#999367
RE: Introduction to Bitmasking in SQL Server, Part 2

Mitch Miller (5/21/2009)
Sorry LP -- I just had a nice big explanation with examples, and this damn website took it and tossed it. Now I'm pissed. I can't...
--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)

May 23, 2009 at 12:53 pm

#999366
RE: Query Elapsed Time

Florian Reischl (5/23/2009)
Jeff Moden (5/23/2009)
If I understand correctly, this is a stored proc that processes a single row? If it's used in conjunction with a GUI, that's probably ok....
--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)

May 23, 2009 at 12:42 pm

#999362

Viewing 15 posts - 43,696 through 43,710 (of 59,097 total)