Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,991 through 49,005 (of 59,093 total)

RE: Oracle books for Sql server DBA

PaulB (8/2/2008)
I've been there, I done that.
1 Brace for impact, keep your poker face no matter what you see.
2 All Oracle documentation is online and free... try http://www.oracle.com/pls/db102/portal.all_books
3 Subscribe 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)

August 2, 2008 at 11:17 am

#852336
RE: comparing 2 consecutive rows in SQL

If it's only for two flights, then a simple join between destination of first flight and start of second flight for a given passenger number should do it.
If you want...
--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)

August 2, 2008 at 11:00 am

#852332
RE: Copy comma delimitted text file to a table by ascending order

I agree with Steve... doesn't matter what the insert order is, you should use ORDER BY in your queries and NOT rely on a physical order. You can force...
--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)

August 2, 2008 at 9:51 am

#852324
RE: Beat this - comic relief for the day

What I think is interesting about that blog, is that it's the person writing the blog who is sometimes the "dumbass". One guy wrote about the ol' turbo button...
--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)

August 2, 2008 at 8:43 am

#852315
RE: Create table with table name passed by proc !

That's correct... I missed that little "nuance"...
The code needs to look like this... Note the parentheses around @ExStr in the EXEC statement.
DECLARE @ExStr varchar(500)
SET @ExStr = 'CREATE TABLE dbo._X080805...
--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)

August 2, 2008 at 8:19 am

#852314
RE: Evaluation Expired!

jon.hart (7/30/2008)
I'm using a machine dedicated to this SQL 2008 evaluation. VMs do not provide a genuine real worl experience, whatever Microsoft say. Yes I can uninstall and...
--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)

August 1, 2008 at 11:09 pm

#852280
RE: Create table with table name passed by proc !

Put the table name in brackets.
--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)

August 1, 2008 at 11:05 pm

#852279
RE: long digit number to a decimal one

Based on the previous questions asked by Lateesh, I'm gonna say this isn't homework...
SELECT STR(STUFF(1234567,4,0,'.') ,5,1)
--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)

August 1, 2008 at 10:59 pm

#852278
RE: Money vs. Decimal Data type

It depends... if you're not going to do anything to the values other than add or subtract... no problems. If you're going to do anything else (like multiply or...
--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)

August 1, 2008 at 9:58 pm

#852275
RE: How to get Sequential ordering of data based on Ids Passed to IN Keyword

Chris Morris (8/1/2008)
Hi Meeraj, apologies for the delay in replying to you.
Here's a script for creating a Numbers or Tally table, which you will see often on this forum.
IF...
--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)

August 1, 2008 at 9:55 pm

#852274
RE: EXEC() results to populate cursor

With the advent of VARCHAR(MAX), there's just no need for cursors anymore... for example...
DECLARE @sql VARCHAR(MAX)
SELECT @sql = COALESCE(@SQL+CHAR(10)+' UNION ALL --------------------'+CHAR(10),'')
+REPLACE(
' SELECT '' '' 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)

August 1, 2008 at 9:46 pm

#852273
RE: Cursor vs. Common Table Expression

KMM (8/1/2008)
I'm using Sql Server 2005
I got the idea of converting my cursor into a CTE from this website:
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/05/11/common-table-expressions-cte-s-how-it-works-how-recursion-works-using-with-adjacency-list.aspx
Nah... don't bother changing it if you're just going to use recurrsion....
--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)

August 1, 2008 at 9:15 pm

#852271
RE: Not like '%%'

As Ryan suggested, you should consider NOT storing delimited data in a single column...
If it's not something you can control, then Vaseem was on the right track. Even with...
--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)

August 1, 2008 at 9:07 pm

#852270
RE: A question about the Decimal data type

Simple test proves it...
SELECT 1, CAST(1.23 AS DECIMAL(5,2))
SELECT 2, CAST(12.34 AS DECIMAL(5,2))
SELECT 3, CAST(123.45 AS DECIMAL(5,2))
SELECT 4, CAST(1234.56 AS DECIMAL(5,2))
--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)

August 1, 2008 at 8:54 pm

#852268
RE: long running quries

Sure... but the methods are all worse than using profiler... why the profiler phobia?
--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)

August 1, 2008 at 8:40 pm

#852267

Viewing 15 posts - 48,991 through 49,005 (of 59,093 total)