Viewing 15 posts - 76 through 90 (of 960 total)
In that case you can shift the write to DB in a Service Broker Queue which is more reliable and can be used for retry logic.
October 24, 2015 at 5:27 am
The only feature I know in SQL that can handle weight-age out of the box is Full text index, anything else will need to be scripted out using a variation...
October 24, 2015 at 5:22 am
I know its a bit late to ask this ,but what is the exact error you get when the package fails? Is it a permissions issue or a missing account...
October 24, 2015 at 5:18 am
If the database permissions have been changed and the users are now connecting using db_owner permissions they shouldn't be facing any issues. On the other hand if you saying that...
October 24, 2015 at 5:15 am
no way delete statement will delete all rows unless they matched the filter criteria, most likely its what Gail said , select first line and press F5. Happens to everybody...
October 24, 2015 at 5:03 am
Just wondering if anybody was able to finish testing the scripts and if there are any new results ?
EDIT : BUMP, hoping for some independently verified results , also created...
October 23, 2015 at 11:28 pm
Why not use a message queue and write async to the database once message has been pushed? this way you can still achieve massive throughout at the business layer...
October 23, 2015 at 9:12 am
i havent changed the storage formats , its all at defaults , the only thing done extra is trace 1117
October 23, 2015 at 8:37 am
Jeff Moden (10/23/2015)
Jayanth_Kurup (10/23/2015)
Here is a screen shot with clustered index on the monolithic table on REF_AGE column as requested. Notice that it took 17 sec , just...
October 23, 2015 at 8:28 am
are you referring to the Filgroup that needs to be created with in memory OLTP? if so then yes, when persisting the data for an in memory table the faster...
October 23, 2015 at 5:19 am
Sergiy (10/23/2015)
Jayanth_Kurup (10/23/2015)
Mainly trying to highlight the difference between an allocation scan and traversing the b tree.
Once again:
Can you show how a query for an age group for ages between...
October 23, 2015 at 4:57 am
Hi Gail
The tempdb example was not meant to indicate that there is some kind of partitioning involved but to point out that indexes are not the only way to improve...
October 23, 2015 at 4:03 am
Hi Sergiy
Here is a screen shot with clustered index on the monolithic table on REF_AGE column as requested. Notice that it took 17 sec , just the same amount...
October 23, 2015 at 3:44 am
No; its not in memory its create a local cache file on the same server as SSIS so it improves the speed with which the lookup happens.
October 23, 2015 at 3:28 am
Viewing 15 posts - 76 through 90 (of 960 total)