Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,316 through 21,330 (of 59,072 total)

RE: EXCEL HELL!!!

xsevensinzx (3/7/2015)
Good stuff here on the suggestions. Here is an odd one from me that I didn't try, but I think it would work similar to Eirikurs.
Create a data flow...
--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 8, 2015 at 2:16 pm

#1782395
RE: Memory error

SQLEnthusiastic (3/7/2015)
Did you try reducing the max server memory on the SQL Server intance, leaving more memory to the OS?
This solved in one of my instances.
Good tip. I hope...
--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 8:38 pm

#1782376
RE: How to Fill-In A Single Cell in an Excel Spreadsheet Via SSIS?

brad.mccollum (3/7/2015)
Update here:
This might be a good article... just found it, but I'm still appreciative of anything else someone might be able to push along info-wise if you've accomplished this...
--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 8:32 pm

#1782375
RE: Fifty Words for Databases

What??? You don't know how to get to the moon, Phil???? It's simple! All you have to do is build a rocket ship! 😛
Absolutely great editorial, ol' friend....
--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 8:03 pm

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

Viewing 15 posts - 21,316 through 21,330 (of 59,072 total)