• How to determine proper max memory setting

    How do I determine the proper max memory setting for our system? We have Windows server 2003 R2 entreprise ed, sp2. It is 32 bit. There is 8.00 Gb of ram. We have just upgraded to SQL Server 2008 sp1, enterprise ed. Now we're having some memory problems. Thanks very much for any help with this.

    denise7525 pointsBadges:
  • Multi Location Software in VB.Net

    I want to create multi location software in VB.net .Basically, my scenario is like ………..software should work for 9 branches. One main branch where SQL server is located and rest all sites are remote site where software installed and directly connected to central SQL server. Please give me...

    Servernetwrkdbase60 pointsBadges:
  • Get your free IT book: The Rails 3 Way

    Here's your chance to win "The Bible for Ruby on Rails Application Development"! There are two ways to get your copy of the book that "strips complexity from the development process," answer one of four questions and post the link to your answer in the discussion section below. Another way to enter...

    MelanieYarbrough6,345 pointsBadges:
  • DB backup onto External Hardrive

    Hi I have connected an external USB hard drive to my SQL server (2000). When i attempt to backup from Enterprise manager (to the harddrive) i cant seem to find the drive in the list. The drive has been made active (active partition) and can be used from windows explorer without any problems. I...

    KH155 pointsBadges:
  • Check IF Field is Numeric in AS/400 SQL

    is there a function to check if field is numeric (like ISNUMERIC in standard SQL)?

    Jaggerdude60 pointsBadges:
  • Can’t close or clear file in iSeries V5R3

    Generally we create a file in QTemp when returning data for a stored procedure. The cursor is left open so the data can be accessed. I neglected to copy the file to qtemp and now on our test system, I can't close the file, I can't clear the file. I've deleted each of the records in the file...

    ItsHer20 pointsBadges:
  • Error message when installing SQL Server 2005

    I have installed SQL Server 2005 and acquired SP2. However, when I continue to install the SAP dialog instance, it gives me the following error: MDB-05036 Error when creating sqldmo SqlServer object What does this mean?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server Data File Storage

    We have a SQL Server with 32GB of RAM, 8 CPU 16 Cores, using SAN. On our production database (1 database only) we have 3 file groups Primary, Core, Index with 1 file in the PRIMARY Group, 16 Files in the Core Group, and 16 Files in the Index Group. Each file group including all data...

    Rick Martinez585 pointsBadges:
  • SQL failed to execute the “ROLLBACK” command

    In the process of querying i made a mistake in an UPDATE statement which affected my "UNIT" field (all UNIT changed to 500). I used the ROLLBACK but dit not work. Please help

    Okappaw55 pointsBadges:
  • Select statement in asp.net

    How can i use ms sql select statement with where clause in asp.net

    Pioneerinaspnet15 pointsBadges:
  • Connecting to a SQL Server 2005 database through LAN

    I am trying to connect to my SQL server 2005 database on my server. I open SQL server 2005 management studio and try to set the server name to IPADDRESS\SERVER3 (the name of the server) but this doesnt work. I have also tried with connection strings in VB and these dont work either

    Providence15 pointsBadges:
  • Combining 2 queries in SQL 2008

    I am having a little trouble combining the following 2 queries into a single nested statement (if indeed it's possible). Can anyone assist? Query 1: SELECT Eff_Date, CoNum, Brandname, COUNT(Brandname) AS CountOfBrandName FROM dbo.Products WHERE (Eff_Date BETWEEN '1/1/2010' AND '12/31/2010') GROUP...

    DavidHa!!110 pointsBadges:
  • Selecting Field Defined as L in SQL Server

    I am building 4 part SQL select across 4 files using union alls. All 4 files have a date field which is one of the fields I am selecting. My problem is that on one file the date field is defined as L type where the other three files have a date field defined as 8S 0. Since the field I am selecting...

    Canuhp235 pointsBadges:
  • How I can automated process load xml file to SQL server 2008?

    Hello!

    Ana6335 pointsBadges:
  • SQL Server and AntiVirus

    We have many sql server running on seperate boxes, the Network team wants to install antivirus software on all the sql servers. Is that a good idea? Why?

    Rick Martinez585 pointsBadges:
  • Pagination in SSRS 2005 Reports

    I have several reports in SSRS 2005 that consist of a "report header" area with various textboxes (note this is in the body of the report, not a page header) and then a table -- sometimes a very long table (and then a "report footer" area with some more textboxes, and also a bona fide page footer...

    Groberts3145 pointsBadges:
  • Web development course and Microsoft qualifications

    I recently left my job in the UK as a project manager from a niche organisation that provides business services to public service bodies. I am thinking of sharpening my skills by doing some web development training and getting certified with some Microsoft and Adobe products and moving into Web...

    Tobeeornot25 pointsBadges:
  • TWO Free IT Books: Multicore Application Programming & The Rails 3 Way

    We've got two free IT books this week. Since nobody won last week's The Rails 3 Way, we're piggybacking the books together. Both contests are currently happening, and winners will be announced Monday, March 7, 2011. The second free IT book, Multicore Application Programming, is a comprehensive,...

    MelanieYarbrough6,345 pointsBadges:
  • MySQL vs SQL server

    If I was going to get some web pages designed to interact with a database on my server would I be better using MySQL or SQL small business server? Is there a huge difference in what they're cabable of or does it just change what front-end you use? Why would I need a WAMP stack and what exactly do...

    Katy20 pointsBadges:
  • Open PDF with parameters

    I want to open a PDF file with a #page= parameter. This works if I create a fetch link with the full folder string - http://ecm.domain.net/ecm/livelink.exe/fetch/2000/115075//GUIDE.pdf?nodeid=9948579#page=4 ...but does not work if I "Open" the shortlink -...

    Luvdove10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following