Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,036 through 49,050 (of 59,102 total)

RE: Licensing a QA/UAT Server

Thanks for the clarifications, folks... between what has already been posted and what I found at the links included in the following, it turns out that you can have as...
--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)

July 31, 2008 at 9:08 am

#851331
RE: Licensing a QA/UAT Server

Outstanding, Ian... that's just what I was looking for. Thanks for the very quick reply, too!:)
--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)

July 31, 2008 at 8:44 am

#851306
RE: OSQL extremely slow comparing to Query Analyzer?

kubilay husmenoglu (7/31/2008)
Hi, I have exactly the same problem with OSQL.
Does anybody has a solution
I'd recommend you start a new thread for this... it'll get more attention.
--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)

July 31, 2008 at 4:58 am

#851154
RE: UK Cultures

Ross McMicken (7/31/2008)
Public schools in the US are free from age 5 to 18. Unless you live in a place where the schools aren't very good, then you may choose...
--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)

July 31, 2008 at 4:54 am

#851153
RE: LEFT JOIN vs EXCEPT

Oh, yeah... almost forgot... "In the land of the blind, the one eyed man is King!"... That's why most people look at the Execution Plan and believe in 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)

July 30, 2008 at 9:32 pm

#850976
RE: LEFT JOIN vs EXCEPT

I may have to write an article about it someday... I've found that WHERE NOT IN beats the OUTER JOIN type of exclusion, WHERE NOT EXISTS correlated subqueries, and 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)

July 30, 2008 at 8:50 pm

#850971
RE: What is this thing I need to do called?

Heh... reminds me of a dictionary... how can you check the spelling on a word using a dictionary without a bit of luck?
I agree with Matt... UNPIVOT 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)

July 30, 2008 at 8:44 pm

#850970
RE: create a function to make columns into rows

Matt Miller (7/30/2008)
Jeff Moden (7/30/2008)
Heh... space used... the Tally or "Numbers" table only takes 136KB for an 11,000 row table and that includes the clustered index in the form of...
--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)

July 30, 2008 at 8:41 pm

#850968
RE: Query Hints for Performance

usman.tanveer (7/30/2008)
Hi,
Can using (Nolock) or (ReadPass) help gaining performance benefits for select queries?
In my point of view may be we could......like in my scenario......db is accessed by multiple...
--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)

July 30, 2008 at 8:21 pm

#850960
RE: help with substring and cast

steveb (7/30/2008)
No worries,
you could use the Left and Right functions.
I am not aware of any performance difference between the two and couldn't find anything aobut it on BOL.
LEFT...
--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)

July 30, 2008 at 7:47 pm

#850956
RE: Materialized Views

usman.tanveer (7/30/2008)
One of my query is using 4-5 tables using Inner or Left Outer joins.
These tables are the main tables of the Db and contains alot of data. Also multiple...
--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)

July 30, 2008 at 7:44 pm

#850955
RE: Brain on Strike, I need help!

Angelindiego,
If done incorrectly, your CASE statement will turn out to be RBAR on steroids in the form of a correlated subquery. If you want, 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)

July 30, 2008 at 7:36 pm

#850954
RE: Big table update; don't want big transaction log

Since update does not qualify as a non-logging bulk operation, I'd say you'd have to temporarily put the DB in the SIMPLE recovery mode and do the update in, say,...
--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)

July 30, 2008 at 7:20 pm

#850950
RE: Controlling log file growth without limiting size

Matthew O'Gorman (7/30/2008)
Shrinking the log was required in this case to bring the log back to a realistic size, and was the sole purpose of my post. Noone here...
--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)

July 30, 2008 at 7:13 pm

#850948
RE: Stored Procedures Reconsidered

Heh... someone asked me why I've tried to specialize in behind-the-scenes-batch-programing in SQL Server... I believe I'll refer them to this thread. 😛
--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)

July 30, 2008 at 6:41 pm

#850943

Viewing 15 posts - 49,036 through 49,050 (of 59,102 total)