Impact on application after upgrade from SQL Server 2005 to SQL Server 2008?
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 ?
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 ?
5 pts.
how can make this SQL Server query faster
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...
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...
SQL Server 2005 or 2008?
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...
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...
SQL Server 2005 vs 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?
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?
The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly.
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)...
View Answer
| Oct 28 2008 1:58 PM GMT
SQL Server 2008, SQL Server Analysis Services, Windows Server 2008
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)...
View Answer
| Oct 28 2008 1:58 PM GMTSQL Server 2008, SQL Server Analysis Services, Windows Server 2008
SQL server 2005 vs. SQL server 2008
What is the benefits of SQL server 2008 over 2005 (version 3.5 over 2.0)?
What is the benefits of SQL server 2008 over 2005 (version 3.5 over 2.0)?
Two SQL (2005 and 2008) on the same machine.
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?
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?
Disk Partitioning w/SQL Server 2000/2005/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...
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...
Copying databases in SQL Server 2005 and SQL Server 2008
In SQL Server 2005 and SQL Server 2008, the CREATE DATABASE function creates a new database and copies all the tables that are present in the model database. Is there a function where I can do the same from a template database?
In SQL Server 2005 and SQL Server 2008, the CREATE DATABASE function creates a new database and copies all the tables that are present in the model database. Is there a function where I can do the same from a template database?
Database Newbie
Im quite new to database security and MSSQL server 2005 and 2008 and was hoping to find some extra sites or books to help as I am currently writing an application to send OS info and service tags to our SQL server. I obviously can t have the SQL server directly on the internet with an open port but...
Im quite new to database security and MSSQL server 2005 and 2008 and was hoping to find some extra sites or books to help as I am currently writing an application to send OS info and service tags to our SQL server. I obviously can t have the SQL server directly on the internet with an open port but...
What's a safer upgrade, SQL Server 2005 or the new SQL Server 2008?
Do you think that as of next January (2009), SQL Server 2008 will be too new and we should instead go with SQL Server 2005? FYI, we are not a big installation.
Do you think that as of next January (2009), SQL Server 2008 will be too new and we should instead go with SQL Server 2005? FYI, we are not a big installation.
Learning SQL 2005/2008
I would like to start from the grounds up in learning SQL 2005 and 2008. Any recomendations? I have been working with databases for sometime now including SQL 2000, but I have not jumped to anything newer. Thanks.
I would like to start from the grounds up in learning SQL 2005 and 2008. Any recomendations? I have been working with databases for sometime now including SQL 2000, but I have not jumped to anything newer. Thanks.
Restoring a SQL Server 2005 IBM Rational RequisitePro database from SQL Server 2008, back to SQL Server 2005
I have installed a SQL Server 2005 IBM Rational RequisitePro DB into my local SQL Server 2008. Can I restore this database back to the SQL Server 2005 box? I know this was a problem when going from SQL Server 2005 to 2000.
I have installed a SQL Server 2005 IBM Rational RequisitePro DB into my local SQL Server 2008. Can I restore this database back to the SQL Server 2005 box? I know this was a problem when going from SQL Server 2005 to 2000.
