Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,256 through 48,270 (of 59,102 total)

RE: Joining the darkside

PaulB (9/18/2008)
abba (9/18/2008)
Syntax will probably be the least of your concerns.
:w00t: I respectfully disagree 🙂
I'll agree with that disagreement... syntax changes will be a doozy. Wait until...
--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)

September 18, 2008 at 2:31 pm

#873921
RE: Can any one help me to prepare basic check list for database server for SQL server 2005.

Jason Wisdom (9/18/2008)
Tune the TempDB.
TempDB is so much more important in SQL 2005 than it was in earlier versions.
And the default settings of 8MB / 1MB with 10% growth 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)

September 18, 2008 at 2:26 pm

#873920
RE: last time table is accessed

Ummm... that'll find the last date a table was SELECTED from?
--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)

September 18, 2008 at 2:20 pm

#873917
RE: Test Environment

If the data is on a SAN, the SAN comes with software to make it easy to do this. Once it's setup (read the documentation that came with 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)

September 18, 2008 at 2:15 pm

#873916
RE: Help with Incremental update in sql server

Without a bit more info about the table and the reason for the update, best I can say is...
SET ROWCOUNT 100000
SELECT 1
WHILE @@ROWCOUNT > 0
BEGIN
.... do your update
END
SET ROWCOUNT 0
--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)

September 18, 2008 at 2:11 pm

#873914
RE: Count the number of spaces in a field

Matt Miller (9/18/2008)
Jeff Moden (9/17/2008)
Mark (9/17/2008)
DECLARE @S VARCHAR(30) SET @S='99202 10060 99000 A6402'
SELECT LEN(@S)-LEN(REPLACE(@S,' ','')) AS NumberOfSpaces
THAT's the way to do it... no RBAR, no join! 🙂
Except...It will return the wrong...
--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)

September 18, 2008 at 1:12 pm

#873876
RE: converting text to int

Thanks!
--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)

September 17, 2008 at 9:51 pm

#873369
RE: functions

Heh... Got it. Thanks. 🙂
--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)

September 17, 2008 at 9:50 pm

#873368
RE: Splitting a String in SQL - Help Please!

Yeaup... still RBAR... but the Tally table get's cached... While loop doesn't. 'Course, you knew that.
If you don't like the Thorn character (used it mostly for visual), Tab character...
--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)

September 17, 2008 at 9:45 pm

#873367
RE: straight query faster than SP!?

The problem is the Cross-Apply's... they resolve to a single row in the execution plan. Query may run ok when running from QA because of cache and stats... likely...
--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)

September 17, 2008 at 9:07 pm

#873363
RE: ~Split ~double~~symbol

karthikeyan (9/17/2008)
How should i split double ~~ symbol into two ?
I hope i have explained enough. Inputs are welcome !
Also i wanted to know whether the way which i...
--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)

September 17, 2008 at 8:58 pm

#873362
RE: Number of Orders Query...

A bit more info is required... please see the link in my signature for faster, better, tested answers....
--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)

September 17, 2008 at 8:52 pm

#873361
RE: Date Format

Dunnor if it works in Integration Services, but I Use STUFF to quickly add a couple of dashes.
--===== Setup a simple test.
-- This is NOT...
--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)

September 17, 2008 at 8:49 pm

#873359
RE: Performance of index defragmentation in SQL Server 2000

When "rebuilding" and index, the index is NOT available for use. That is also true when using DBCC DBReIndex. They are, however, available if you use DBCC IndexDefrag.
--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)

September 17, 2008 at 8:43 pm

#873357
RE: Thank You All

What a cool thing to say, James. 🙂
--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)

September 17, 2008 at 8:24 pm

#873353

Viewing 15 posts - 48,256 through 48,270 (of 59,102 total)