vMotion is a fun topic in the SQL Server world. Allowing a SQL Server VM to be moved using vMotion when an AG is involved is a reasonably safe...

Found the issue.

SSIS 2012 still has a limitation on the String data type for variables. The use of the VarChar(Max) or NVarChar(Max) data type in the query was causing...

User::varRestoreScript is the first return value. And even with the a dummy select the same result occurs. I have narrowed the issue down to the T-SQL Statement structure...

This was a tricky one especially for those of us who take these questions literally. As 6 would be the answer if the question was posted towards sql 2008+...

check that the internal tables used for service broker queues aren't in that file group. Read this article for more details:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=239891

Did you check that the filegroup isn't set as the default? If not, set a different filegroup as the default and then you will be able to drop the...

Naveen T.,

Post your error message and I will take a look at your issue with the script. This code was actually written against tables which contain unique primary key's.

Scott

Lynn Pettis,

This script returns the full Package path as a variable which is then used as the package source within an Execute Package Task.

Dts.Variables("ChildPackageName").Value = package.Name.ToString & ".dtsx"

this is the...

Thanks Todd! I will try this tomorrow when I put my dev hat back on 🙂

Scott

Don't have a reference other than what we have experienced in our production environments. This has already caused us to move indexes on several occasions to filegroups which have...

when an index is contained in a filegroup which spans multiple database files DBCC SHOWCONTIG isn't as accurate as it is on indexes which are contained within a filegroup on...

Michael,

In a multiple data file per filegroup structure how do you keep indexes healthy as you can't see how fragmented each data file is within the file group without being...

Ok, so consolidating the data files within each of our file groups IS a good idea but consolidation of then number of file groups isn't? If this is true...

Reasons:

- All database files for each file group reside on the same array thus negating the effectiveness of the structure that was put in place prior to consolidation of...

you can do this in Management Studio it just isn't as straight forward. You have to:

1. Open the table by right clicking and selecting "open table"

2. press the SQL...