Viewing 15 posts - 5,386 through 5,400 (of 9,244 total)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 12:02 pm
my guide, linked by Mohammed, shows you all you need to know
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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?...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 11:30 am
only in 2008 set up onwards can you specify a userdb data, log and a backup directory.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 8:37 am
surma.sql (7/2/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 8:32 am
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 in the group...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 8:30 am
Mindy Hreczuck (6/25/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2012 at 2:33 am
To add further, the IP and port number must be a unique combination for the installed instances, the following would be valid
Instance1 ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2012 at 2:26 am
gantavasu (6/29/2012)
We are having 28gb ram in that after installing the sql server it is occupying 10 gb Ram.here i want to set this to 2gb.
Wow, what other application do...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2012 at 2:15 am
Viewing 15 posts - 5,386 through 5,400 (of 9,244 total)