Viewing 15 posts - 4,336 through 4,350 (of 9,241 total)
limit of 250GB? Not hosted on a virtual machine by any chance is it?
Keep well clear of dynamic disks in windows they're only designed to be used in the absence...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2013 at 8:02 am
Firstly, read my article at this link[/url] for more info on AO groups and FCI's
SQLSACT (2/5/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2013 at 7:59 am
can you post results of the following when run from a command prompt on one of the nodes
cluster /quorum
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2013 at 6:20 am
Is there particular problem you are having with the SQLIO application?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2013 at 6:13 am
Aside what Gail has said check the index id for the object. If its a heap then it will naturally contain some fragmentation.
The page allocation marker is 8 pages, any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2013 at 5:45 am
adeel.imtiaz (1/28/2013)
Dear Gurus,Can you please let me know why SQL server is taking more than 2 GB of RAM even PAE switch is not being added in boot.ini?
Can post the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2013 at 2:23 pm
Presumably we're talking multiple time slots to multiple doctors?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2013 at 12:27 pm
SQLCrazyCertified (2/1/2013)
DECLARE fixusers CURSORFOR
SELECT UserName = name FROM sysusers
WHERE issqluser = 1 AND (sid IS NOT NULL AND sid <> 0x0)
This first part declares a cursor checking sql server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2013 at 12:17 pm
ratheesharc (2/1/2013)
Thank you anthony.green,Fulltext index already created the in developing server and want to implement in production server with changing the filegroup.
How do i change my full text file group.
On...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2013 at 5:32 am
Koen Verbeeck (2/1/2013)
Also, if one of the disks crashes, you don't lose everything.
That's not entirely true.
If you have separate data and log drives and no backups and the data...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2013 at 2:01 am
You need to create virtual machines and set up a cluster from there. See my guide at these links
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2013 at 1:44 am
LS does not provide a true read only standby whereas AO does, up to 4 of them in fact.
If you're not convinced that AO replaces LS read the MS...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2013 at 11:00 pm
Is the SQL Server agent service running?
Open Failover Cluster manager and check the clustered service resource is healthy
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2013 at 9:16 am
SQLCrazyCertified (1/29/2013)
Hi, Thanks for both of your replies.I have fixed the issue by doing couple of more log backups then I shrank and it worked.
You have cycled the log back...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2013 at 9:15 am
sdpages (1/29/2013)
I have a SQL log-shipping High availability setup from a Primary Server to a Secondary Server which ships transactional logs every 1 hour. Both the databases are running...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2013 at 9:11 am
Viewing 15 posts - 4,336 through 4,350 (of 9,241 total)