Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,971 through 41,985 (of 59,067 total)

RE: Slow running Select query

It may simply have to do with the order of the data. If one or the other inserts in the same order as the clustered index, there will 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:08 am

#1052162
RE: specifying a text qualifier when outputing to file

Unfortunately, lot's of things don't even consider the "real" CSV format anymore. Take a look at the QUOTENAME function in Books Online. You'll need to build the correct...
--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:02 am

#1052160
RE: how to count data in different ids

I believe this would do (not near an SQL Server right now so can't test)...
SELECT ROW_NUMBER() OVER (ORDER BY Product) AS TempID,
...
--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:46 am

#1052154
RE: SQLBits

I'm curious... what do you have against UniSys?
--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:41 am

#1052152
RE: Changing Usernames

Great idea. Thanks folks.
--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:06 am

#1052141
RE: Help with BCP format error

I'm not anywhere near an SQL Server for about the next 4-5 days so I can't provide tested code. However, I can tell you what the problem is... BCP...
--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 2:31 am

#1052129
RE: Using OPENROWSET to import Excel

That's one of the things I don't like about the 64 bit version... no JET drivers.
--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 2:04 am

#1052124
RE: T-SQL Stumper

John,
Both solutions above use a wonderful little tool known as a "Tally" or "Numbers" table. To see how to build one as well as a detailed explanation as to...
--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:55 am

#1052120
RE: Gotcha with dates

I guess my question would be... why did you bother writing this as a CLR?
--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 am

#1052108
RE: how much RAM(memory) used by sql server 2005

I've not had to actually setup a production server in quite some time... I've usually had the pleasure of a "System's DBA" setting them up in all the jobs I've...
--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:19 am

#1052103
RE: Reasons to use PRIMARY KEY?

David Portas (9/10/2009)
Jeff Moden (9/9/2009)
Ummm... I really want my doctor to know the differerence between a transverse colon and a descending colon even though they're both just a part 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)

September 10, 2009 at 4:14 pm

#1052022
RE: Interview questions for SSRS 2005

Sure... no problem. 😉
http://www.lmgtfy.com/?q=interview+questions+for+SSRS+2005+
--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 9, 2009 at 10:50 pm

#1051559
RE: Must declare the scalar variable '%s'.

New2SQL (9/9/2009)
However, my intention is not to use the temp table inside the procedure
Why not? Both Temp Tables and Table Variables start out in memory and both spill...
--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 9, 2009 at 10:41 pm

#1051556
RE: Cross Server Inserts

Paul White (9/9/2009)
Yikes Rog, that sounds like a bit of a nightmare.
Nevertheless, we all have to do stuff we'd rather not sometimes, so let's see...
Rather than try to do 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 9, 2009 at 10:33 pm

#1051555
RE: query optimisation

ramuvanparti (9/9/2009)
select ltrim(rtrim(col1)) from tab
where col2 = 12
or
select col1 from tab
where col2 = 12
clustered index is present on col2 and non-clustered on col1
which query is more optimal.
I'd recommend...
--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 9, 2009 at 10:27 pm

#1051554

Viewing 15 posts - 41,971 through 41,985 (of 59,067 total)