Jeff Moden

Forum Replies Created

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

RE: True WHOLE NUMBER function.

You already have a true whole number function and it works well. The only problem is with how you tested it... you've passed a numeric value to the function...
--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 26, 2008 at 8:52 am

#848772
RE: Recommended Hardware Specs

SQL Noob (7/25/2008)
what problems? we've been using for a year and it's been OK
if it wasn't for 64 bit SQL we would have to go to 64bit Oracle because 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 26, 2008 at 8:05 am

#848770
RE: XP_cmdshell DIR

Try this, Michael... It's not done yet, but it'll do what you want without hitting up xp_CmdShell....
CREATE PROCEDURE dbo.GetDirDetails
/**************************************************************************************************
Purpose:
Replacement code for the sp_GetFileDetails proc that was available 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 25, 2008 at 8:46 pm

#848745
RE: Dumb Question

GSquared (7/25/2008)
I was wrong.
Just tested it. Transactional replication from one instance to another. Updates, inserts, deletes, all transfer successfully (and immediately).
Truncate gets this error:
Msg 4711, Level 16, State...
--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 6:03 pm

#848735
RE: UDF execution through a CLR

Jonathan Kehayias (7/23/2008)
Jeff,
Perhaps in my attempt to demonstrate an overly simplistic TSQL Example, I made it far to simple. The OP wants to SELECT a value from any column...
--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 5:52 pm

#848732
RE: Recommended Hardware Specs

Heh... with all the problems I've seen on forums with 64 bit technology and SQL Server, so far... I'm going to wait for SQL Server 2011 before I recommend 64...
--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 5:47 pm

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

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