• SQL Server Express 2008 with Advanced Services Installation

    I am trying to install this program on a Windows 7 OS, and I'm having a very difficult time. I have a 64-bit computer, but I'm trying to install the 32-bit version (x86) because I only have a 32-bit version at work, and I'm practicing at home what I eventually want to do at work and I want...

    Dataempress115 pointsBadges:
  • How to make a graph always visible when there is no data?

    Hi, I am currently creating a report in SSRS which contains many tables including a graph on one page. The formatting is nice generally, but when there is no data in the graph, everything will be different. So, I am trying to keep the graph always visible to keep the formatting. Is that possible?...

    Zhounan5 pointsBadges:
  • Upgrading from SQL Server 2000 to SQL Server 2005

    We want to upgrade our SQL Server 2000 to SQL 2005. What should we watch out for and what is the actual procedure for the upgrade? Will it require another server or can the upgrade be done in place?

    NewnanIT1,110 pointsBadges:
  • SQL Server Express 2008 w/Tools vs. Advanced

    Hi, I installed SQL Server Express 2008 w/Tools on my Windows 7 OS. I just found out that if I want to download the AdventureWorks database .msi from codeplex, I need SQL Server Express 2008 w/Advanced Services. Do I need to uninstall the SQL Server Express 2008 w/Tools and install SQL Server...

    Dataempress115 pointsBadges:
  • How to update one table field with the help of more than one table in SQL Server 2000

    How to Update one table field with the help of more than one table

    Dharm19975 pointsBadges:
  • SQL Server Reporting Services (SSRS) Reports 2005

    How to include to Input parameters in the report, so as to help users identify the parameters on which the report was run.

    YogeshNT5 pointsBadges:
  • SQL Server 2005 Express

    Hi, Is it worthwhile to schedule optimisation job (update stats and rebuild index) on another server so it can be run on a database that was created on SQL Server 2005 Express from an application installation? I know it is probably a good idea to atleast change the autogrowth setting from 1MB but...

    Db23290 pointsBadges:
  • Infinite recursion in SQL Server 2000

    consider a recursive query in SQL.How to handle infinite recursion to make the query evaluation optimized?

    Gomsbk35 pointsBadges:
  • How to count the common column rows in the table for each column and row…..

    I have a table and that table have columns like d1,d2,d3,d4....... d1      d2    d3    d4 --------------------------- 200   300   100  300 100   200   101  101 300   ---    300  200 how can i display the output like below...  for each row.... ColumnD1 Count 200    3...

    Paanduranga15 pointsBadges:
  • Trying to Design a Split Database Access 2007/SQL Server Express

    Hi, This post will be long, as I have several questions related to this project, but please feel free to only answer any piece you want, however small. Every bit of knowledge will be helpful. One of the programs at my office is in need of a database. I've been researching this for awhile, and going...

    Dataempress115 pointsBadges:
  • Difference between QM Query and traditional query

    When both a QM Query and a traditional Query are run against a database file with IDENTICAL record selection, the traditional query returns more records. I can only guess that it has to do with a difference in the way each utility handles uncommitted data. It almost looks as if traditional Query...

    slateken230 pointsBadges:
  • Without Using Script in SSIS

    HI!!! how do I alter data in SQL Server table [select, insert and delete] using SSIS Visual Studio without using a T-SQL Script... please help me T_T.... Thx so much... :D

    SSISCaseStudy5 pointsBadges:
  • Production SQL Database has been restored with Old database backup

    Dear Expert, I need your Advice, today in morning i run Symantec backup restore on SQL 2008 server where i overwrite the production Database with Old backup. Is there any way i can retreive the old Database until yesterday. i dnt have any backup of New database which i accidentally overwritten.  ...

    Aleem60015 pointsBadges:
  • SQL Server I/O

    Hello, we have a database that contains three tables. Each table has more than 25,000,000 rows in them. All three tables are in the same file group, array, and drive. Our daily Avg physical I/O is 1,000,000. Our users are complaining that the system is slow daily. Everytime a user writes to any of...

    Rick Martinez585 pointsBadges:
  • Using SELECT with LIMIT clause on a physical file

    Hi - I'm new to PHP & SQL and wanted to know if you can use mysql SELECT with the LIMIT clause on a iseries physical file in order to do pagination. Thanks for the help.

    jakusza30 pointsBadges:
  • SQL RPGLE – How to override data set data structure at run time

    I currently have an SQL RPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to make this...

    NarkedDiver20 pointsBadges:
  • How to find Windows Operating system values for SQL database: OSId, Descr, Edition, ver, arch,

    I'm managing a large group of virtual machines using SysCenter Virtual Machine manager (SCVMM). I want to add data to the SQL Database for SCVMM application so that additional operating systems will be available in the properties of the SCVMM application. I know how to do the statements which add...

    007jet5 pointsBadges:
  • Translate Ruby Script to SQL Query?

    I need help translating a ruby script to SQL query. I'm a SQL noob. Help please. [em]here is the script.[/em] require "rubygems" require "ruport" SQL = <<-EOS SELECT     tv.ApptDate, tv.PatName, tv.PatFirst, tv.PatLast, tv.Phone, tv.ApptTime, tv.Provlast, tv.ProvFirst, tv.ProvTitle,...

    Transom3245 pointsBadges:
  • Building a VB application

    I'm about to create a project using VB.net and Microsoft SQL Server. It's not difficult when i'm running it on 1 single computer. The problem is, this application should be located in 1 server and accessible through the network. Is there something different i have to do, or i only need to add the...

    ALittleKid40 pointsBadges:
  • Limitations of a small business server

    What are my limitations for using a small business server as opposed to a standard version? What can I not do from SBS?

    NewnanIT1,110 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