yes but data is moved to a filegroup, not an individual file. If that group only contains 1 file then fine otherwise it'll be spread across all files in the...

dan-572483 (7/3/2012)

---

Nicholas,

Just curious, what are the specs on your laptop & VMs? I've thought about clustering VMs on my home computer for self-training purposes, but I'm concerned about...

i'm currently working on a script to pull database permissions and connection grants, etc from a user database, it's not complete but here's the bones of it

SET NOCOUNT ON

DECLARE...

Firstly, this statement from the ask sql server central site is incorrect

Log shipping does not replicate atb...

sure, as i said you only want to be creating multiple files per filegroup from the outset to ensure the fill is equal, (hence sames sizes and growth rates). If...

From reading your post it sounds very much like you require AlwaysOn in SQL Server 2012, are you not able to make the upgrade and utilise the newer technology?

Aside that...

Since essentially all tables\indexes in SQL Server 2005 on are partitioned, to get down to the partition sizes you'll need to join sys.indexes, sys.partitions and sys.allocation_units.

my guide, linked by Mohammed, shows you all you need to know

webrunner (7/2/2012)

---

Hi everyone,

From a security perspective, is it advised or discouraged for non-DBA users to have owner (db_owner or equivalent permissions) to some or all databases on a SQL Server?...

i'm a dinosaur and prefer good old T-SQL 🙂

USE [SomeDB]

GO

SELECT 'The database owner is: ' + QUOTENAME(SUSER_SNAME(dp.sid))

FROM sys.database_principals dp

WHERE dp.name = 'dbo'

GO

failback is a windows cluster feature to enable a clustered resource (not just SQL Server) to move back to its preferred location after a failover has occurred. On resources such...

only in 2008 set up onwards can you specify a userdb data, log and a backup directory.

Codezilla-292868 (6/29/2012)

---

i get this error when there is a job running on a linked server:

Named Pipes Provider: Could not open a connection to SQL Server

the job could not connect...

anthony.green (7/2/2012)

---

Perry Whittle (7/2/2012)

---

No, it won't, as the remaining files...

looks like disk issues.

Which nodes does the instance come online on?

Have you checked that all required storage has been presented to all the nodes that are participating in the...