Viewing 15 posts - 5,386 through 5,400 (of 9,253 total)
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...
July 3, 2012 at 11:44 am
dan-572483 (7/3/2012)
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...
July 3, 2012 at 11:41 am
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...
July 3, 2012 at 11:28 am
Firstly, this statement from the ask sql server central site is incorrect
TRUNCATE TABLE statements cannot be used for tables involved in replication or log shipping
Log shipping does not replicate atb...
July 3, 2012 at 7:04 am
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...
July 3, 2012 at 6:56 am
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...
July 3, 2012 at 2:47 am
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.
July 2, 2012 at 12:02 pm
my guide, linked by Mohammed, shows you all you need to know
July 2, 2012 at 11:51 am
webrunner (7/2/2012)
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?...
July 2, 2012 at 11:50 am
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
July 2, 2012 at 11:45 am
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...
July 2, 2012 at 11:30 am
only in 2008 set up onwards can you specify a userdb data, log and a backup directory.
July 2, 2012 at 11:24 am
Codezilla-292868 (6/29/2012)
Named Pipes Provider: Could not open a connection to SQL Server
the job could not connect...
July 2, 2012 at 11:05 am
anthony.green (7/2/2012)
Perry Whittle (7/2/2012)
anthony.green (7/2/2012)
add another file to the filegroup that way SQL will stripe the data across both files in an equal proportion
No, it won't, as the remaining files...
July 2, 2012 at 10:46 am
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...
July 2, 2012 at 8:37 am
Viewing 15 posts - 5,386 through 5,400 (of 9,253 total)