Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,646 through 42,660 (of 59,067 total)

RE: Server Consolidation - What to measure to determine if you should

Jack Corbett (7/31/2009)
Just got an email from a former employer asking for my review of a server they are looking at buying to consolidate several (3-5) older sql servers on...
--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)

July 31, 2009 at 3:27 pm

#1033183
RE: ANSI PADDING, Trailing Whitespace, and Variable Length Character Colum

Matt Campbell (7/31/2009)
I take no chances when it comes to SQL Server and trailing spaces. I always use LTRIM(RTRIM(col_name))when selecting data or updating data if the field is any...
--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)

July 31, 2009 at 10:46 am

#1033068
RE: Pulling Filename from Windows directory into table

Look at the section of the code that I provided called "Usage:" 😉
--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)

July 31, 2009 at 10:32 am

#1033062
RE: How to do a reinstall of SQL Server 2005 Dev Edition after a nasty mistake.

rlondon (7/31/2009)
Jeff Moden (7/30/2009)
Lynn Pettis (7/30/2009)
Is there a more detailed error message in this file: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_JMODEN2_MSXML6_1.log?
Yep.... it's quite long so I'll post the only line 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)

July 31, 2009 at 10:22 am

#1033059
RE: You are being asked, Your tempdb is full How do you troubleshoot...

I strongly agree with what Gail said. I'll also ask folks to consider the following... there are some extremely heavy hitters who have certs out the whazoo and some,...
--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)

July 31, 2009 at 10:04 am

#1033048
RE: Are the posted questions getting worse?

RBarryYoung (7/31/2009)
Jeff Moden (7/30/2009)
It probably won't do the world any good at all, but I feel MUCH better now...
http://www.sqlservercentral.com/Forums/Topic762623-146-1.aspx
Is it just me? Or is this just some cultural thing?...
--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)

July 31, 2009 at 6:45 am

#1032892
RE: You are being asked, Your tempdb is full How do you troubleshoot...

Now that I've at least made the attempt to extract the tennis shoe laces from my mouth, Grant hit the nail on the head. TempDB is one of 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)

July 31, 2009 at 6:38 am

#1032889
RE: You are being asked, Your tempdb is full How do you troubleshoot...

Rajesh kasturi (7/31/2009)
Jeff,
I knew some ways to get rid of tempdb issue.
Why I posted the question is,
Who expects reply to this quesion.
I agree with you, I am still...
--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)

July 31, 2009 at 6:19 am

#1032883
RE: Is it legal to use Developer edition in QA environment??

Thanks Lynn. I know where the EULA's are... I was trying to spike some curiosity on the part of the OP.
As a side bar, the odd part...
--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)

July 30, 2009 at 10:33 pm

#1032781
RE: Is it legal to use Developer edition in QA environment??

Thanks Lynn. I know where the EULA's are... I was trying to spike some curiosity on the part of the OP.
The odd part is that the quirky...
--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)

July 30, 2009 at 10:24 pm

#1032779
RE: Are the posted questions getting worse?

It probably won't do the world any good at all, but I feel MUCH better now...
http://www.sqlservercentral.com/Forums/Topic762623-146-1.aspx
--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)

July 30, 2009 at 8:12 pm

#1032765
RE: You are being asked, Your tempdb is full How do you troubleshoot...

Rajesh kasturi (7/30/2009)
I do not why people ask this question often even though they are not facing this issue....
It's a very typical question asked of people with the words "SQL...
--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)

July 30, 2009 at 7:55 pm

#1032762
RE: Row distribution to rows from another table

Raul Undreiner (7/30/2009)
I'm sorry for being vague in my post.
I need the query to make this distribution only once per day. This means that all available (not previously assigned) cases...
--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)

July 30, 2009 at 6:27 pm

#1032758
RE: any way to make a view "pre-render"

Post the view...
--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)

July 30, 2009 at 6:16 pm

#1032757
RE: Identity column starts from zero instead of one

vkelman (7/29/2009)
SQL Server set identity field value of that first record to 0 instead of 1!
Uh huh... and where is that value coming from? I mean, what is 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)

July 30, 2009 at 6:14 pm

#1032756

Viewing 15 posts - 42,646 through 42,660 (of 59,067 total)