Reg:Problem with SSAS
Hi team, This is the first time i registered in such communities. I have a problem with SSAS. We planned for a migration from 2005 to sql 2008 which also involves cubes. I am trying to point out SSAS 2005 cubes to 2008 sql server. Is it possible to do this way or do I [...]
Answer Question
| March 31, 2012 2:17 PM
SQL Server 2005, SQL Server 2008, SQL Server migration, SSAS, SSAS 2005
Hi team, This is the first time i registered in such communities. I have a problem with SSAS. We planned for a migration from 2005 to sql 2008 which also involves cubes. I am trying to point out SSAS 2005 cubes to 2008 sql server. Is it possible to do this way or do I [...]
Answer Question
| March 31, 2012 2:17 PM
SQL Server 2005, SQL Server 2008, SQL Server migration, SSAS, SSAS 2005
Use of database backup from lower version to higher version of sqlserver
I am using sqlserver 2000, have a database of 2GB. I want to shift at higher version 2008. What I have to do TO upload my Old version-2000 database backup into sqlserver 2008
Answer Question
| March 31, 2012 6:18 AM
SQL Server 2000, SQL Server 2008, SQL Server database
I am using sqlserver 2000, have a database of 2GB. I want to shift at higher version 2008. What I have to do TO upload my Old version-2000 database backup into sqlserver 2008
Answer Question
| March 31, 2012 6:18 AM
SQL Server 2000, SQL Server 2008, SQL Server database
problem in connect visual studio 2010 to SQL 2008
when i am connecting the sql in my visual studio windows application to open a database file a error occurred you don’t have the permission to open this file contact the file owner or administrator to obtain the permission
Answer Question
| March 31, 2012 11:47 PM
SQL 2008, SQL Server 2008, Visual Studio 2010
when i am connecting the sql in my visual studio windows application to open a database file a error occurred you don’t have the permission to open this file contact the file owner or administrator to obtain the permission
Answer Question
| March 31, 2012 11:47 PM
SQL 2008, SQL Server 2008, Visual Studio 2010
Order by clause in SQL Server subqueries
why the “order by” clause in sub queries must be associated with “top” clause in sql server..??
Answer Question
| April 11, 2012 9:12 AM
SQL Query, SQL Server 2008, SQL Server Query, Subquery
why the “order by” clause in sub queries must be associated with “top” clause in sql server..??
Answer Question
| April 11, 2012 9:12 AM
SQL Query, SQL Server 2008, SQL Server Query, Subquery
Using the PIVOT function
Hi there, I’m pretty new to SQL and I’m trying to use the PIVOT function in Sequel Server 2008 R2. I’ve followed a whole bunch of examples and tutorials but just can’t quite get my syntax right. I have a database of applications. Fields include ApplicationID, Status Description and StatusID, and the date each status [...]
Answer Question
| March 31, 2012 9:13 AM
PIVOT, SQL Server 2008, SQL Server 2008 Reporting Services, SQL Server Reporting Services
Hi there, I’m pretty new to SQL and I’m trying to use the PIVOT function in Sequel Server 2008 R2. I’ve followed a whole bunch of examples and tutorials but just can’t quite get my syntax right. I have a database of applications. Fields include ApplicationID, Status Description and StatusID, and the date each status [...]
Answer Question
| March 31, 2012 9:13 AM
PIVOT, SQL Server 2008, SQL Server 2008 Reporting Services, SQL Server Reporting Services
How do I create jobs using steps in SQL Server 2008 R2 Management Studio
How do I create jobs using steps in SQL2008 r2 Management Studio? I am really having a problem with the syntax when using operating-system commands and transact-SQL commands. Examples would be great.
Answer Question
| March 31, 2012 11:56 AM
Management Studio, SQL Server 2008, SQL Server 2008 R2, SQL Server Management Studio, SQL Server Management Studio 2008
How do I create jobs using steps in SQL2008 r2 Management Studio? I am really having a problem with the syntax when using operating-system commands and transact-SQL commands. Examples would be great.
Answer Question
| March 31, 2012 11:56 AM
Management Studio, SQL Server 2008, SQL Server 2008 R2, SQL Server Management Studio, SQL Server Management Studio 2008
Query Optimizer not Selecting Index on a Computed Column – Performs Table Scan
Hi Denny, we are using the checksum function much like the description in your blog to create a interger column to represent a nvarchar(max) column and use this column to filter our query by. The computed column is not persisted and there is a non-cluster index on it (the only index on the table). When [...]
Answer Question
| March 31, 2012 6:27 PM
SQL Query, SQL Server 2008, SQL Server 2008 64-bit
Hi Denny, we are using the checksum function much like the description in your blog to create a interger column to represent a nvarchar(max) column and use this column to filter our query by. The computed column is not persisted and there is a non-cluster index on it (the only index on the table). When [...]
Answer Question
| March 31, 2012 6:27 PM
SQL Query, SQL Server 2008, SQL Server 2008 64-bit
conversion of SQL Server 2008 stored procedure to Oracle 10g
Can u please give tips on Differences between datatypes, functions, limits,statements etc in both oracle 10g and SQLserver2008 . I need this help for converting Store procedures from SQLserver2008 to oracle 10g
Answer Question
| May 15, 2012 7:54 AM
Oracle 10g, SQL Server 2008, SQL stored procedures
Can u please give tips on Differences between datatypes, functions, limits,statements etc in both oracle 10g and SQLserver2008 . I need this help for converting Store procedures from SQLserver2008 to oracle 10g
Answer Question
| May 15, 2012 7:54 AM
Oracle 10g, SQL Server 2008, SQL stored procedures
Reading xml url into SQL Server 2008 Table with OpenXML
I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url [...]
Answer Question
| June 28, 2011 5:21 PM
SQL Server, SQL Server 2008, SQL Server tables, SQL tables, XML, XML development
I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url [...]
Answer Question
| June 28, 2011 5:21 PM
SQL Server, SQL Server 2008, SQL Server tables, SQL tables, XML, XML development
Increase in Network I/O when running SQL Profiler
Hi, Just wondering why every time I run the profiler on SQL Server 2008, and I monitor the Activity Monitor’s network I/O it increases and when I stop or pause the profiler the network I/O decreases? This occurs the same when I run the profiler remotely or on the SQL Server instance. What has this [...]
Answer Question
| June 21, 2011 4:58 AM
I/O errors, SQL 2008, SQL Profiler, SQL Server 2008
Hi, Just wondering why every time I run the profiler on SQL Server 2008, and I monitor the Activity Monitor’s network I/O it increases and when I stop or pause the profiler the network I/O decreases? This occurs the same when I run the profiler remotely or on the SQL Server instance. What has this [...]
Answer Question
| June 21, 2011 4:58 AM
I/O errors, SQL 2008, SQL Profiler, SQL Server 2008
EmployeeNumber query in SQL Server 2008
I am trying to write a query that will generate employee numbers. Employee number = first initial & first 7 characters of last name. UNLESS that is taken, then it’s first initial, first 6 characters of last name, then the number 1. UNLESS that is taken, then it’s first initial, first 6 characters of last [...]
Answer Question
| June 21, 2011 7:25 PM
IF logic, IF statement, SQL Query, SQL Server 2008
I am trying to write a query that will generate employee numbers. Employee number = first initial & first 7 characters of last name. UNLESS that is taken, then it’s first initial, first 6 characters of last name, then the number 1. UNLESS that is taken, then it’s first initial, first 6 characters of last [...]
Answer Question
| June 21, 2011 7:25 PM
IF logic, IF statement, SQL Query, SQL Server 2008
Problem Querying SQL table from PHP
I recently added a new table to an existing database. Data is entered into the db via a web front end, using PHP 5. I am not a php developer. Our developer is trying to build a search query against the new table (there is data in the table). From the page he is working [...]
Answer Question
| June 20, 2011 2:50 PM
PHP, SQL 2008, SQL Server 2008, SQL tables
I recently added a new table to an existing database. Data is entered into the db via a web front end, using PHP 5. I am not a php developer. Our developer is trying to build a search query against the new table (there is data in the table). From the page he is working [...]
Answer Question
| June 20, 2011 2:50 PM
PHP, SQL 2008, SQL Server 2008, SQL tables
The SSIS 2008 R2 job does not complete execution
I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database. What the package does. 1.The package FTP’s some files to the local folder. I verified to confirm the files are downloaded correctly. 2. Truncate [...]
Answer Question
| June 13, 2011 5:10 PM
SQL Server 2008, SQL Server 2008 R2, SQL Server Integration Services, SQL Server tables, SSIS, SSIS 2008, SSIS Job
I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database. What the package does. 1.The package FTP’s some files to the local folder. I verified to confirm the files are downloaded correctly. 2. Truncate [...]
Answer Question
| June 13, 2011 5:10 PM
SQL Server 2008, SQL Server 2008 R2, SQL Server Integration Services, SQL Server tables, SSIS, SSIS 2008, SSIS Job
SQL Server 2008 restore error
error message : The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)
Answer Question
| March 12, 2012 7:33 AM
Restore Database, SQL Server 2008, SQL Server 2008 error messages, SQL Server backup, SQL Server backup and restore
error message : The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)
Answer Question
| March 12, 2012 7:33 AM
Restore Database, SQL Server 2008, SQL Server 2008 error messages, SQL Server backup, SQL Server backup and restore
SQL processor license
on a physical server we select 2 processors. we then select SQL 2008 STD 1 socket license. since the server has 2 processors, can we assign SQL to only processor and run? if we can, can the second processor on the server be used by the OS on the server?
Answer Question
| May 13, 2011 10:23 AM
Processor Licence, SQL Server 2008, SQL Server licensing
on a physical server we select 2 processors. we then select SQL 2008 STD 1 socket license. since the server has 2 processors, can we assign SQL to only processor and run? if we can, can the second processor on the server be used by the OS on the server?
Answer Question
| May 13, 2011 10:23 AM
Processor Licence, SQL Server 2008, SQL Server licensing
SQL Server Data Files
I have a production server with 10 databases, is it good practice to put all the log files for all 10 databases on one RAID 5?
Answer Question
| May 7, 2011 7:55 PM
Production Servers, RAID 5, SQL, SQL Server, SQL Server 2008, SQL Server Data Storage
I have a production server with 10 databases, is it good practice to put all the log files for all 10 databases on one RAID 5?
Answer Question
| May 7, 2011 7:55 PM
Production Servers, RAID 5, SQL, SQL Server, SQL Server 2008, SQL Server Data Storage
High LATCH_EX wait
What is LATCH_EX wait? Our LATCH_EX wait are very high, what do I need to look at to fix this?
Answer Question
| May 3, 2011 6:19 PM
SQL Server, SQL Server 2008, SQL Server Enterprise Edition, SQL Server performance
What is LATCH_EX wait? Our LATCH_EX wait are very high, what do I need to look at to fix this?
Answer Question
| May 3, 2011 6:19 PM
SQL Server, SQL Server 2008, SQL Server Enterprise Edition, SQL Server performance
Save high volume xml transactions to db
I’m not a DB developer, I know basic select statements but that’s about it. We have a high volume xml web service that takes roughly 200K transactions per day. Each transaction request has a corresponding response so that’s about 400k transactional xmls per day to save. Each request xml is anywhere from 20k to 80k [...]
Answer Question
| May 2, 2011 12:43 AM
SQL Server, SQL Server 2008, XML
I’m not a DB developer, I know basic select statements but that’s about it. We have a high volume xml web service that takes roughly 200K transactions per day. Each transaction request has a corresponding response so that’s about 400k transactional xmls per day to save. Each request xml is anywhere from 20k to 80k [...]
Answer Question
| May 2, 2011 12:43 AM
SQL Server, SQL Server 2008, XML
Link Tables in AS400 to SQL Server 2008
Has anyone set up a link server to their AS400 from SQL Server 2008/5?
Answer Question
| May 3, 2011 10:34 PM
AS/400 tables, AS/400 to SQL Server 2008, AS400 Data Definitions, SQL Server 2008
Has anyone set up a link server to their AS400 from SQL Server 2008/5?
Answer Question
| May 3, 2011 10:34 PM
AS/400 tables, AS/400 to SQL Server 2008, AS400 Data Definitions, SQL Server 2008
Oracle 10g to SQL Server 2008
Our DB is Oracle 10g. Our Clients Test DB is SQL Server. Now sometimes, we do incremental loads, full loads or historic load. The present system what we have is we send the insert statements and the DDL to them and they create and load. I did not write it. It takes 40 hours. Under [...]
Answer Question
| May 2, 2011 9:01 PM
Oracle 10g, Oracle 10g Database, SQL Server, SQL Server 2008, Unix
Our DB is Oracle 10g. Our Clients Test DB is SQL Server. Now sometimes, we do incremental loads, full loads or historic load. The present system what we have is we send the insert statements and the DDL to them and they create and load. I did not write it. It takes 40 hours. Under [...]
Answer Question
| May 2, 2011 9:01 PM
Oracle 10g, Oracle 10g Database, SQL Server, SQL Server 2008, Unix
