Viewing 15 posts - 39,721 through 39,735 (of 59,072 total)
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
Change is inevitable... Change for the better is not.
February 18, 2010 at 7:13 pm
sqlserver12345 (2/18/2010)
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
Change is inevitable... Change for the better is not.
February 18, 2010 at 6:45 pm
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
Change is inevitable... Change for the better is not.
February 18, 2010 at 6:38 pm
charles-869346 (2/18/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
February 18, 2010 at 6:17 pm
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
Change is inevitable... Change for the better is not.
February 18, 2010 at 5:46 pm
Priya11 (2/18/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
February 18, 2010 at 5:42 pm
plaid_draco (2/17/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
February 17, 2010 at 7:40 pm
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
Change is inevitable... Change for the better is not.
February 17, 2010 at 7:34 pm
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
Change is inevitable... Change for the better is not.
February 17, 2010 at 7:27 pm
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
Change is inevitable... Change for the better is not.
February 17, 2010 at 7:16 pm
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
Change is inevitable... Change for the better is not.
February 17, 2010 at 7:14 pm
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
Change is inevitable... Change for the better is not.
February 17, 2010 at 7:02 pm
Denis W. Repke (2/17/2010)
Cannot bulk load. The file "C:\TestBook.xml" does not...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 17, 2010 at 6:36 pm
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
Change is inevitable... Change for the better is not.
February 17, 2010 at 6:30 pm
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
Change is inevitable... Change for the better is not.
February 17, 2010 at 3:06 pm
Viewing 15 posts - 39,721 through 39,735 (of 59,072 total)