Viewing 15 posts - 46 through 60 (of 78 total)
MyDoggieJessie (4/11/2011)
Flat File
|
Derived Column
|
Data Conversion
|
SQL Server Destination
Are you saying something like:
Flat...
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
April 12, 2011 at 9:03 am
harun-974445 (4/12/2011)
I want to optimize my performance using below actions on my SSIS package
1.Reading same source once and transfer same Data several destinations using buffer or...
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
April 12, 2011 at 8:56 am
Did you check the execution plan to make sure that the index is being used?
Is there a performance difference when running this statement through SSMS and/or the client application?
Is there...
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
April 12, 2011 at 8:47 am
Bala' (3/14/2011)
Why you haven't gone for in-place upgrade?
Thanks for your reply...
Yes I can just go for a 'simple' upgrade and do any neccessary cleanup afterwards! In this way I won't...
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
March 14, 2011 at 8:26 am
Great Thanks! I'll have a look...
Regards
Brian
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
March 4, 2011 at 12:38 am
TheSQLGuru (12/29/2010)
brian118 (12/29/2010)
PaulB-TheOneAndOnly (12/28/2010)
Assuming SAN/Network are working properly chances are you are facing some hot spots. A single file Tempdb sounds like a possible cause but I'll suggest...
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
December 30, 2010 at 2:48 am
PaulB-TheOneAndOnly (12/28/2010)
Assuming SAN/Network are working properly chances are you are facing some hot spots. A single file Tempdb sounds like a possible cause but I'll suggest to further...
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
December 29, 2010 at 3:04 am
Jeffrey Williams-493691 (12/28/2010)
1) Are you sure you are running SQL Server 2008 Enterprise Edition and not Standard Edition? Use one of the following to verify:
Select @@version;
Select...
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
December 29, 2010 at 3:02 am
A.J. Wilbur (12/28/2010)
Is the same as this issue you posted about?http://www.sqlservercentral.com/Forums/Topic1034234-391-1.aspx
Not exactly since this time I'm directly at the client site, equipped with a much better hardware, however yes I'm...
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
December 29, 2010 at 12:15 am
Sean Lange (12/20/2010)
Why are trying to kill off these sessions? This sounds like you are having problems with the connection pool?
Not really! One of our client requested this feature to...
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
December 20, 2010 at 7:57 am
Nadrek (12/17/2010)
brian118 (12/17/2010)
Thanks for your feedback!
I have 8 core allocated to the SQL Instance, and although I specify MAXDOP=4 for the index rebuild operation, I'm seeing only ONE core spiking...
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
December 20, 2010 at 1:52 am
Nadrek (12/16/2010)
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
December 17, 2010 at 1:11 am
faelconn1ck (12/15/2010)
What's the consequences if wrong fill factor has been set. So called poor performance will cause something like deadlock or query timeout?
With poor performance i understand slow Selects or...
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
December 16, 2010 at 8:48 am
Oliiii (11/22/2010)
If you use 2 tables...
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
November 23, 2010 at 1:10 am
Nakul Vachhrajani (11/19/2010)
Also, depending upon the query and the load, SQL Server can choose not to...
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
November 19, 2010 at 5:54 am
Viewing 15 posts - 46 through 60 (of 78 total)