Stefan Krzywicki (12/30/2010)

---

I'm currently transferring some tables from a large database on SQL Server 2000 to a new server, their own database and SQL Server 2008 R2. We don't have...

aaa-322853 (12/30/2010)

---

Oops my mistake, didn't read your original post correctly!

Typically when you have a type 2 you would identify this by comparing to you current record, in your case Version...

chaudharyabhijit (12/30/2010)

---

I wanted to know what you think should be the order of items in the Maintenance Plans for a Nightly Backup.

This is what i am doing so far:

1. Rebuild...

LutzM (12/30/2010)

---

Building on Lutz's comment I'll say you cannot pull a database...

miss.delinda (12/28/2010)

---

The error was shown,

Could not find server 'MAFC-SVR1\NAV1' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server...

aaa-322853 (12/30/2010)

---

That's quite an interesting approach with your "Version" field Paul. I can imagine that could prove very useful.

You don't mention a "IsRowCurrent" field however, do you derive this...

Core6430 (12/29/2010)

---

Just to clarify... I've just stepped into this project recently. I wasn't there when they designed it or started developing it.

If you ran into a design like this,...

Even empty tables may be in use - they can either be staging or temporary tables truncated after each run; on the other hand I've seen populated tables go deprecated...

Partitions are switched one at a time.

Index-paritions are switched alongside table-partitions - that's why we want them to be table-aligned.

Time to test, don't you think so? 🙂

dbursey (12/29/2010)

---

This is not a question asking "how to" do either one of these things - I know how to do them. I'm just curious with regard to preference/performance...

MTY-1082557 (12/29/2010)

---

I have the following partition definition in 2 of my main tables. I would like to know what the best way to alter or modify a partition is. I...

jeelanik (12/29/2010)

---

Thanks for response.

An index that follows the partitioning strategy of the base partitioned table e.g. same partitioning schema and partitioning column - nothing more, nothing less.

By saying...

dbursey (12/29/2010)

---

Hello, all - I've heard/seen it both ways - updates are faster/more efficient IF you restrict the scope so that it applies to only the relevant rows VS. having...

An index that follows the partitioning strategy of the base partitioned table e.g. same partitioning schema and partitioning column - nothing more, nothing less.

ami.shah (12/29/2010)

---

Hi!

I have 2 different database (A and B) in a sql server 2008. Databse A has around 100

tables out of which i want to synchronize 15 tables from...