Database Size on SQL Azure
What’s the max size database we can have on SQL Azure?

Answer Question   |  May 4, 2010  10:03 PM
SQL Azure, SQL Azure Database Size, SQL Server 2008 R2

Will SQL server 2008 R2 support itanium?
Will SQL server 2008 R2 support itanium?

Answer Question   |  May 4, 2010  9:59 PM
Itanium, SQL Server 2008 R2

Selecting Reporting Builder 3.0 on the Report Manager Site
Can Report Builder 3 be added as a selectable tool on the Report Manager site created by a SQL Express with advanced features installation? Does the license allow using RB3 and is there documentation on how to get it to show up at the top of the report manager site?

Answer Question   |  May 3, 2010  9:58 PM
Report Builder 3.0, SQL Express, SQL Server 2008 R2

Performance and Resource Consuming Monitors SQL Server 2008 R2
Are there any specific GUI tools available to monitor the performance and resource consuming process? At present we are using third party tool to do so (Spot light)?

Answer Question   |  January 28, 2011  9:55 PM
SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring

Final Version of Report Builder 3.0
I got a Beta of RB 3.0 several months ago. Has the final been released?

Answer Question   |  May 3, 2010  9:52 PM
Report Builder 3.0, SQL Server 2008 R2

Virtual Lab for SQL Server 2008 R2
Instead of downloading, is there a virtual lab for SQL server 2008 R2?

Answer Question   |  May 4, 2010  9:50 PM
SQL Server 2008 R2, SQl Server 2008 R2 Virtual Lab, Virtual lab

Why get SQL Server 2008 R2
Why should I change from SQL Server 2008 to R2? 

Answer Question   |  May 4, 2010  9:49 PM
SQL Server 2008 R2, SQL Server 2008 R2 Benefits

Is Report Builder 3 the version that goes with SQL Server 2008 R2?
Is Report Builder 3 the version that goes with R2?

Answer Question   |  May 4, 2010  9:48 PM
Report Builder 3.0, SQL Server 2008 R2

SQl Server 2008 R2 features in SQL Express
If I go to the SQL Express download site and install SQL Express with advanced features will it include any R2 features and if so where can I find a list of differences between the Express I installed 3 months ago and what I can install now?

Answer Question   |  May 4, 2010  9:46 PM
SQL Express, SQL Server 2008 R2, SQL Server 2008 R2 Features

Do Businesses still need SQL Server?
With all the upgrades to MySQL, has SQLServer needed to step up its game or do you think business still needs SQLServer?

Answer Question   |  May 3, 2010  9:44 PM
MySQL, SQL Server 2008 R2

Integrate ERP with SQL Server 2008 R2
If we run a third party ERP installed in SQL Server 2008 r2, how do we integrate it SQL Azure?

Answer Question   |  May 3, 2010  9:42 PM
ERP, SQL Azure, SQL Server 2008 R2

Security on the Cloud
How you are securing the confidential data? Is there a chance for someone to access or view our confidential data by whoever is maintaining the Server @cloud? How do you ensure what you said above?

Answer Question   |  May 3, 2010  9:41 PM
Cloud Security, SQL Server R2

Ensuring the Data security by hosting the server @cloud?
How you are ensuring the Data security by hosting the server @cloud?

Answer Question   |  May 3, 2010  9:28 PM
Microsoft SQL Server, SQL Server, SQL Server 2008 R2

Merge synchronization using only Sql Server Express 2005
I’m developing a database application using VB.net. I would like to use SQL Server Express for the database so that my customers won’t have to purchase additional software along with the cost of my software. One of my requirements is that the application can use merge synchronization. Will merge synchronization work using RMO or some [...]

Answer Question   |  May 4, 2010  8:49 PM
RMO, SQL Server Express, SQL Server Express 2005, SQL Server replication, SQL Server synchronization

Win a Dell Precision T7500 Workstation
All you have to do is correctly answer 5 multiple choice questions, each with a hint provided, and you could be the owner of a new Dell Precision T7500 Tower Workstation Desktop Computer with the Quad Core Intel Xeon Processor. Even if you don’t win, you still get 200 Knowledge Points for your efforts, and [...]

Answer Question   |  May 3, 2010  8:34 PM
Application virtualization, AS/400, Channel, CIO, CRM, Data storage, DataCenter, DataManagement, Dell, Development, enterprise networking, Exchange, Intel Open Port, ITKE Community, ITKE Contests, Linux, Lotus Domino, Mobile, SQL Server, VoIP, Windows Server

sysfiles1 is missing sql server 2005
is sysfiles1 table removed in SQL Server 2005 onwards?

Answer Question   |  May 4, 2010  2:19 PM
SQL Server 2005, sysfiles1

SQL EXCEPTION JOIN
I have three files (orderinfo, deliveryinfo and itemlines). The three files entries shall exist as 1 to 1 to many. The files contains orders from 10+ years. Thus data has been migrated several times by various people. I have discovered that the one-to-one-to-many rule has been broken for many orders. I wrote a pgm to [...]

Answer Question   |  May 4, 2010  1:01 AM
SQL, SQL Exception, SQL EXCEPTION JOIN, SQL join

My as/400 SQL is getting a ‘ Value for column too long.’ error msg
Value for column or variable SPDESC too long. UPDATE mbmtest01/wbmscur set spdesc = (Select itdsc FROM amflib7/itemasa WHERE itnbr = spptno)  WHERE EXISTS (SELECT DISTINCT itdsc FROM amflib7/itemasa WHERE itnbr = spptno)  How do I make the field truncate the larger input field. The input field is 30 bytes and the receiving field is 15 [...]

Answer Question   |  May 3, 2010  4:22 PM
AS/400 administration, AS/400 SQL, SQL tables

AS/400 SQL for two file compare and update
Need a update in SQL comparing two tables check description and if equal to blank then match keys on master update blank desc. field with master desc field. UPDATE mbmtest01/wbmscur  set spdesc = itdsc  from amflib7/itemasa  where spdesc = ‘ ‘ and itnbr = spptno Keyword FROM not expected. Valid tokens: [end-of-statement][/end-of-statement].

Answer Question   |  April 30, 2010  9:15 PM
AS/400, AS/400 SQL, SQL Server

Partitioning in SQL Server 2005/2008
We have partitioned 5 large tables across 10 partitions (with 10 filegroups) and with a set of 5 – 6 users the performance was adequate, with minimal conflicts (like deadlocks etc), but we want to implement this scheme that can scale to say 300 users. With regard to this I have the following questions:  - [...]

Answer Question   |  April 28, 2010  5:19 PM
SQL Server 2005, SQL Server 2005 Partitioning, SQL Server 2008, SQL Server 2008 Partitioning