Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,131 through 47,145 (of 59,101 total)

RE: The Joy of Numbers

I've just gotta ask... what did you need the 1 Billion row numbers table for?
--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)

November 19, 2008 at 6:46 pm

#900815
RE: Can Express write to 2005 tables?

Ok... I think I found an answer that's good enough... the feature list at the following URL says that "Distributed Queries" are supported in SQL Server Express...
http://msdn.microsoft.com/en-us/library/ms143761(SQL.90).aspx
... and BOL says...
--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)

November 19, 2008 at 2:48 pm

#900747
RE: Faster Deletes

Dugi (11/19/2008)
wOOOps I didn't see the nr of records for deletion! Sorry for that! This is the reason that the suggestion must tested on the test environment to be sure...
--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)

November 19, 2008 at 6:23 am

#900471
RE: Help with Money and Decimal datatype

The answer is that you probably want to line up decimal points among all values with commas, anyway. So, do this...
[font="Courier New"]SELECT REPLACE(STUFF(STUFF(STUFF(STR(1234.7656422,16,4),9,0,','),6,0,','),3,0,','),' ,',' ')[/font]
Still want to know...
--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)

November 19, 2008 at 12:07 am

#900353
RE: Help with Money and Decimal datatype

karthikeyan (11/18/2008)
Hi All,
I have the below scenario.
select convert(varchar(30),convert(decimal(18,4),234543242.7656422),1)
is showing
234543242.7656
Since i need the result set with comma seperated i used the below query.
select convert(varchar(30),convert(money,234543242.7656422),1)
is showing
234,543,242.77
But.... The problem is it 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)

November 18, 2008 at 11:41 pm

#900343
RE: Faster Deletes

If you want to delete only 37,000 rows, it should take only six seconds. Do you have any triggers on the table? Does anyone have an uncommitted 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)

November 18, 2008 at 11:31 pm

#900341
RE: Grouping By the Number of Days

Adi... the link in your signature line is broken... it should be...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Notice... no trailing square bracket.
And, thanks for including it. Wish we could get everyone to do 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)

November 18, 2008 at 10:48 pm

#900324
RE: Go Open

When people say "Open Source", they don't really care if it's "Open Source" or not... they just want "free".
--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)

November 18, 2008 at 10:43 pm

#900321
RE: Catalogue Hierarchy Design Strategy

James,
Are all the mice in the same downline? I believe that your code is resolving the whole tree trying to find %mouse% and it may actually be resolving 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)

November 18, 2008 at 10:38 pm

#900318
RE: Bulk Insert Grief

Also, let me know if you need any help splitting that pig. 😉
--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)

November 18, 2008 at 10:07 pm

#900305
RE: Bulk Insert Grief

You don't need a format file for this nor even BCP. Just do a BULK INSET and specify the FIELDTERMINATOR = ''.
--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)

November 18, 2008 at 10:05 pm

#900304
RE: Using Bulk Insert

Starting reading here... all is explained in that post and additional clarifications are made further down.
http://www.sqlservercentral.com/Forums/Topic165368-8-1.aspx#bm165996
--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)

November 18, 2008 at 9:56 pm

#900294
RE: Using BCP utility to create a CSV file from SQL Server

You still have to identify the server and, maybe the instance using the -S parameter.
--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)

November 18, 2008 at 9:50 pm

#900288
RE: Faster Deletes

Dugi (11/18/2008)
Try to truncate table
TRUNCATE TABLE name_of_your_table
couz the DELETE command is logged and every deleted action will recorded on log file and if you have million of records sure 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)

November 18, 2008 at 9:46 pm

#900286
RE: Using a SQL Stored Procedure to import an Excel spreadsheet

karschnike (11/18/2008)
I have been tasked with using this stored procedure to import data from an Excel
It would be really helpful if you posted the stored procedure so we can...
--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)

November 18, 2008 at 9:42 pm

#900285

Viewing 15 posts - 47,131 through 47,145 (of 59,101 total)