Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,676 through 42,690 (of 59,102 total)

RE: Import Performance

I believe the two methods use two different 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)

July 31, 2009 at 6:21 pm

#1033221
RE: Display hyperlinks in results

I don't believe so... not from SSMS anyway...
--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:17 pm

#1033220
RE: delete duplicate records based on unique keys
I believe this is what shamassaeedmr was after... it doesn't require a temp table, it leaves only the required rows, and it's nasty fast...
```
--===== As the others have done, create...
```
--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 5:58 pm

#1033218
RE: delete duplicate records based on unique keys

shamassaeedmr (7/31/2009)
try this one
i want to delete the duplicate records based on regno and leavetypeid. Output should be like this:
Delete from
(
Select rank() over (partition by regno,leavetypid order by regno)...
--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 5:21 pm

#1033211
RE: How come I can't delete my topics?

There was a rash of people deleting their original posts once they had an answer. There were also some people who started deleting their own posts because they got...
--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 5:03 pm

#1033208
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

Viewing 15 posts - 42,676 through 42,690 (of 59,102 total)