Jeff Moden

Forum Replies Created

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

RE: Need help in update query

v.bragadeesh (5/23/2009)
Thanks all, its working
Bragadeesh
Heh... What is working? Please post your final code.
--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 9:40 pm

#999411
RE: The Real SQL Server Experts

Heh... Open Source... Yep, I've seen what happens there. Just look at what some people write CLR's for. Some of it is good. Most of it is...
--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 9:34 pm

#999410
RE: Dataload using Powershell - 15+GB /day

I agree with Flo. Bulk Insert will load 5.1 million rows of data 20 columns wide in less than 60 seconds.
--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 9:30 pm

#999409
RE: T-sql procedure error in job

Sergiy (5/22/2009)
J (5/22/2009)
I am new to SS2K5. would you please explain in greater detail WHY ?
Because "T" in T-SQL means "transactional".
Because while you try you may affect the data used...
--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:58 pm

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

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