Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,526 through 36,540 (of 59,102 total)

RE: Need help in this query

sql.abhishek (9/20/2010)
Jeff Moden (9/19/2010)
@sql.abhishek,
So! Are you all set or what? If you're all set, would you mind posting your final solution so that others may learn, please? ...
--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 30, 2010 at 11:20 pm

#1230033
RE: Need to zip and move C2 level audit files

ps. (9/21/2010)
Jeff Moden (9/21/2010)[hr
Yep... I pretty much got that from the OP, Pradeep. I'm just trying to figure out a work around without using any 3rd party software so...
--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 30, 2010 at 11:18 pm

#1230032
RE: Poor performance when all RAM allocated, but not in use

So what did they say that particular trace flag does? It's not in BOL.
--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 30, 2010 at 11:13 pm

#1230030
RE: Problem with CURSOR

Nevyn (9/30/2010)
First and foremost, someone is going to point out to you that you probably dont need a cursor here, so it may as well be me.
How would you do...
--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 30, 2010 at 11:07 pm

#1230029
RE: Pulling Filename from Windows directory into table

brianparow (9/20/2010)
Nevermind;
I figured out how to get rid of the trailing spaces within my batch file...
Hi Jeff,
That works great. The only problem I'm having with this is 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 30, 2010 at 11:02 pm

#1230028
RE: bcp question

SQL_Quest-825434 (9/24/2010)
sqlapprentice (9/24/2010)
sjimmo (9/24/2010)
The problem lies in that fact that xp_cmdshell does not recoginize lang windows paths but we can still use shortend path names with tilde (~) in them.
This...
--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 30, 2010 at 10:46 pm

#1230025
RE: Concatenate Results in Row

sinureddi (9/27/2010)
Hi,
Just out of curiosity....
Why is data concatination, just for the sake of "being displayed in the front end", being achieved at the database level. Is this not tying up...
--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 30, 2010 at 10:36 pm

#1230024
RE: concatenating CASE stmt results

Chris Morris-439714 (9/21/2010)
drew.allen (9/21/2010)
Jeff Moden (9/20/2010)
I don't like the short version at all because it "lies".
That's very interesting, but, realistically, how often do people use nondeterministic functions like NEWID() 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)

September 30, 2010 at 10:27 pm

#1230023
RE: D: drive is full and transaction log is full

Ninja's_RGR'us (9/22/2010)
Go in your settings and select 50 posts per page rather than 10. That's take it down to 2 prints!
Topic options, print topic. No need to change...
--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 30, 2010 at 10:19 pm

#1230021
RE: CTE - How to surpass the limit

Sorry... brain freeze... I already responded to this thread.
--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 30, 2010 at 10:11 pm

#1230019
RE: Data Type and Length

David Data (9/27/2010)
But I am curious as to why a VARCHAR(MAX) string that happens to contain say 100 chars is so much slower that a VARCHAR(100) that does? Its...
--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 30, 2010 at 10:05 pm

#1230016
RE: Dynamic columns in ssrs

cpinky01 (9/22/2010)
THANKS FOR REPLYING ME.
THIS I AHVE ACCOMPLISHED BY WRITING THE QUERY THAT RETURNS THE WAY I WANTED IN THE REPORT.
Thank you
Could you post it so we can all see?
--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 30, 2010 at 9:52 pm

#1230014
RE: Export SQL Database to flat file with header(column) name

kailash.vicky2004 (9/29/2010)
rbamania (6/24/2008)
hi,
i have tried bcp, it can dump only table data from sql to txt file- i need column name too. Is their any way to get column name...
--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 30, 2010 at 9:48 pm

#1230011
RE: fn_fixeddrives() : an alternative for xp_fixeddrives

David BAFFALEUF (9/24/2010)
Hi Larry,
Thanks for your comments,
As blessonblessons says, you'll have to use the fully qualified name to be able to call the function from any other database.
It had...
--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 30, 2010 at 9:45 pm

#1230010
RE: I need some help with a test, please.

Ah... by the way. The BETWEEN 1 AND... was to make sure that the code worked correctly just in case someone had a Tally Table of their own 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 30, 2010 at 9:36 pm

#1230008

Viewing 15 posts - 36,526 through 36,540 (of 59,102 total)