Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,066 through 49,080 (of 59,093 total)

RE: Delete ALL records where table join produces values

How did you verify that? Is it just because you got a rows affected of 1? Perhaps there was only one row that met the condition?
What do you...
--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 25, 2008 at 4:46 am

#848293
RE: XP_cmdshell DIR

Deee -Daah! (7/24/2008)
Hi experts,
I was wondering if there is an alternative to running XP_cmdshell DIR.
Basically, I run xp_cmdshell to gather file info on a folder.
without using XP_cmdshell, is there other...
--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 25, 2008 at 4:31 am

#848281
RE: regarding performance

su_kumar11 (7/25/2008)
The site you have given is not opening. So
So
Please give me solution.
Try copying the URL and pasting it to the address window in your browser.
--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 25, 2008 at 4:15 am

#848277
RE: Delete ALL records where table join produces values

Untested, of course... 😉
DELETE dbo.abn_extract
FROM dbo.abn_extract E
INNER JOIN dbo.ABN_File_Header H
ON SUBSTRING(E.[Column 0], 1, 13) = H.Header_Id
SQL Server 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 25, 2008 at 4:06 am

#848275
RE: Given an employee table( with columns Emp_ID,Emp_Name,Emp_Salary), how would you find out the fifth highest salary?

avanish (7/24/2008)
Rather than writing comples queries .... yo u can use the ranking functions... in sql server 2005 for this purpose:)
Perfect... got a code example to go along with 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)

July 25, 2008 at 3:51 am

#848274
RE: Dumb Question

Just double checking... Was the mirror made using SQL Server Replication or (disk) hardware replication.
--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 24, 2008 at 5:42 pm

#848149
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

Gary Noter (7/24/2008)
This example code is a TOTAL waste of my time.
No, wait, if I implement this code, then can't waste my time with writing and waiting for WHILE loops...
--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 24, 2008 at 5:40 pm

#848148
RE: The IT Employee Benchmark

I've found that nothing helps except a good ol' fashioned technical interview. I've had several people where references checked out great... old bosses gave rave reviews... former co-workers gave...
--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 24, 2008 at 5:37 pm

#848147
RE: Updating through cursors

Thanks for the feedback, Hugo,
I explained why a merry-go-round scan is not possible for this in the article. I even demonstrated what a merry-go-round scan is... updates don't 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)

July 24, 2008 at 5:30 pm

#848146
RE: Test Data

Cool... thanks for the feedback, Lynn. And, glad it all work.
Michael, nice job if you don't mind me saying 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)

July 24, 2008 at 5:15 pm

#848145
RE: Handling Tempdb space full situtation?

ALIF (7/24/2008)
either use this things
shrink tempdb,
or
detach the file and attach with a new one with 0 bytes
or still you cant do
just restart the sql services, everything will be refreshed.
Shrinking...
--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 24, 2008 at 5:13 pm

#848142
RE: Handling Tempdb space full situtation?

GilaMonster (7/24/2008)
angie stein (7/24/2008)
Brandie Tarvin (7/24/2008)
Does this technobabble make sense?
Ok, so it sounds like you should usually restrict the growth (esp. in prod), unless there's a good reason 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)

July 24, 2008 at 5:04 pm

#848140
RE: Handling Tempdb space full situtation?

nisan.al (7/24/2008)
You are right, to put a limitation is always good.
But by the way, tempdb doesn't have to be in the same drive as the operation system you can 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)

July 24, 2008 at 6:08 am

#847661
RE: Updating through cursors

Thanks for taking the time for that feedback, Hugo. I appreciate it.
Running totals are no excuse for using cursors... not even for display.
http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
So far as the "bin packing" 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 24, 2008 at 6:05 am

#847657
RE: Updating through cursors

or because you run into one of the very rare problems where a cursor actually runs faster than a set-based solution
Hi Hugo,
Do you have an example of when that might...
--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 24, 2008 at 5:25 am

#847639

Viewing 15 posts - 49,066 through 49,080 (of 59,093 total)