.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

SQL 2008 SP2 in a virtual environment

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :Sql Server
 

I read that the performance isnt as good as the same hardware config with a dedicated server, but how much of a difference is there.   I would prefer to use 1 of my Hyper-V vhd 's for this internal SQL.    This will host about 20-30 users of sharepoint and a few other local production apps

 

Thanks

Craig

 




View Complete Post


More Related Resource Links

Applying SQL 2008 SP1 CU 2 in MOSS environment

  

Hi all,

I have a dedicated SQL 2008 x64 std edtion with SP1  for MOSS 2007 SP2, I would like to apply the CU2 for activating the lock memory page feature, I would like to know if there any incidence on the sharepoint farm after applying this CU on my SQL server?

Thank you for your feedback about that.

MIKE

 


MIKE

Location Error on Install on Virtual Server - SQL Server 2008 R2

  
I'm trying to install SQL Server 2008 R2 on a Xen Server running Server 2008 R2. I get the following error.   The disc has been used to successfully install on other machines in my office. The virtual machine location settings are also all United States English. Any thoughts?

in-place upgrade in cluster environment(2000 to 2008),How to do compatabilty Test ???

  
Hi all As of I know there are three tools are involved in Upgrade process. 1.UpgradeAdvisor 2.RML utility 3.SQL Server Upgrade Assistant. I want do compabilty test...which tools in Best for that...  Thanks in advanceSNIVAS

Visual Studio 2010 Lab Environment for Student to deploy to a IIS 7.5 web server with SQL 2008

  
Currently the environment I am trying to create is a teaching lab for Visual Studio 2010 and ASP.NET website development. The intent is to setup an environment where students can create a website with an attached database written with the assistance of Visual Studio 2010. When the website is completed they need to use one of the Visual Studio deploy technologies to upload the website to a locally run server (Windows 2008 R2 with IIS 7.5 running and SQL Server 2008.) I am responsible for setting up the correct deploy technology in Visual Studio as well as setting up the IIS 7.5 deployment server that is running the right version of SQL Server. I have already started this process and figured out how to configure a deployment package in visual studio and have it published on our local server. I am trying to get a very streamlined environment that does not require students have to configure a lot of SQL strings and IIS settings because this is not really what the teaching lab is all about. Just to let you know, we have had  this exact setup using Visual Studio 2008, Server 2003 with front page server extensions on IIS 6.0 and SQL Server Compact edition running on the server. My issue is that since it is now time to update everything there does not seem to be something comparable. Any help would be greatly appreciated. If someone has an idea of the 

SSRS 2008- redirect to /Reports virtual directory?

  
We have just configured a new SQL Server Reporting Services 2008 server. So far, everything is going well, with the exception of one thing: we want anyone who hits the root of the webserver to be redirected to the /Reports virtual directory. So, if the user enters http://servername.domain.com/ it would redirect to http://servername.domain.com/reports. In SSRS 2005, it was easy to configure IIS to do this, but with SSRS 2008, I cannot figure out how to make this change. Help?

How to take backup of single table in SQL server 2008 and SQL Server Management Studio Environment

  

Hi,

I know how to take total database backup in SQL server 2008 and SQL Server Management Studio Environment but i failed to take single table backup in database.

It is possible to take single table backup in Oracle using PL/SQL Developer IDE.

Thanks in Advance..... 


How to setup Sharepoint 2010 development environment on windows home premium 7 using Virtual Box for

  

Hi,

PC Specs:

- 64-bit, quad processor, 8GB RAM, Windows 7 Home Premium laptop.

I need to :

- setup Sharepoint 2010 development environment using Virtual Box.

- Setup SSRS 2008 R2 for reporting services.

I I have gone through several blogs and post but am not able to understand a clear sequence of what am I supposed to do. Please Please help me setup my machine in a way I can use it for my personal use and also use it for Sharepoint development.


Upgrading clustered environment from sql 2005 to 2008

  

 

Hi,

Can any one give me the best approach to upgrade a 4 node (a/a/a/p) clustered environment from sql 2005 on win server 2003  to sql 2008 on win server 2008 with minimum downtime.

Regards,

Sandhya.

 


Hot fixes for Windows 2003 SP2 for Installing SQL Server 2008 R2 In Cluster environment

  

Hello all

Please some body help me to  find Hot fixes  for Windows 2003 SP2 to install SQL Server 2008 R2 In Cluster environment.

 

 

 

Thanks in Advance  


SNIVAS

SQLDIAG fails in SQL Server 2008 Cluster environment.

  

SQLDIAG failing with following errors in SQL Server 2008 cluster environment:

SQLDIAG Error opening Software key . Function result: 2. Message: The system cannot find the file specified.
SQLDIAG Failed to open Software\Microsoft\MSSQLServer key . Function result: 2. Message: The system cannot find the file specified.
SQLDIAG Failed to open Software\Microsoft\MSSQLServer key . Function result: 2. Message: The system cannot find the file specified.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG . Function result: 87. Message: The p

Environment.GetEnvironmentVariable("windir") not working on Windows 2008 R2 Sandard Edition

  

In my .Net code I have used following method GetEnvironmentVariable("windir")

Environment.

 

It was working fine on Windows Server 2003 but its not returning any thing in Windows 2008 R2.

Please give me solution to this problem


SSIS 2008 changes in dev environment

  

hi we have a project developed in ssis 2005 now the similar project is going to be implimented for a different market using sql 2008. there are  huge flat files  used as sources and other oraacle DB.

we will be using a unicode DB as our dest.In SSIS 2008 is there any design considerations which i need to take care. or can i do the development in same lines of sql 2005

Please share on any info of the pros and con's of 2005 and 2008

Thanks

 


SSIS package runs very slow on SQL 2008 R2 server, runs very quickly on virtual XP machine

  

Hi All,

I've been troubleshooting this issue on and off for a few weeks now.  I've scoured these forums and looked through sqlis.com, but I'm just about out of ideas.  Here's what's happening.

I have a *very* simple integration services package I developed on a  virtual Windows XP machine running on my workstation.  The package uses a script task to simulate a one-row source with four columns (int, char(64), varchar(512) and char(2)) and then passes that off to a fuzzy lookup.  The fuzzy lookup is running against a table of only about 6,000 rows.  The package then inserts the results into a table and exits.

When I run this from my virtual XP machine, it completes in 1-2 seconds.

When I execute this on the server (either as a job or through DTExec) it takes 14-18 seconds.  The server stores the package in MSDB and is also the location where the fuzzy lookup happens.

I've tried using the 32-bit runtime, creating 32- and 64-bit aliases to the server, changing the name of the server from the name to the IP address and port, stopping/restarting SQL Agent and SSIS Services... none of this seems to change the execution time.

The one thing I've found is that if I enable package logging on the logging tab of the job, using the SSIS Log Provider for SQL Server and pointing it to the same connection st

Problem to create visual studio 2008 environment in windows server 2008

  

I am working on FTS (File Text Search) for file extension like .doc, docx, ppt, pptx, txt, pdf.

For developing FTS I used environment:

Development IDE:  Visual Studio 2008

Language: C#

OS:

Using Conditional Split data Transfer in SSIS 2008

  
This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend