Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,036 through 40,050 (of 59,098 total)

RE: Default database settings in the Login properties.

As a side bar, the default is for SQL Server to give everyone a default of "Master" and that's how a lot of folks end up making stored procs in...
--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)

February 1, 2010 at 10:30 am

#1111796
RE: using temp tables good Idea

You're welcome. Thanks for the comeback.
--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)

January 31, 2010 at 7:16 pm

#1111398
RE: Conditional Set-Based Processing: Moving Towards a Best Practice for ETL

Dan, what are you using to load files into SQL Server at 400k RPS with and how many parallel threads are you using to do that?
--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)

January 31, 2010 at 5:31 pm

#1111389
RE: xp_cmdshell

Tara-1044200 (1/30/2010)
i get this..
Volume in drive \\OBBEVAER\IT_Reports is OBBEVAER_Data
Volume Serial Number is B2BD-B330
NULL
Directory of \\OBBEVAER\IT_Reports\DBANULL
File Not Found
NULL
That means that the login that the SQL Service is starting...
--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)

January 31, 2010 at 5:22 pm

#1111387
RE: Date Range

You bet. Thank you for the feedback.
--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)

January 31, 2010 at 5:18 pm

#1111386
RE: Database Design- IS NOT NULL always better choice?

David Portas (1/31/2010)
Jeff Moden (1/30/2010)
Heh... no, I'm not missing the point. I said virtually the same thing in the first paragraph of my last post.
The thing that made me...
--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)

January 31, 2010 at 5:11 pm

#1111384
RE: Database Design- IS NOT NULL always better choice?

Heh... no, I'm not missing the point. I said virtually the same thing in the first paragraph of my last post.
--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)

January 30, 2010 at 6:56 pm

#1111263
RE: Extract X and Y coordinates out of a string and check if within range

Thanks, Charlotte. Heh... not a star... just a guy who's had to do the same thing before. We have such a grid coordinate system for the US 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)

January 30, 2010 at 6:35 pm

#1111262
RE: using temp tables good Idea

I agree with what Flo said. To go a little bit further, a complex query with a lot of left joins may actually be using TempDB to create work...
--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)

January 30, 2010 at 1:14 pm

#1111239
RE: Database Design- IS NOT NULL always better choice?

Sorry... posted a duplicate post.
--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)

January 30, 2010 at 11:11 am

#1111213
RE: Index Where Name = NULL

Not to mention the space savings on disk if any deletes occurred on the heaps.
--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)

January 30, 2010 at 11:00 am

#1111212
RE: Database Design- IS NOT NULL always better choice?

True enough. If you define "X" as being unknown and compare the same two unknowns, they are equally unknown... by definition. If SQL Server really knew what Unknown...
--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)

January 30, 2010 at 10:53 am

#1111211
RE: query taking a lot of time.

Was that the actual execution plan or the estimated execution plan attached in the first post? The reason why I ask is because all of the rows have been...
--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)

January 30, 2010 at 10:40 am

#1111210
RE: xp_cmdshell

Sounds silly but did you hit "refresh" when you looked in the destination folder?
--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)

January 30, 2010 at 10:35 am

#1111206
RE: Extract X and Y coordinates out of a string and check if within range

Since this is going to be a stored procedure, my recommendation would be to peel just on potato at a time. Let's split the coordinate pairs into a more...
--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)

January 30, 2010 at 10:15 am

#1111199

Viewing 15 posts - 40,036 through 40,050 (of 59,098 total)