Copy BLOB to BLOB using TSQL
Is there a way I can copy a BLOB from one column to another using TSQL ?

Answer Question   |  November 19, 2010  1:37 AM
BLOB, BLOB TSQL, SQL Server 2008, SQL Server 2008 R2

IT Book Giveaway: Oracle Solaris Cluster Essentials
We’ve got your ultimate in-depth resource on the start-to-finish lifecycle guidance for planning, implementation, management and troubleshooting your Oracle Solaris Cluster. There’s even helpful advice for both Oracle and non-Oracle database environments. Win this valuable resource by answering one of these questions and leaving the link to your answer in the discussion area below. Multiple [...]

Answer Question   |  October 30, 2010  1:48 PM
Clustering, Contests, DHCP, Giveaways, IT answers, IT Books, Oracle, SQL Server 2008 R2, Veeam 4.0, Windows Server 2008

Row by Row Stored Procedure in SQL Server 2008 R2
Hi All, hopefully someone will be able to help me here – i am nearly there but can’t get it right, i am trying to create a stored procedure that when runs will do a query and then send send an email out for each of the rows that it returns. e.g. if i have [...]

Answer Question   |  October 4, 2010  1:36 PM
SQL, SQL Server 2008, SQL Server 2008 R2, SQL stored procedures, Stored Procedures

Is it possible to install SQL Server 2008 R2 on Windows 7 Home Basic 64 bit?
Hi, Is it possible to install MS SQL SERVER 2008 R2 INSTALLATION ON WIN 7 HOME BASIC 64 BIT OS.  

Answer Question   |  September 1, 2010  7:07 AM
SQL Server, SQL Server 2008, SQL Server 2008 R2, Windows 7, Windows 7 64-bit, Windows 7 Home Basic, Windows 7 in 2010

SQL 2008 R2 CPU Count
The SQL 2008 R2 Std specification says it can use up to 4 cpus.  If I have two quad-core xeon processors.  Would this count as 8 or 2?

Answer Question   |  September 2, 2010  5:55 PM
CPU usage, Intel Xeon, SQL 2008, SQL Server 2008, SQL Server 2008 R2

SQL Server 2008 SSIS Update Command Performance Issue
Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB [...]

Answer Question   |  August 13, 2010  9:37 PM
SQL Query Analyzer, SQL Server, SQL Server 2008, SQL Server 2008 R2, SSIS

Master Data Services – Confused by mdm.tblStgMember
Hi, In Denny’s excellent blog on loading data into Master Data Services, he populated the staging tables as follows: INSERT INTO mdm.tblStgMember (ModelName, HierarchyName, EntityName, MemberType_ID, MemberName, MemberCode) VALUES (‘Adventure Works’, NULL, ‘FirstName’, 1, ”, 1), (‘Adventure Works’, NULL, ‘LastName’, 1, ”, 2), (‘Adventure Works’, NULL, ‘EmployeeId’, 1, ”, 3) INSERT INTO mdm.tblStgMemberAttribute (ModelName, EntityName, MemberType_ID, [...]

Answer Question   |  July 27, 2010  5:46 AM
Master data management, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2008 R2 Training

Binary Math windows server 2008 sql server 2008 r2
Operating System: Windows 2008 2 Database: SQL Server 2008 Enterprise R2 issue: I am trying to creat a binary matrix that manages user permissions. My largest number at present is 135069719 the binary representation is : 101001001110000101001 The largest number I eventually have to handle is a 20 digit decimal number Is this possible?

Answer Question   |  June 23, 2012  3:33 PM
Binary Math, SQL Server 2008 R2, User Permissions, Windows Server 2008

Is an existing BI solution required to use the BI capabilities of SQL Server R2?
Is an existing BI solution required to use the BI capabilities of SQL Server R2?

Answer Question   |  May 12, 2010  6:30 PM
Business Intelligence, SQL Server 2008 R2, SQL Server 2008 R2 Features

Cost to Upgrade to SQL Server 2008 R2
How much will it cost to upgrade from SQL 2005 to the 2008 R2?

Answer Question   |  January 28, 2011  8:15 PM
SQL Server 2005, SQL Server 2005 upgrade, SQL Server 2008 R2

Managed Self Service Approach to BI
How can the “managed self service’ approach to BI benefit my organization?

Answer Question   |  May 10, 2010  8:13 PM
Business Intelligence, SQL Server 2008 R2

Performance benchmarks for SQL Server 2008 R2
Have performance benchmarks for SQL Server 2008 R2 been published somewhere?

Answer Question   |  May 7, 2010  8:25 PM
SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring

Do I need to remove SQL Server 2005 to install SQL Server 2008 R2?
Do I need to do a complete removal of 2005, as tried that on a new Windows Web server 2008, as wanted to put 2008 SQL Server.

Answer Question   |  May 7, 2010  8:23 PM
SQL Server 2005, SQL Server 2005 to SQL Server 2008 R2 Upgrade, SQL Server 2008 R2, SQL Server 2008 R2 installation

SQL Server 2008 R2 provides direct integration with Oracle Database
Does SQL server 2008 provide direct integration with the databases built-in within an oracle DB?

Answer Question   |  May 7, 2010  8:20 PM
Oracle Database, SQL Server 2008 R2, SQL Server 2008 R2 and Oracle, SQL Server 2008 R2 Features, SQL Server 2008 R2 Integration

SQL Server 2008 R2 fully supported by Visual Studio Team Database 2008 or 2010?
Is R2 fully supported by Visual Studio Team Database 2008 or 2010?

Answer Question   |  May 7, 2010  8:17 PM
SQL Server 2008 R2, SQL Server 2008 R2 Benefits, Visual Studio 2010, visual studio team Database 2008

What is the process to upgrade a database from SQL Server 2000 to SQL Server 2008 R2?
What is the process to upgrade a database from 2000 to 2008?

Answer Question   |  May 7, 2010  8:15 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2008 R2, SQL Server 2008 R2, SQL Server Upgrade

Can you explain Master Data Services
Can you explain Master Data Services?

Answer Question   |  May 7, 2010  8:13 PM
Master Data Services, SQL Server 2008 R2, SQL Server 2008 R2 Features

How many processors can SQL Server 2008 R2 support?
How many processors can SQL Server 2008 R2 support?

Answer Question   |  September 9, 2010  8:18 PM
SQL Server 2008 R2, SQL Server 2008 R2 Features, SQL Server 2008 R2 Processors

What sort of connections are there to SharePoint in SQL Server 2008 R2?
What sort of connections are there to SharePoint?

Answer Question   |  May 5, 2010  8:17 PM
SharePoint, SQL Server 2008 R2

Help with Data Quality
Data Quality is a big issue in our firm as we have a lot of applications and inputs into our production databases.  Is Microsoft doing anything to help us with data quality, especially on existing data?

Answer Question   |  May 5, 2010  8:15 PM
Data quality, Data quality tools, SQL Server 2008 R2, SQL Server Data Quality