Viewing 15 posts - 1,471 through 1,485 (of 2,647 total)
Since you know that the view will change definition and want it to pick up the changes, I would stick with the select * and add a refresh to whatever...
March 7, 2012 at 2:27 pm
1.how many paritions maybe get performance increase?
You don't partition for performance, you partition for data management and because it makes sense logically.
2.how many rows in each partiton?
How much space do...
March 7, 2012 at 1:42 pm
Agreeing with the others... You can choose where the shared components, data files, logs, and backups go. After that, it will put everything where it needs to be. Sounds...
March 7, 2012 at 1:32 pm
hat's the user default database set to and the permissions to it?
March 7, 2012 at 1:25 pm
Its a driver issue with the card. We purchased a set-up where the SSDs are mounted directly to the PCIe cards. It is configured as a RAID 5-0....
March 7, 2012 at 1:06 pm
sjimmo (3/7/2012)
March 7, 2012 at 12:49 pm
When you create the subscription, it wall ask you if you want to initialize after you create the subscription. Make sure to say no here.
March 7, 2012 at 12:47 pm
When you alias the table as something like ter5, you have to make sure that is the alias used in the join (change ON ter.colname = sth.columnname to ON ter5.columnname...
March 7, 2012 at 11:36 am
siva 20997 (3/6/2012)
As I said before my background is from else whereCan you explin to me what the stats shows ?
It means that your method doubled the logical reads and...
March 6, 2012 at 3:17 pm
siva 20997 (3/6/2012)
are you saying my method was faster even with the UNION ?
Why are you obsessed with speed? Did you not see the reads and scans?
March 6, 2012 at 3:05 pm
Viewing 15 posts - 1,471 through 1,485 (of 2,647 total)