Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,801 through 52,815 (of 59,072 total)

RE: DBCC PINTABLE - What is actually pinned

Also, not sure why you'd bother pinning it... it will certainly fit in cache.
--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 18, 2008 at 7:44 pm

#769920
RE: TempDB is 13gigs and growing

17GB seems a bit large even if it's a Terabyte instance... if folks are using triangular joins, cursors for large record sets, temp tables for large record sets, views 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)

January 18, 2008 at 7:41 pm

#769919
RE: BULK INSERT & Text Qualifier

remember this code was done based on BOL examples, but I don't remember the topic.
First, nice idea... hadn't thought about doing it that way. Great way to import...
--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 18, 2008 at 7:07 pm

#769918
RE: BULK INSERT & Text Qualifier

Sergiy (1/14/2008)
All of you are wrong.
Using "," as delimites is an error waiting to happen.
mdjtlj, ask you supplier to build a test file containing '19" Monitor'.
Then try to process 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 18, 2008 at 7:05 pm

#769917
RE: How to combine aggregate function with * in SELECT?

My question is: is there any way I can achieve this goal without the GROUP By phrase?
I could be wrong, but I don't think there 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)

January 18, 2008 at 6:33 pm

#769915
RE: Drop constraint if exists

Alter table won't support a 4 part naming convention, anyway... object functions and Alter table all support 3 part naming conventions... why not use them?
--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 18, 2008 at 5:19 pm

#769910
RE: How to combine aggregate function with * in SELECT?

If you have 20 columns in table A, and you try to list all 20 columns in the presence of a COUNT, then you must list all 20 columns 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)

January 18, 2008 at 5:13 pm

#769909
RE: Group BY question

Shoot... I hope I didn't just help someone do their homework without them trying themselves, first...
--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 18, 2008 at 5:08 pm

#769908
RE: Group BY question

This will do it... assuming that names are unique...
--===== Simulate the OPs table
-- This is NOT part of the solution
DECLARE @yourtable 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)

January 18, 2008 at 5:06 pm

#769907
RE: Stripping out double quotes (") in bulk insert

Thanks... that's half the battle... 😉
Do you have any documentation on the record layout of the file you intend to import? And can you attach a file 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)

January 18, 2008 at 4:40 pm

#769905
RE: Date Check

Heh... yep, I knew that Michael... sorry I didn't state things clearly... I wanted to know the condition of the OPs data.
--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 18, 2008 at 12:53 pm

#769856
RE: Date Check

Just curious... I can see where a NULL end date could be interpreted as 31 Dec 9999, but what does a NULL start date indicate other than something hasn't started?...
--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 18, 2008 at 11:04 am

#769800
RE: Format Date in SQL Table

GSquared (1/18/2008)
He's already mentioned that the column is being changed to datetime. He just wants to reformat it first (didn't say why). So, he's on the right track...
--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 18, 2008 at 10:59 am

#769798
RE: Running a Query Using a Text File for Input

Very good comprehensive article. I just don't understand why a simple BULK INSERT couldn't be used to populate a temp 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)

January 18, 2008 at 10:57 am

#769796
RE: How do I increment a DB id

If I remember correctly, @@IDENTITY has all the potential problems you describe including grabbing from the wrong table in the presence of triggers. I've never seen Scope_Identity fail 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)

January 18, 2008 at 8:20 am

#769690

Viewing 15 posts - 52,801 through 52,815 (of 59,072 total)