Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,566 through 32,580 (of 59,099 total)

RE: Import CSV File to SQL 2000

diboy79 (9/13/2011)
1. could not find the selected row delimiter within the first 8 KB of Data
2. too many column found in the current row;non-white space characters were found after 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)

September 13, 2011 at 11:58 pm

#1381055
RE: Advice on running totals using a cursor

Oddly enough, it wouldn't take much more time to do the Quirky Update on a million row table than it would be to go through all the shenanigans to find...
--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)

September 13, 2011 at 11:53 pm

#1381052
RE: A Walkabout

I have to ask... where do students get the money to travel from Australia to Europe, spend a couple of weeks doing whatever they want, and then travel back to...
--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)

September 13, 2011 at 6:45 am

#1380571
RE: How to save a query result in a readable format.

forsqlserver (9/13/2011)
How to save a query result in a readable format.
select * from sys.databases
Where do you want to save it? In a file? And, what do you mean...
--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)

September 13, 2011 at 6:33 am

#1380566
RE: SELECT INTO

sunny.tjk (9/12/2011)
sqlbuddy123 (9/11/2011)
Jeff got it perfectly right. Just use CREATE Table and add an identity column to 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)

September 12, 2011 at 7:45 pm

#1380386
RE: SELECT INTO

sqlbuddy123 (9/11/2011)
Jeff got it perfectly right. Just use CREATE Table and add an identity column to 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)

September 12, 2011 at 7:44 pm

#1380385
RE: SELECT INTO

sunny.tjk (9/12/2011)
sqlbuddy123 (9/11/2011)
Jeff got it perfectly right. Just use CREATE Table and add an identity column to 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)

September 12, 2011 at 7:37 pm

#1380384
RE: Page File location and Size

Ignacio A. Salom Rangel (9/12/2011)
I agree with Jeff. I always though that setting max memory was bad practice! Could you please provide a link to a Microsoft article that supports...
--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)

September 12, 2011 at 7:32 am

#1379997
RE: Page File location and Size

Again, I might be taking it the wrong way but I've never seen the recommendation to set SQL Server Max Memory to the same amount as there is RAM 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)

September 11, 2011 at 11:14 pm

#1379791
RE: Page File location and Size

sqlbuddy123 (9/11/2011)
If you configure SQL Server to maximum memory and set Lock pages in Memory...
I'm not sure if I'm reading that right so forgive me if I'm taking it 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)

September 11, 2011 at 10:52 pm

#1379784
RE: Would we use Schemas as a Security Container?

I'm definitely the wrong one to ask on this. My belief is that users should only have 2 privs on a production box... PUBLIC and the EXECUTE priv on...
--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)

September 11, 2011 at 10:39 pm

#1379783
RE: Bulk insert with format file to exclude columns

I just checked the data you posted. All rows in the file must have precisely the same number of delimiters... including the header. You have a 14 "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)

September 11, 2011 at 10:12 pm

#1379782
RE: Bulk insert with format file to exclude columns

The first problem that I see is that the "delimiter" column of the format file has spaces in it that should not be there...
v----------- There's a...
--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)

September 11, 2011 at 10:06 pm

#1379781
RE: How to ensure a job only runs for a set duration?

Florian Reischl (9/11/2011)
Ha! Logged for future generations! Jeff condones a RBAR solution 😀
Heh... I could argue all day why it's not RBAR but I'll take the hit, for now. :-)...
--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)

September 11, 2011 at 9:56 pm

#1379779
RE: set implicit_transactions off permanently?

You probably couldn't fix the problem even if you were able to figure out what to do because you don't have the source code to make the right kind of...
--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)

September 11, 2011 at 9:52 pm

#1379778

Viewing 15 posts - 32,566 through 32,580 (of 59,099 total)