Viewing 15 posts - 1 through 15 (of 75 total)
Thanks. I ended up opting for creating a new database, since the data on this database would have a different concept, even though they would have some tables and IDs in...
February 14, 2019 at 10:51 am
I see. Would be a reasonable idea to replicate these tables with static data also in the new DB, so the distributed transaction does not need to exist, and this...
February 11, 2019 at 4:46 pm
Thanks for your help!What do you mean by 'three-part-naming issues'?If I just add the new tables to the existing database in a different filegroup, the read/write operations will...
February 11, 2019 at 3:28 pm
Seems a good solution. Thanks!
February 1, 2017 at 8:27 am
February 1, 2017 at 7:14 am
Want to delete several rows from a table (several gigabytes) (not truncate) and avoid that to be logged to ldf file, to avoid its growing.
February 1, 2017 at 4:48 am
The connection string format is correct.
The sql server instance to which I was trying to connect was stopped..
February 11, 2016 at 5:46 am
Thanks for all your answers!
Besides it would work, I will use dynamic sql and read the link recommended!
February 3, 2016 at 3:54 pm
Following the links you suggested, I was able to open it using InterBase XE3.
January 11, 2016 at 5:39 am
Thanks! I will look.
December 15, 2015 at 8:57 am
I think I will need to study execution plans to accomplish this. Any advice where to start?
December 15, 2015 at 7:04 am
The execution plan with group by is using a 'Index Scan (NonClustered)', so I think the index seek in the correlated query is better.
December 15, 2015 at 2:47 am
Would the 'group by' solution, grouping all results from MyTable2, be a better solution than the correlated query?
It is not an OLTP database and the query is executed frequently, although...
December 14, 2015 at 11:11 am
Index Seek (NonClustered)
December 14, 2015 at 10:05 am
This error does not happen always.
Looking at the execution plan it displays among others:
Nested Loops(Inner join) 0% < compute scalar 0% < stream aggregate 0% < Index Seek (NonClustered) 8%
December 14, 2015 at 9:52 am