Viewing 15 posts - 1,576 through 1,590 (of 2,008 total)
Drop & Recreate Login.
To create a SQL Server login that uses Windows Authentication (SQL Server Management Studio)
1.In SQL Server Management Studio, open Object Explorer and expand the folder of the...
November 15, 2011 at 10:42 am
If failover occurs during a transaction in which an index or table is created and then changed, failover might take longer than usual. For example, failing over during the following...
November 15, 2011 at 10:26 am
ashuthinks (11/15/2011)
please explain this with example. i'm newbie
also why it cannot be specified for tables modified by...
November 15, 2011 at 10:20 am
RonKyle (11/15/2011)
November 15, 2011 at 10:17 am
What if the datacenter hosting the active node and the witness loses all power?
Role of the Witness in Automatic Failover
________________________________________
Throughout a database mirroring session, all the server instances...
November 15, 2011 at 10:09 am
Alan Naylor (11/15/2011)
I want to drop and recreate indexes and partition some tables on the clustered server.
CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name
...
November 15, 2011 at 10:04 am
Getting Started with SQL Server 2008 Failover Clustering
http://msdn.microsoft.com/en-us/library/ms189134(v=SQL.100).aspx
Clustered Index Structures
November 15, 2011 at 10:02 am
Alan Naylor (11/15/2011)
November 15, 2011 at 9:59 am
The witness is an optional instance of SQL Server that enables the mirror server in a high-safety mode session to recognize whether to initiate an automatic failover. Unlike the two...
November 15, 2011 at 9:57 am
is there any way SQL Server can stay up even if a data center goes down? Is mirroring the 2 datacenters the best option?
One Witness can monitor Many mirrored...
November 15, 2011 at 9:55 am
mar311 (11/15/2011)
Thanks Dev. So it *must* have SP4 installed before putting 2008 Native Client on it?
Yes you should. And if you are planning for upgrade I would suggest for a...
November 15, 2011 at 9:51 am
Exploring PowerPivot for Excel in SQL Server Project "Denali"
There was a session on it in PASS summit. So you may download the sessions material if you have access to those.
November 15, 2011 at 9:45 am
What is the best forum for that kind of question?
SQL Server Central 😛
November 15, 2011 at 9:40 am
SQL Server 2008 R2 Native Client supports the version of SQL Server in which it is released, and SQL Server 2000 SP4, SQL Server 2005, and SQL Server 2008.
November 15, 2011 at 9:29 am
the *.trn files are not performed in continuous dates
That's the reason for Space Consumption.
Transaction Log Truncation
If log records were never deleted from the transaction log, it would eventually fill...
November 15, 2011 at 9:24 am
Viewing 15 posts - 1,576 through 1,590 (of 2,008 total)