Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,331 through 21,345 (of 59,072 total)

RE: EXCEL HELL!!!

grovelli-262555 (3/6/2015)
How about not pumping anything into SQL Server and do all the processing and output in Access?
That's what I said in my previous post. 😉
But, my goal isn't...
--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 6, 2015 at 5:52 pm

#1782319
RE: Adding a time to a duration to give the new time

I other words, multiply hours * 60 and then do a DATEADD(mi, to 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 6, 2015 at 3:07 pm

#1782303
RE: SSIS Checking Header Row from a .csv file

ericwenger1 (3/5/2015)
I need to be able to see if the incoming csv file had a head row different than the previous files header row. That will tell me that I...
--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 6, 2015 at 2:54 pm

#1782302
RE: database export

sqlfriends (3/6/2015)
We have a in house developed application and database. It is online transaction database for student school assignment.
Size is about 6 GB.
We have another department needs our data 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)

March 6, 2015 at 2:50 pm

#1782299
RE: Fuzzy Logic

In a word, no. Not in SQL Server itself. Lots of code out there, though.
--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 6, 2015 at 2:37 pm

#1782297
RE: Changed database from Full to simple - Maintenance plan failing

GARY lAUNDRY (3/6/2015)
One of my programmers changed their database from full to Simple recovery. Saw that my job that backs up the Full Recovery mode databases failed, so I moved...
--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 6, 2015 at 2:33 pm

#1782295
RE: Job Interview question: slow queries

Heh... fine for others but, when I'm interviewing someone, I actually do want them to tell me something other than a general process because I want someone that has actually...
--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 6, 2015 at 2:28 pm

#1782294
RE: How to Flatten Table Resultset

eashurak (3/6/2015)
Hi - Hate to review an old thread after so long, but I need to do something similar. In Jeff Moden post on 8/19/2009 1:19:13 AM he uses...
--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 6, 2015 at 2:23 pm

#1782293
RE: EXCEL HELL!!!

I'm not so sure that I'd use Access to pump a spreadsheet into SQL Server when SQL Server can do it just fine but, sure, it could also be done...
--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 6, 2015 at 2:19 pm

#1782290
RE: Trying to generate a parallel execution plan

jdbrown239 (3/5/2015)
@Alan Thanks Alan
The Paul White post is great! I learn something every time I post in this forum. I am going to setup a test using your example with...
--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 5, 2015 at 9:13 pm

#1782078
RE: Dynamic Return type in a function

Alan.B (3/5/2015)
Chris, Jeff...
If I understand the OP correctly, they could not solve this problem with ISNULL or COALESCE alone because of the awkward data type requirement.
Let's review the requirement...
--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 5, 2015 at 4:11 pm

#1782061
RE: Trying to generate a parallel execution plan

jdbrown239 (3/5/2015)
Thanks Alan
What is the syntax for make_parallel() ?
It's all in the article. Click on the differently colored "make_parallel" in Alan's post. It's a link to 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)

March 5, 2015 at 4:00 pm

#1782057
RE: If user is mapped to master, can they access all dbs?

And to add to what Alan said, I wouldn't do such a thing on any given day. 😉
--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 5, 2015 at 3:55 pm

#1782055
RE: What is the equivalent to Yes/No data type in SQL?

Tim Walker. (3/5/2015)
I have been trying to work out whether this thread is useful to me in a business context.
But is it a straight yes or no?
😉
Heh... "It Depends". ...
--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 5, 2015 at 11:44 am

#1782013
RE: Can we create the Partition on Existing Table?

nilesh_dalvi (3/4/2015)
Can we create the Partition on Existing Table?
e.g Create table t ( col1 number(10,0), Col2 Varchar(10)) ;
After the table Creation can we alter the table to partition the table.
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)

March 5, 2015 at 8:52 am

#1781953

Viewing 15 posts - 21,331 through 21,345 (of 59,072 total)