Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » sql Server 2008   (RSS)

A delete statement in SQL Server 2000 takes around 1.5 GB of Transaction Log Space, Where as in SQL 2008 it can take around 3.2 GB!

There are a lot of Changes in the Transaction Log Architecture of SQL 2000 and SQL 2008. There is a huge difference in the way the log records are maintained in SQL 2000 vs SQL 2005/2008. We keep more information in the Transaction Log in SQL 2005/2008. Read More...
Posted Saturday, August 29, 2009 12:38 AM by sanjayap | 0 Comments

Query to the SYSTEMINDEX to read the Microsoft search results fails when using Search.CollatorDSO provider

We can query the results from the Microsoft search through SQL server. If we create a linked server with Search.CollatorDSO provider and try to query the SYSTEMINDEX to read the Microsoft search results. We get an error in SQL server 2008 Below is the Read More...
Posted Thursday, August 27, 2009 2:36 PM by sanjayap | 0 Comments

In SQL Server 2008, the product name and the data source information goes blank in "Linked server properties" window

In SQL Server 2008, sometimes the product name and the data source information goes blank in Linked server properties window for a Linked server of provider type Microsoft OLEDB provider for SQL Server or SQLOLEDB . When we create a Linked Server of type Read More...
Posted Sunday, August 23, 2009 6:28 PM by sanjayap | 0 Comments

Unable to install SQL Server 2008 Standard Edition on a Windows VISTA machine

The error message we get is as below, <Error Message> 02/04/2009 14:33:20.418 02/04/2009 14:33:20.419 Setup launched 02/04/2009 14:33:20.420 Attempting to determine media source 02/04/2009 14:33:20.421 Media source value not specified on command Read More...
Posted Thursday, August 20, 2009 8:50 PM by sanjayap | 1 Comments
Filed under: ,

Upgrade from SQL 2005 to SQL 2008 might fail with MsiGetProductInfo error

Consider a scenario where an upgrade from SQL 2005 to SQL 2008 fails with the following messages while installing Setup Support Files. ******************************************************** TITLE: SQL Server Setup failure. ------------------------------ Read More...
Posted Saturday, June 13, 2009 12:46 AM by sanjayap | 1 Comments

Setting up Database mirroring in SQL Server 2008 using T-SQL when the database is encrypted using Transparent Data Encryption.

Consider the following Scenario, You are using SQL Server 2008 Enterprise edition RTM or higher version and you are Transparent database encryption (new feature introduce in SQL Server 2008) to encrypt the Database to be mirrored. The database encryption Read More...
Posted Tuesday, March 31, 2009 3:03 PM by sanjayap | 12 Comments

How to list all the installed SQL Server on the Server using TSQL

The SQL Server instances are independent and do not know each other. The method is to query the registry to find the instances. You can use the following Script to list all the installed sql server on the server using TSQL Solution ========= Set NoCount Read More...
Posted Friday, March 20, 2009 8:49 PM by Pariks | 1 Comments

SQL Server 2008 Setup fails to Install with Error 1402

SQL Server 2008 setup may fail with the following error even though you are running the setup as administrator. You might get these kind of errors in Detail.txt after you cleaned up an failed setup (from Add/Remove Programs) and try to run the setup again. Read More...
Posted Thursday, March 19, 2009 2:34 AM by Pariks | 2 Comments
Filed under: ,

Why Do I see more threads per SPID in sysprocesses than MAXDOP?

Most of the Customers using sql server 2000,2005 and 2008 have this doubt in their mind when using parallelism in sql server. Why Do I see more threads per SPID in sysprocesses than MAXDOP? The above question is being addressed in the following blog by Read More...
Posted Monday, January 05, 2009 11:49 AM by sanjayap | 3 Comments

Step by Step Procedure to Implement SQL Server Transactional Replication with Oracle as Publisher

/*** Note: Kindly follow the Instruction in each step ***/ /*** If you are using SQL Server 2008 Management Studio, Ctrl-Shift-M might not work. In that case go to “Query” menu and click on “Specify Values for Template Parameters” ***/ 1) Logon to ORACLE Read More...
Posted Thursday, October 16, 2008 6:59 PM by sanjayap | 2 Comments

Facts about How SQL Server 2008 setup works... #3

Setup.exe can be patched dynamically on the fly One of the drawbacks of the sql server 2005 setup was that if there was any bug detected in the code of the setup.exe , the patching of the setup.exe was difficult and at times next to impossible. With Katmai, Read More...
Posted Monday, September 22, 2008 1:25 PM by sanjayap | 2 Comments

Facts about How SQL Server 2008 setup works... #2

Salient Features of Sql Server 2008 (Katmai) Setup Minimize the MSI code for setup and use MSI code for what it does the best. In Sql 2005 entire setup process was coded using MSI code which uses the Windows Installer code and was found to be root cause Read More...
Posted Sunday, September 21, 2008 6:33 PM by sanjayap | 1 Comments

Facts about how SQL Server 2008 setup works...

In order to install, upgrade, uninstall, and patch the sql server 2008 instance on the system we need to call the setup.exe from the installation media. The setup.exe is an unmanaged code which checks the basic pre-requisites to launch the actual Setup Read More...
Posted Thursday, September 18, 2008 2:11 AM by sanjayap | 1 Comments
 
Page view tracker