Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,721 through 39,735 (of 59,072 total)

RE: Calculating distance between 2 Easting & Northing values (UK)

lmu92 (2/18/2010)
The Pythagoras will loose precision the longer the distance of the two points will get (increasig influence of the spherical shape)
Not if it's a true "Grid" reference like 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)

February 18, 2010 at 7:13 pm

#1121529
RE: Performance

sqlserver12345 (2/18/2010)
I have a stored procedure where
First : I drop a table table1...with 50000 rows(col 1 int(5), col2 varchar(8000)...col2 has delimited data with 26 '|' so it has...
--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)

February 18, 2010 at 6:45 pm

#1121515
RE: HELP. multipart identifier could not be bound

Maybe I'm just not looking deep enough but does anyone actually see anything in the dynamic SQL that actually requires it to be dynamic?
--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)

February 18, 2010 at 6:38 pm

#1121511
RE: Database Performance

charles-869346 (2/18/2010)
I am currently working with a database that another company designed. They have created many tables where many of the columns are not used. Also, they created...
--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)

February 18, 2010 at 6:17 pm

#1121500
RE: How to modify 'system stored procedure' SQL 2008?

I'll throw in my 2 cents, as well. Do not ever modify a system stored procedure. If you need some of the functionality with an "insane" change, 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)

February 18, 2010 at 5:46 pm

#1121492
RE: Issue with the while loop

Priya11 (2/18/2010)
I have an ExtendedSP that returns an Encrypted Value of the CreditCard No.s. I would have to use an Update statement to replace the unencrypted value with the encrypted...
--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)

February 18, 2010 at 5:42 pm

#1121491
RE: TempDB Size not Dropping

plaid_draco (2/17/2010)
I have a server with tempdb size that shot from 5GB to 10GB in a very short time. I know why the size jump occurred but am confused...
--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)

February 17, 2010 at 7:40 pm

#1120615
RE: Scheduled SQL query output to file

Either setup an SSIS task to do it or a secure "proxy" to turn on, use, and turn off xp_CmdShell just long enough to use BCP.
Another way to do it...
--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)

February 17, 2010 at 7:34 pm

#1120614
RE: Shouldn't system databases also be backed up?

GT-897544 (2/17/2010)
Yes\No, because it is very rare you restore system databases, but no harm in taking system databases as they take little space. Include them in maintenance job.
EnjoY!
There is never...
--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)

February 17, 2010 at 7:27 pm

#1120613
RE: SQL Server 2008 running 50% faster on desktop than server - what to look for?

Sorry... I have one more question... why are you trying to return 900k rows to the display, anyway? It's not like you're going to be able to read 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)

February 17, 2010 at 7:16 pm

#1120609
RE: SQL Server 2008 running 50% faster on desktop than server - what to look for?

Hmmm... wait a minute. One more question to ask... in relation to the "fast" desktop server, where is the "slow" SQL Server? Here's what I mean by 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)

February 17, 2010 at 7:14 pm

#1120608
RE: Import Excel Spreadsheet to Database Tables

I've not tried any of the code examples but the article looks to be a good one and I can't/won't take anything away from the author or the article. ...
--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)

February 17, 2010 at 7:02 pm

#1120606
RE: Import Excel Spreadsheet to Database Tables

Denis W. Repke (2/17/2010)
I tried your code on a WinXP 64-bit workstation connected to SQL Server 2008 64-bit. I always get this error:
Cannot bulk load. The file "C:\TestBook.xml" does not...
--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)

February 17, 2010 at 6:36 pm

#1120598
RE: Import Excel Spreadsheet to Database Tables

Servercentral-1016448 (2/17/2010)
For import of csv files i would go for someting like this:
SELECT *
INTO tabelA
FROM OPENROWSET('MSDASQL',
'Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=C:\Data;','select * from tabelB.csv')
You could just use BULK INSERT which will...
--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)

February 17, 2010 at 6:30 pm

#1120596
RE: How To insert between Records

Dave Ballantyne (2/17/2010)
Jeff Moden (2/16/2010)
The void process I'm familiar with in the U.S.A doesn't actually do a "void"... they create a record with the negative value of whatever the transaction...
--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)

February 17, 2010 at 3:06 pm

#1120506

Viewing 15 posts - 39,721 through 39,735 (of 59,072 total)