Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,966 through 31,980 (of 59,099 total)

RE: Starting with "WITH"

L' Eomot Inversé (11/12/2011)
That's a consequence os a general rule against touching rows more than once, which means that touching 100,000,000 rows once each is better than touching 5...
--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)

November 12, 2011 at 7:26 pm

#1406770
RE: ssis and ssrs interview questions

Gosh... I went back and looked at one of the links for SQL Server questions and answers. Part of the reason that I recommend NOT using such Q'n'A sites...
--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)

November 11, 2011 at 9:22 pm

#1406641
RE: Starting with "WITH"

If we went by Chris' definition of RBAR, then Triangular joins would be considered to be set based code... and they're not because they "touch" most rows more than once......
--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)

November 11, 2011 at 9:07 pm

#1406640
RE: Using DISTINCT within a JOIN

I can. The key here is to know why you're joining the detail table to the booking table. What information is it that you're trying to get...
--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)

November 11, 2011 at 7:46 pm

#1406624
RE: Why is my SELECT query slower when the table is indexed?

raotor (11/10/2011)
I've copied your test script into SSMS and executed it. However, it appears to run extremely slow. Thus far, the script has been running for 3.5 hours!
I can...
--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)

November 11, 2011 at 6:38 am

#1406216
RE: Create temp table object across linked servers

Do it in a stored procedure would be my first guess.
--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)

November 10, 2011 at 8:14 am

#1405798
RE: Using DISTINCT within a JOIN

There are multiple ways to do such a thing. For example, (and depending on the required columns) you could make a CTE for the DISTINCT select on the table...
--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)

November 10, 2011 at 8:05 am

#1405784
RE: Need nudge with logic to use in dynamic SQL statement to delete duplicate FKs

hxkresl (11/10/2011)
Hi there. Sorry, here it is
http://www.sqlservercentral.com/scripts/constraints/71340/ .
Ah... got it. Thanks. My previous comments were based on the code you posted.
--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)

November 10, 2011 at 7:49 am

#1405763
RE: execute stored procedure with order by

Dev @ +91 973 913 6683 (11/10/2011)
GilaMonster (11/10/2011)
Dev @ +91 973 913 6683 (11/10/2011)
daveriya (11/9/2011)
thanks a lot DEV,that's what i was looking ,u solve my problem.
I would love to...
--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)

November 10, 2011 at 7:37 am

#1405748
RE: Need nudge with logic to use in dynamic SQL statement to delete duplicate FKs

hxkresl (11/9/2011)
Hi Jeff. Yep, his sproc identifies duplicate keys, not duplicate names. You can look at it as I've provided the link.
I agree with Jack Corbett. I might simply...
--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)

November 10, 2011 at 6:00 am

#1405677
RE: with format in backup command

rocky@123 (11/9/2011)
As per my requirement i don't want to keep the old backup files in my backupset..so how can i overwrite those backupfies in backup set.I have tried WITH FORMAT...
--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)

November 10, 2011 at 5:58 am

#1405675
RE: How do I determine Free & Total Space for disk drives, using T-SQL?

FreeHansje (10/17/2011)
I'm a bit late at this party, I know, but still:
There is NO way then to get total drive space from tsql alone? We need SOME info from outside...
--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)

November 10, 2011 at 5:55 am

#1405671
RE: Managment Studio. Different PC's give different result for same query.

Scott Levy (11/9/2011)
Just a last update on this if anyone is interested as I think I may have found the source of the inconsistency.
I believe that it was the local...
--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)

November 10, 2011 at 5:07 am

#1405638
RE: execute stored procedure with order by

GilaMonster (11/10/2011)
Dev @ +91 973 913 6683 (11/10/2011)
daveriya (11/9/2011)
thanks a lot DEV,that's what i was looking ,u solve my problem.
I would love to accept Thanks but as Sean &...
--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)

November 10, 2011 at 5:02 am

#1405637
RE: Are the posted questions getting worse?

I don't know if anyone else noticed but Gail isn't just the leading point holder anymore... she's also the leading poster!
[font="Arial Black"]Congrats Gail!!! [/font]
--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)

November 10, 2011 at 4:45 am

#1405629

Viewing 15 posts - 31,966 through 31,980 (of 59,099 total)