Viewing 15 posts - 1 through 15 (of 22 total)
The reason for the confusion I guess is because this is not "multiplexing" which is what happens in the case of accessing through a webserver and such. This is virtualization....
June 26, 2007 at 9:40 am
According to MS presales, device licence + server licence works in this case.
June 26, 2007 at 9:27 am
Device licence + server licence works.
According to the article on
http://www.microsoft.com/sql/howtobuy/faq.mspx
"A device CAL covers access by multiple users to server software from a single, shared device".
You can get...
June 22, 2007 at 2:42 pm
Nice article. Just wanted to point out something.. In Logshipping when you mentioned that it could be used for reporting or as a read-only database, when ever the logs need...
May 25, 2006 at 2:58 pm
The sequence of steps you listed out is accurate. When you say "restart every node" , make sure you "restart SQL Server" which is different in this case because when...
May 25, 2006 at 1:37 pm
Maintaining a Failover Cluster - topic in SQL BOL might help. You would want to follow routine DR strategy of backups on a cluster in case the disk fails to...
May 25, 2006 at 1:27 pm
you might want to check
select * from master..sysprocesses where blocked > 0 to see if there is any blocking happening. Also, reindexing and updating the stats might help. (unless...
May 25, 2006 at 1:24 pm
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 3072
RECONFIGURE
GO
You dont have to do anything speific on other nodes to enable AWE. Since SQL stops to manage memory...
May 25, 2006 at 1:18 pm
You cannot do anything at the SQL Server level to get it to use 3 GB of memory because that is dependent on the processor you use and the operating...
May 25, 2006 at 1:03 pm
Inside SQL Server is a book that would give you good information. Books Online is another resource.But if you are looking for scenarios when recovery would be needed, I guess you...
May 25, 2006 at 12:52 pm
You might also want to check to see if the disk is causing the contetion, check the disk queue length parameter in the perfmon. A cheaper workaround would be to take...
May 25, 2006 at 12:47 pm
You dont have to do that one table at a time. You can place the names of the tables in a table and then select a few tables at a...
October 20, 2005 at 5:13 pm
I dont think there is any such limit. The number of records SQL Server 2000 can process in a second is dependent on the number of processors, the load on...
October 19, 2005 at 5:59 pm
You could also run the 'select * from master..sysprocesses' query to find out the processes in all databases.
October 19, 2005 at 5:53 pm
Try throwing the database into single user mode and from the same connection restore the database.
October 19, 2005 at 5:39 pm
Viewing 15 posts - 1 through 15 (of 22 total)