Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,956 through 41,970 (of 59,067 total)

RE: SELECT * versus SELECT 1 when using EXISTS

I agree. I also agree with very specifically with what Adam said. Even if the pros say something, you should always test it yourself. The reason 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 11, 2009 at 8:45 pm

#1052631
RE: CPU utilization going 100% while running a select query.

kiran.kamuganti (9/11/2009)
Hi All,
An issue was raised by a user saying that select process is very slow on the database.
I checked with with the same query and observed that, 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 11, 2009 at 8:42 pm

#1052629
RE: Which is the fastest way to move a table from one DB to another ?

SELECT *
INTO NewDb.NewSchema.NewTable
FROM Olddb.OldSchema.OldTable
Then, script the indexes and constraints and run those.
I'm not near an SQL Server right now and I forget if Identity columns will remain as Identity columns...
--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 11, 2009 at 8:36 pm

#1052627
RE: How do I wildcard search all columns in a database?

Lowell (9/11/2009)
Seth thank you for the compliment! it means a lot coming from someone like yourself, who spends a lot of time trying to help folks here.
i guess the issue...
--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 11, 2009 at 8:31 pm

#1052626
RE: Moore's Law

As a performance-tuning consultant, I anxiously await the next revelation in CPU's, Memory, and the impending explosion of solid state storage devices... which will, of course be followed by 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 11, 2009 at 8:12 pm

#1052623
RE: Changing Usernames

Jamie Batiste (9/11/2009)
I'd love to see your corrective T-SQL Steve - good article material. I want to see timings using complex SQL, use of temporary tables and for Jeff M's...
--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 11, 2009 at 5:01 pm

#1052615
RE: SQLBits

Zowie! I've worked for some bad companies before but never had anything quite that bad happen. Usually the aberrant manager got educated or greased long before something 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)

September 11, 2009 at 4:52 pm

#1052611
RE: Very slow response times.

Actually, I apologize... I had my trobleshooting hat on. It's actually none of my business and you folks have been making constant improvements to the site and the user...
--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 11, 2009 at 4:41 pm

#1052610
RE: Help with BCP format error

MountainBig (9/11/2009)
I tried using all the variations of -r "/n" -r/n or -r"square" -r"0x0D" -r0x0D with spaces without spaces but still 0 rows copied. maybe the bulk insert might be...
--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 11, 2009 at 4:33 pm

#1052608
RE: Delete Duplicate values

Thank you for the feedback... Kenny actually did all the heavy lifting, though.
Thanks, Ken.
--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 11, 2009 at 4:07 pm

#1052601
RE: Using the Best

rja.carnegie (9/11/2009)
We get it, you hate non-set-based programming. But sometimes an exercise has to consist of more than one SQL statement. And while only in unusual circumstances should...
--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 11, 2009 at 3:34 pm

#1052591
RE: Very slow response times.

I guess I'd have to ask, "What changed?" This didn't use to happen ever.
--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 11, 2009 at 1:57 pm

#1052546
RE: Are the posted questions getting worse?

Grant Fritchey (9/11/2009)
Jack Corbett (9/11/2009)
Silverfox (9/11/2009)
Do you know what really frustates me at times, is when someone posts after you have posted, and says, yes that is correct or says...
--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 11, 2009 at 1:49 pm

#1052540
RE: Memory pressure when calling a C# assembly

Jeff Moden (9/8/2009)
I can't help on the problem you're having, Daniel, but I am curious... what does the CLR do?
Heh... you can avoid all this memory problem stuff by avoiding...
--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 11, 2009 at 1:34 pm

#1052533
RE: Help with BCP format error

Sorry for the delay.
You really need to find out what the character number of the little square box is because, at this point, we don't know if it's a Cr...
--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 11, 2009 at 1:29 pm

#1052529

Viewing 15 posts - 41,956 through 41,970 (of 59,067 total)