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...

You don't partition for performance, you partition for data management and because it makes sense logically.

How much space do...

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...

hat's the user default database set to and the permissions to it?

Check out this thread.

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....

sjimmo (3/7/2012)

---

Does anyone have any experience with putting databases/T-Logs on SSD's? We are playing with the idea of testing some different scenarios but I am looking for input from anyone...

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.

Glad to help!

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...

ramchandra2cool (3/7/2012)

---

I tried both of them, you know the problem is the result is displaying for only one record. Can you tell me how to post my output as you...

It means that your method doubled the logical reads and...

I also like avoiding unions if I can by inserting into a temp table or a table variable and then selecting from that. This seems to increase performance in...

Why are you obsessed with speed? Did you not see the reads and scans?

ramchandra2cool (3/6/2012)

---

How is that it is taking in SSMS only 9 secs. And when i place the same query in the SSIS it is taking more time to pull the...