We are about to migrate a database from SS2005 32-bit to 2008 64-bit. One of the biggest drivers for this is the compression capability in SS2008. We expect to shrink our 2TB database down to about 500GB (proven in testing), and get the comparable IO performance improvements (4x faster reads – also proven in testing). [...]
Answer Question | February 2, 2009 8:50 PM
SQL Server 2005 to SQL Server 2008 Migration, SQL Server 2008, SQL Server 2008 Compression, SQL Server Compression, SQL Server migration
Hi, Is there a way to pull an AS/400 File into SQL server 2008? From within SQL 2008 we do not see an ODBC connection that will work for the 400(??) I am not familiar with SQL server and we need to get some data to it. Can anyone shed some light on what I [...]
Answer Question | January 30, 2009 6:28 PM
AS/400, AS/400 to SQL Server 2008, ODBC, SQL Server 2008
I want to transfer a database from one server to another server using SQL Server 2008, and then I want to write a script which i can update the database daily automatically. How can these be done?
Answer Question | January 26, 2009 3:09 PM
SQL Server 2008, SQL Server Database Migration, SQL Server databases
I was hoping someone could tell me if its ok to install SQL2008 Standard for use with company accounting and billing applications and also install SQL2008 Express for use with Sharepoint 3.0 on the same server. I could put the versions of SQL on different volumes if that helps. The load Sharepoint puts on the [...]
Answer Question | January 25, 2009 3:15 PM
Multiple SQL Server Installations, SQL Server 2000, SQL Server 2000 Standard Edition, SQL Server 2008
Can Sql Server 2000/2005/2008 exist on the same machine
Answer Question | January 23, 2009 4:15 PM
SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server upgrades
What are the alternatives to store data more than 2 GB in SQL Server 2005 or 2008?
Answer Question | January 22, 2009 6:13 PM
SQL Server 2005, SQL Server 2008, SQL Server Data Storage, SQL Server Database Consolidation
I am on SQL Server 2008, and we want the clients to be able to build their own reports whenever they want. Are there any tools out there that can do this?
Answer Question | January 22, 2009 5:54 PM
SQL Server 2008, SQL Server reporting, SQL Server Reports
I have encrypted data in MS SQL Server 2000. I want to migrate in MS SQL Server 2008. I have migrated successfully through the attach/dettach process but when I am trying to decrypt the data. is it giving different result or value. is the right process to migrate the encrypted data? Please suggest me ASAP. [...]
Answer Question | January 7, 2009 9:23 AM
SQL Server 2000, SQL Server 2000 encryption, SQL Server 2000 migration, SQL Server 2008, SQL Server 2008 encryption, SQL Server migration
I hav been trying to learn sql 2005 from lyk a month or two and i think i have done a good job. Now i was about to try some security stuff in it but i saw that sql 2008 is in market. Can any body suggest me that what is the difference between the [...]
Answer Question | January 6, 2009 11:41 AM
SQL, SQL Anywhere Studio, SQL Anywhere Studio/M-Business Anywhere/Avantgo, SQL Server 2005, SQL Server 2008, SQL Server security
Struggling with SISS I have data source and data destination With some bad data, I can’t figure out how to set up sending the bad row to another destination There are over 50 columns. Sorce is a tab delimited text file Desitnation is SQL Table
Answer Question | January 5, 2009 9:27 PM
SQL Server 2008, SQL Server 2008 Integration Services, SQL Server Integration Services, SSIS
What would be impact/changes to be done in my application which is using general SQL for upgradation from SQL Server 2005 to SQL Server 2008 ?
Answer Question | December 12, 2008 8:15 AM
SQL Server 2005, SQL Server 2005 upgrade, SQL Server 2008, SQL Server 2008 performance, SQL Server migration, SQL Server performance, SQL Server upgrades
All, how can I make this query faster? Here is my code of stored procedure: ALTER procedure [dbo].[GetLMPReport] ( @typeId tinyint, @dataType varchar(2), @date date ) AS begin select distinct p.name, ISNULL (td24.price, 0) as ’00′, ISNULL (td1.price, 0) as ’100′, ISNULL (td2.price, 0) as ’200′, ISNULL (td3.price, 0) as ’300′, ISNULL (td4.price, 0) as [...]
Answer Question | December 4, 2008 6:10 PM
SQL Query, SQL Server 2008, SQL stored procedures, T-SQL
I am a database user going back many years and have used several different platforms from the high-end (NCR’s Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical modelling and analysis. We also [...]
Answer Question | December 8, 2008 6:05 PM
Microsoft Access, SAS, SQL, SQL Server 2005, SQL Server 2005 vs SQL Server 2008, SQL Server 2008, SQL Server Version Comparison
How to format crlf inside a field text
Answer Question | November 5, 2008 8:31 PM
CRLF, SQL Server 2008
When comparing SQL server 2005 to 2008, does 2008 hold more data, or is it just an upgrade on what you are able to do with the data?
Answer Question | October 29, 2008 11:55 PM
SQL Server 2005, SQL Server 2008, SQL Server upgrades
We have installed sql server 2008 (64 bit) on windows server 2008 enterprise edition, in which around 10 jobs to populate the dimensions from relational db to analysis cubes. I am frequently facing the same error and the services gets stopped. “The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly. It has done this 1 [...]
Answer Question | October 18, 2010 1:58 PM
SQL Server 2008, SQL Server Analysis Services, Windows Server 2008
What is the benefits of SQL server 2008 over 2005 (version 3.5 over 2.0)?
Answer Question | February 8, 2011 8:01 PM
SQL Server, SQL Server 2005, SQL Server 2008
We are planning to install some CRM software and it can only use 2005, however we will be upgrading to SQL 2008, is it possible to run 2 SQL versions (2005 and 2008) and is it a good idea from backup, maintenence and running. Will there be issues?
Answer Question | April 26, 2012 7:08 AM
SQL Server 2005, SQL Server 2008
I recently read some information regarding aligning the Disk for use with SQL Server from Mr. Denny. My understanding is, SQL Server handles data in chunks of 64KB, so the disk drive SQL Server writes to containing data and log files should be configured to work in 64KB chunks. The articles I am referring to [...]
Answer Question | September 28, 2008 3:51 PM
Partitioning, SQL Server 2000, SQL Server 2005, SQL Server 2008
how can i add a system tray icon for sql 2008 just like sql 2000?
Answer Question | September 28, 2009 8:31 PM
SQL Server 2000, SQL Server 2008