We have most of our database systems on 64-bit environment, but one of the application user asked the question what is the advantage of a 64-bit environment in relation to SQL Server application. I would say with the evolution of SQL Server 2005 it has opened many more differentiation between 32- and...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
12-19-2007
Filed under: sql server, package, management, microsoft, server, windows, best practices, 2008, consolidation, planning, x64, 2005, advantages, policies
You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From the available documentation on Technet & MSDN...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
07-25-2007
Filed under: sql server, performance, management, memory, microsoft, security, server, windows, awe, /3gb, pae
In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under Security --> Linked Server. One of the Developer asked me how we can find same in SQL Server 2005 Management studio, here it is: You will find under Management studio open connection against that SQL...