Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,091 through 24,105 (of 59,099 total)

RE: Working with stored text file in TSQL

I'm still a bit confused though. You say the user is uploading a file... what is that process? Is the user uploading a file to the Web Server...
--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)

March 23, 2014 at 9:57 am

#1699355
RE: Need help in getting SQL query

santuraj12 (3/22/2014)
Hi All,
Need your help on getting the sql query for the below data
EMP ID Flag Processing Date
ABC1 yes Current Date
ABC1 No Old Date
DEF1 Yes Current Date
DEF1 No Old Date
GHI1...
--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)

March 22, 2014 at 11:52 pm

#1699336
RE: Fast inserting\reading\deleting of millions of records

darren_ferris (3/20/2014)
Thanks for the replies guys.
Kevin, you're right, customers do tend to spawn up new databases once they reach the size limit in SQL Express. I'll try the clustered index...
--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)

March 22, 2014 at 11:13 pm

#1699334
RE: Primary Key Violation

It may be one of those "odd" things that happen behind the scenes when you do something odd. I've never seen anyone create the table on the partition scheme...
--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)

March 22, 2014 at 10:07 pm

#1699331
RE: Working with stored text file in TSQL

keith.westberg (3/21/2014)
I apologize for not laying the groundwork... so here's the process.
User uploads a file to website application. The site parses the text file and generates insert...
--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)

March 22, 2014 at 9:54 pm

#1699330
RE: DB2 DBA

Shucks. Thanks for the awesome feedback, Tom. :blush: I really appreciate the thoughts.
Shifting gears back to the task at hand, thanks again for the link to the IBM...
--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)

March 21, 2014 at 2:34 pm

#1699243
RE: Query to get Last month's Data

rderisala1 (3/21/2014)
That helps..
Thanks a lot..
You bet. Thank you for the feedback.
--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)

March 21, 2014 at 2:28 pm

#1699241
RE: How to kill running job?

...and in some cases, you'll get stuck with a "Zero Rollback' that doesn't do anything except consume CPU time.
--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)

March 21, 2014 at 2:18 pm

#1699238
RE: String Concat in Group

steve.spenceST (3/20/2014)
🙂 Thank you for this answer. Helped me greatly.
If we consider the original post, THIS is what Luis is talking about...
--===== Create the test tables with the OP...
--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)

March 20, 2014 at 9:09 pm

#1698937
RE: String Concat in Group

Luis Cazares (3/20/2014)
steve.spenceST (3/20/2014)
🙂 Thank you for this answer. Helped me greatly.
Note that there are better ways of doing this. As explained in here: http://www.sqlservercentral.com/articles/comma+separated+list/71700/
Ditto 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)

March 20, 2014 at 8:40 pm

#1698936
RE: Working with stored text file in TSQL

keith.westberg (3/20/2014)
...a field containing a text file and work with the content line by line
What's actually stored in the "field"? The path to the text file or the actual...
--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)

March 20, 2014 at 8:38 pm

#1698933
RE: Any good reference article/post where I can find SQL SERVER 2005/2008 administration commands?

Learner44 (3/20/2014)
I am already looked on msdn website.
Please provide me some more.
thanks.
If you load up "Books Online" (the help system that you can download for SQL Server) and the lookup...
--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)

March 20, 2014 at 8:29 pm

#1698932
RE: Primary Key Violation

todd 87764 (3/20/2014)
Already did this, as I said I triple checked and there are NO duplicate IDs and there are no nulls.
Does the original table have a PK or UNIQUE...
--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)

March 20, 2014 at 8:26 pm

#1698931
RE: Primary Key Violation

todd 87764 (3/20/2014)
Let me ask this... Does the process of partitioning a table add the partition key to the primary key? This is the only thing I can think...
--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)

March 20, 2014 at 7:41 pm

#1698928
RE: DB2 DBA

Absolutely outstanding, Tom. THAT's what I was looking for! Thank you very much for your time.
If you run into a problem on SQL Server, throw a rock at...
--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)

March 20, 2014 at 4:39 pm

#1698915

Viewing 15 posts - 24,091 through 24,105 (of 59,099 total)