Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,346 through 21,360 (of 59,098 total)

RE: EXCEL HELL!!!

Gosta Munktell (3/7/2015)
Thank you all for this "debate"
I would nether recommend anybody to use SSIS or an ACE driver in order to import sheets in native Excel file format....
--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 7, 2015 at 7:55 pm

#1782373
RE: can anyone provide me real time scenarios where you build stored procedures, triggers, cursors?

t.mounika01 (3/6/2015)
Actually, what i meant was that I just have thereotical knowledge and I have been practicing queries on ssms installed in my laptop. I want to know how...
--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 7, 2015 at 7:39 pm

#1782372
RE: use sql server client 2012 32 bit against sql server 2014 64 bit

mfriessnig (3/6/2015)
can I use sql server client 2012 32 bit against sql server 2014 64 bit
Gosh... you must be asking because you have such a situation. Why don't you...
--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 7, 2015 at 5:35 pm

#1782371
RE: help to improve the performance of sql

sushil_dwid (3/7/2015)
Hi,
Below is the sql which we use to fetch the data in report. When this query runs for 1 month data, it gives better result but when...
--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 7, 2015 at 5:31 pm

#1782370
RE: script to set all user database to simple recovery model

george sibbald (1/8/2014)
I know, I just couldn't resist it ! 😉
BWAAA-HAAAA! True sign of being retired. 🙂 Do everything as simple as possible. I love 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)

March 7, 2015 at 5:12 pm

#1782367
RE: BULK INSERT with a format file

spaghettidba (3/5/2015)
This seems to be what you're after: https://msdn.microsoft.com/en-us/library/ms179250.aspx?f=255&MSPPError=-2147217396
If you want an alternative method, the simplest thing I can think of is to create a view with 12 of 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 6, 2015 at 9:02 pm

#1782333
RE: Process deadlock

sarath.tata (3/6/2015)
You are absolutely correct!! I realized later that my posted query has no impact but the one in the error log has created deadlock!! Any guesses how to tune...
--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 8:57 pm

#1782331
RE: Suggestion/Request: Is there a way to download Stairways for offline reading?

Or, just press the print button like I said. 😉
--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 8:48 pm

#1782329
RE: Process deadlock

It doesn't look like that particular deadlock has anything to do with the query you posted even with the understanding that you've probably sanitized the query a bit. 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 8:40 pm

#1782327
RE: Suggestion/Request: Is there a way to download Stairways for offline reading?

Katerine459 (3/6/2015)
... preferably in HTML, ePUB, and/or Kindle formats?
I'd like to be able to study on my Kindle while I'm out walking. 😀
Yes there is. At the top 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)

March 6, 2015 at 8:32 pm

#1782325
RE: can anyone provide me real time scenarios where you build stored procedures, triggers, cursors?

One "real time" scenario would be bank account transactions. You can now move money back and forth between your checking and savings accounts in "real time". It used...
--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 8:25 pm

#1782324
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

Viewing 15 posts - 21,346 through 21,360 (of 59,098 total)