Viewing 15 posts - 991 through 1,005 (of 11,678 total)
smanikandan23 (2/20/2015)
I have checked the report execution log, Seams TimeDataRetrievalis greater 🙁
TimeDataRetrieval | TimeProcessing | TimeRendering | ByteCount | ...
February 20, 2015 at 7:24 am
How much data does the query return? (be aware, most people do not know what lakh is)
The fact that the query takes 4-5 minutes the first time and 10 seconds...
February 20, 2015 at 7:04 am
Ed Wagner (2/20/2015)
Eirikur Eiriksson (2/19/2015)
Lynn Pettis (2/18/2015)
... Mark one off, 9 days on the calendar to go. 9 days on the calendar to go, 9 days to go, ...
Only 1001...
February 20, 2015 at 6:48 am
Just a thought:
why not keep a balance of everything? Not just the current balance, but also the YTD, MTD, daily total?
Each time a transaction occurs, you just update all those...
February 20, 2015 at 6:44 am
Grant Fritchey (2/20/2015)
You might want to drop all indexes and foreign keys from the table you're loading to, depending...
February 20, 2015 at 4:16 am
Bhushan Kulkarni (2/19/2015)
I want to update data in destination table from Source table. Destination table already has data and source table has millions of rows.
What are best practices...
February 20, 2015 at 2:44 am
Phil Parkin (2/9/2015)
What...
February 20, 2015 at 2:43 am
anshulparmar (2/20/2015)
rocky_498 (2/9/2015)
I am using so far two transformations ( Derived Column, Data Conversion)
Plus I am using SCD..
That would be next question. If I pick Second...
February 20, 2015 at 2:42 am
Carlo Romagnano (2/20/2015)
BY <crypto_list> [ ,...n ]
<crypto_list> ::=
CERTIFICATE cert_name
| CERTIFICATE cert_name...
February 20, 2015 at 2:27 am
SQL-DBA-01 (2/19/2015)
I think in such questions where it's asked to choose multiple correct answers, it will be good to have more points rather just 1. Thoughts?
Sometimes they have more points....
February 20, 2015 at 2:24 am
rhythmk (2/19/2015)
anshulparmar (2/19/2015)
Try using OLE DB Command instead and update flag while inserting new records.
How will you achieve it ?
Think of the scenario where OP wants to do this exercise...
February 20, 2015 at 1:20 am
bharathi.kannan (2/19/2015)
Thanks but actually.. what i'm trying to do is after the destination got inserted successfully.. and my destination...
February 19, 2015 at 11:07 am
Please do not crosspost. It wastes peoples time and fragments replies.
Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1661770-2799-1.aspx
February 19, 2015 at 9:51 am
Viewing 15 posts - 991 through 1,005 (of 11,678 total)