if you have only 1 disk array, it will not make much difference. Separating the data to a different array will help performance.

Use ADO instead.

Unless you create a new filegroup and file, you cannot move the data to the new file.

When was the SAN last reboot? The SAN may need a reboot to clear the cache.

1. Rather than sliding the window that moves forward in time by creating new partitions, can we use a "rotating window" which uses partitions in a ring structure? In this...

I have implemented partitioning on a few larges tables. However, I switch over to single filegroup for ease of maintenance or lack of filegroup maintenance.

The underlying logical drives has 20...

Nevermind, I realized when I merge the partition. SQL Server will drop the filegroup from the partition scheme automatically.

Are you performing DB to DB transfer? Would the gain be cancelled out by bring over additional data and having to filter it out?

I'm in the same situation where trying...

Err... This is all in 1 server but multiple databases with the same set of tables.

I want to create 1 package that can be used with multiple databases doing the...

I tried the solution found in the link below but I could not bring up the screen to remove the server farm.

The wizard goes through 10 out of 10 steps...

thats what I was thinking of. Performing the decryption in SSRS.

That works!

Why can't I reference the element name using this select?

select

ref.value('Comment', 'nvarchar(50)') as comments

from

dbo.TestXml cross apply Comments.nodes('//CommentHistory/')R(ref)

Amatuer moments!

Here you go!

<CommentHistory>

<Comment AddedOn="03/26/2009" AddedBy="testuser">This is a test</Comment>

</CommentHistory>