Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,576 through 40,590 (of 59,098 total)

RE: Create a new column with criteria

This is an "Ordinal Rank" problem. The following has your SQL Server 2000 answer along with a code example and all the things you must do to pull 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)

December 21, 2009 at 8:03 pm

#1095217
RE: Identity column maxed out

homebrew01 (12/21/2009)
CirquedeSQLeil (12/21/2009)
Then a simple select * into tablebackup12212009 from table would suffice for the backup.
I seem to recall that you can get blocking when creating a table this way...
--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)

December 21, 2009 at 7:41 pm

#1095212
RE: could someone please help to improve the performance of this store proc,it takes 2hrs 30mins to execute

Heh... you have a triangular join, a while loop, and XML and still want to know why this is slow? 😉
--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)

December 21, 2009 at 7:39 pm

#1095211
RE: DR type

Yes I could... but since this is likely an interview question or homework question and one of the skills a DBA must demonstrate is how to find out answers 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)

December 21, 2009 at 7:36 pm

#1095210
RE: Question of the Day for 21 Dec 2009

BWAA-HAA!!! Frosty needs to get a set-based decoder ring! 😛
DECLARE @ToAllGoodPeople TABLE
(
RowNum INT,
...
--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)

December 21, 2009 at 7:24 pm

#1095206
RE: SSIS - ForEach From Variable Enumerator

In plain English, what is it that you're trying to 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)

December 21, 2009 at 6:07 pm

#1095199
RE: Autogrowth out of control

Before you set autogrow to anything, you need to find out what is causing the autogrowth. Like you've said, you've probably patched beyond the point of the fault. ...
--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)

December 21, 2009 at 6:02 pm

#1095198
RE: bcp doesn't close files

BCP won't hold a table open like that. Something else has a grip on the table.
--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)

December 21, 2009 at 5:55 pm

#1095196
RE: Looking for some fundamental help automating a query

Ok... so let's peel one potato at a time. My first question would be.... did you try just removing the "GO"'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)

December 21, 2009 at 5:50 pm

#1095195
RE: Confusing set of strings!

So, you're all set then?
--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)

December 21, 2009 at 5:48 pm

#1095194
RE: cursors and order by

The problem isn't with how cursors work... the problem is with how databases work. For SELECT statements, the only way to guarantee an order of the result set 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)

December 21, 2009 at 8:46 am

#1094809
RE: enable/disable xp_cmdshell before/after Windows schedule task

calico-604598 (12/20/2009)
Hi,
With SQL Server 2005 Expresse Edition CMDSHELL can be enable / disable with sp_configure or with surface area.
I ask this question because I dont want to manually enable...
--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)

December 21, 2009 at 8:01 am

#1094779
RE: Mean, Median, Mode

Thanks, Daipayan,
Just wanted to make sure you were covered on this. Lot's of folks simply do it wrong and they end up with a huge performance problem on their...
--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)

December 21, 2009 at 7:58 am

#1094777
RE: Exporting to Excel Using a CLR Stored Procedure

SQL Server is running the CLR... SQL Server must be runing as a user that has the privs to "see" the UNC.
--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)

December 21, 2009 at 7:55 am

#1094776
RE: trimming trailing spaces and zeros from a string

Heh... got it and thanks for taking the time to explain.
Depending on how you're pushing that to Excel, it's likely that the trailing 0's just won't matter... Excel...
--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)

December 21, 2009 at 7:53 am

#1094773

Viewing 15 posts - 40,576 through 40,590 (of 59,098 total)