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
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
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
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?
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?
Answer Question | May 5, 2010 8:17 PM
SharePoint, SQL Server 2008 R2
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
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
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
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
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?
Answer Question | May 6, 2010 8:08 PM
Powerpivot, SQL Server 2008 R2, SQL Server 2008 R2 Features
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
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
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
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
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
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
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
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