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? Thanks, [...]

Answer Question   |  October 5, 2010  8:52 AM
SQL Server Reporting Services, SSRS, SSRS Performance, SSRS reports

SQL Server Profiler
What numbers are considered high when using sql server profiler for reads, writes, and duration

Answer Question   |  October 8, 2010  10:00 PM
SQL, SQL 2005, sql 2005 Performance Issues, SQL Profiler, SQL Server, SQL Server 2005

Parameter in select statement
Hi, I need to pass a parameter into a stored procedure which values are dynamic always. Executing a variable which having the Select statement. Following query working fine. BEGIN DECLARE @strQuery NVARCHAR(MAX) DECLARE @CountryId INT DECLARE @CityId INT SET @CountryId = 2 SET @CityId = ‘ AND CityId IN (23,45,85,86)’ SELECT @strQuery= ‘SELECT VendorId From [...]

Answer Question   |  October 15, 2010  9:31 PM
SELECT statement, SQL Parameters, SQL statements, T-SQL

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 Express 2008 w/Advanced [...]

Answer Question   |  October 4, 2010  3:18 PM
.MSI files, AdventureWorks, SQL Server 2008, SQL Server 2008 administration, SQL Server Express, Windows 7

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?

Answer Question   |  October 4, 2010  2:29 PM
SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2005 upgrade, SQL Upgrades

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

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.

Answer Question   |  October 4, 2010  12:06 PM
input parameters, Parameters, SQL Server, SQL Server reporting, SQL Server Reporting Services, SSRS, SSRS reports, SSRS Reports 2005

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

Answer Question   |  October 4, 2010  10:25 AM
SQL Server 2000, SQL Server tables, SQL Server Updates, SQL tables

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

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 “sees” uncommitted changes whereas Query Manager [...]

Answer Question   |  September 29, 2010  7:01 PM
Database Files, Query, Query Management Query, Query Manager

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 100     3 300     4 Please help me on this,…………….i am new to the [...]

Answer Question   |  October 1, 2010  5:51 PM
SQL, SQL 2008, SQL Column Headings, SQL Server 2008

SBS monitoring
Hello We have a customer running SBS 2003 sp2. We can’t access the monitoring and reporting through server manager. When Monitoring and Reporting is clicked it just displays a – The Webpage cannot be found HTTP 400 page and when Setup Monitoring and Reports is clicked an error box comes up reading: The wizard encountered [...]

Answer Question   |  November 22, 2010  12:47 PM
MSDE 2000, SBS 2003, Server management, Server monitoring, Small Business Server, Small Business Server 2003

MSQL Auditing
Hello. I’m dot.net developer, and i’m working a lot with MSQL. My current task is when some user executes select query on database, i should ”catch” the query data. What do i mean is if select query is “select * from UsersTbl where UserID = 5″, i have to get  ’5′. Does somebody have any idea where to start??? Thanks [...]

Answer Question   |  April 9, 2011  8:25 AM
Auditing, dot.net, MySQL, MySQL query, SQL, SQL audit, SQL Query

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

Answer Question   |  October 2, 2010  6:52 AM
Query optimization, Recursion, SQL Query, SQL query optimization, SQL Server 2000

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 what about [...]

Answer Question   |  October 2, 2010  6:29 AM
SQL 2005, SQL Jobs, SQL Server 2005, SQL Server 2005 Express, SQL Server Express

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…

Answer Question   |  September 27, 2010  2:05 AM
Scripting, SQL Server tables, SQL tables, SSIS, Visual Studio 2005

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.   Please help me

Answer Question   |  September 27, 2010  4:33 PM
Exchange, SQL, SQL 2008, SQL Database, SQL Server 2008, Symantec, Symantec Backup Exec

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 thos [...]

Answer Question   |  September 24, 2010  8:36 PM
Average Disk Queue Length, SQL, SQL Server, SQL Server 2005

How to recover the deleted database using transaction log file?
Hello all u witty people! I am working for a pvt. corporate company. We are using Windows 2003Server as our OS and SQL Server. Earlier this morning, i was taking the back up and as my hard disk ran out of space, so it showed me an error message stating that there was not much [...]

Answer Question   |  October 31, 2011  4:51 AM
Data Recovery, SQL Log Files, SQL Server, SQL Server transaction logs, Windows, Windows Server, Windows Server 2003, Windows Server 2003 Backup

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 the data to the database table and [...]

Answer Question   |  September 23, 2010  4:28 PM
Operating system Values, OSID, SQL Server database, Systems Center Operations Manager, Windows, Windows Server 2008, Windows Server 2008 R2