SQL Server 2005 Express SP3 Memory Usage
Upon Startup of my system the sqlwriter process immediately grabs 700mb of RAM and holds it. As I use the SQL Server to do different thing the memory usage grows and causes the memory on my system to decline. The SQL Server never releases the memory and it causes my system to respond slowly. I [...]

Answer Question   |  May 6, 2010  12:50 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server memory, SQL writer

embedding sql to rpgle
couldd someone pls help me wid generating week number of a year in rpgle. i guess its done thru embedding sql into rpgle pls help

Answer Question   |  May 11, 2010  11:47 AM
AS/400, Embedded SQL, RPGLE, SQL Server

data type alter Error
Hi, m getting an Error when m converting a charater type to a numeric type ie to int or float through ALTER COLUMN command ERROR IS: Cannot convert a char value to money. The char value has incorrect syntax. The statement has been terminated.    

Answer Question   |  May 6, 2010  11:28 AM
Character Set change, SQL Server

BACKUP in SQL SERVER
Hello Sir, Can u get me the answer  to this question Management wants the backups to be done daily. Transaction log backups must be every afternoon and morning and that you should keep in mind that the content of the log will get larger and larger. You also need to take measure to do the log file. [...]

Answer Question   |  May 7, 2010  6:21 AM
SQL Server backup, SQL Server logs

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

Hardware requirements for SQL Server 2008 R2
Where can I find hardware requirements, sizing guides for the new release? 

Answer Question   |  May 5, 2010  8:14 PM
SQL Server 2008 R2, SQL Server 2008 R2 Hardware Requirements, SQL Server 2008 R2 Resource Kits

Advantage of SQl Server 2008 R2 vs Oracle
Can you please explain the advantage of SQL Server 2008 R2 vs. Oracle product (elevator pitch)?

Answer Question   |  May 5, 2010  8:12 PM
Oracle, SQL Server 2008 R2, SQL Server 2008 R2 Benefits

Desiging UCP Environments in SQL Server 2008 R2
What considerations should be kept in mind when designing UCP environments? 

Answer Question   |  May 5, 2010  8:11 PM
SQL Server 2008 R2, UCP Environment

Editions of SQL Server
Can you briefly discuss the different editions of the database that are available now?

Answer Question   |  May 5, 2010  8:10 PM
SQL Server 2008 R2, SQL Server availability, SQL Server Version Comparison

What is PowerPivot?
What is PowerPivot?

Answer Question   |  May 6, 2010  8:08 PM
Powerpivot, SQL Server 2008 R2, SQL Server 2008 R2 Features

Visual Studio 2010 to edit DAC Packs in SQL Server 2008 R2
Will I need Visual Studio 2010 to edit DAC Packs?

Answer Question   |  May 5, 2010  8:05 PM
DAC, Data Tier Applications, SQL Server 2008 R2, Visual Studio 2010

Impact of Statature with Release of SQL Server
How has the acquisition of Stratature impacted this release of SQL Server?

Answer Question   |  May 5, 2010  8:03 PM
Add new tag, SQL Server 2008 R2, Stratature

Data Mining in SQL Server 2008 R2
Are there any investments in Data Mining in SQL Server 2008 R2?

Answer Question   |  May 5, 2010  8:02 PM
Data Mining, SQL Server 2008 R2, SQL Server 2008 R2 Data Mining

Fill out your profile and add a picture to win an iPad
If you haven’t filled out your profile and added your picture, do it now and you could win an iPad. Once you’ve added your picture and filled out your profile, add a comment to this post to let me know and I’ll give you 100 Knowledge Points.  To increase your chances of winning, here’s how to earn more points: [...]

Answer Question   |  April 13, 2011  7:17 PM
Application security, Backup storage, Channel, CIO, CRM, Data management, DataCenter, Development, Exchange, ITKE, ITKE Community, ITKE Contests, Microsoft Windows, SQL Server, VoIP

Invalid Algorithm Specified
I am going through a SSRS tutorial using the AdventureWorks database on a fresh install of SQL Server: I get the following error when trying to deploy a project: Error rsRPCError : Invalid algorithm specified. (Exception from HRESULT: 0×80090008) Standard Edition Microsoft SQL Server Management Studio: 9.00.3042.00 Microsoft Analysis Services Client Tools: 2005.090.3042.00 Microsoft Data [...]

Answer Question   |  May 5, 2010  1:39 PM
Microsoft SQL Server Management Studio, SQL Server, SSRS

About MCTS 70-432 exam
sir As m new to this i would like to know were would i get free download study material for this ,and also like to know is der need to go through a training session from an institute for this exam or can do it on self based . pls guide me for the above [...]

Answer Question   |  May 4, 2010  6:20 AM
IT careers, IT training, IT training and certifications, SQL Server

Training for SQL Server 2008 R2
Is there a site/company that trains for specific usage of the R2 release if one wants to get into it?

Answer Question   |  May 4, 2010  10:14 PM
SQL Server 2008 R2, SQL Server 2008 R2 Training

Role of Excel/Access in SQL Server 2008 R2
What is the role of Excel / Access in SQL Server 2008 R2?

Answer Question   |  May 4, 2010  10:12 PM
Microsoft Access, Microsoft Excel, SQL Server 2008 R2