Windows Server 2008 R2 Enterprise vs Standard any improvement with SQL Server 2008 ?

I have an opportunity to upgrade to Windows Server 2008 R2 Enterprise Edition from my Standard Edit…

What is the proper way to do one to many joins with aggregates

I have an Orders table and an Orders_details table. The Orders table has totals for the Sale_amt in…

allmembers

how I'm the connetion SQL to visual studio c++ 2005

Data Migration from SQL Server 2005 to Oracle 9i

Hi all, I'm new in this area but I was asked to investigate which tools or ways there are to migrat…

Find expiration date of SQL Server 2008 Evaluation

Where can I find the expiration date of SQL Server 2008 Evaluation Edition? It's not in Help >&…

YTD and Current Period SubTotals against a Progress Database

I am trying to display a YTD cost and Current Period cost on the same report against a Progress dat…

Error Attaching Database

I'm trying to attach a database using the wizard and I'm getting an error message: ----------------…

How do I delete SQL Server Cluster Manager

All SQL Server 2005 objects have been removed via Control Panel. Microsoft SQL Server 2005 key has …

More complex reports with Reporting Services

Apologies if this question has come up before; it's not the easiest topic to search for and I haven…

XSD to sqlserver2k5 database

hi all, is it possible XSD to sqlserver2k5 database conversion, i need the working rule, help me

The subscriber_id in MSSubscriptions table. What table give u the subscriber name of the subscriber…

Question about RowVersion Data Type

My SQL as follow, declare @tEmployee table ( TrnxID int primary key identity(1,1), Nme varchar(100)…

Barcode font will not print

I have a SQL 2005 report using Free 3 of 9 Extended barcode font. Everything looks fine until I pr…

SQL 2005 Replication

There are no conditions in replication against having a composite key is there?

Creating a connection from VB

I'm not sure if this is the right place to put this post,but hopefully it is! When we create a conn…