Learn more about SQL Server tools


SQL Server Question and Answers

Ask a SQL Server Question

Search All Questions:
SQL Server Questions And Answers
<< Previous Page        Next Page >>

How to Alternate Row Background Color in SQL Server Reporting Services Tablix on Grouping row without Details Row in Tablix
Hello SSRS MVPS In the tablix If there is no Details row and Tablix is having multiple Groupings and in this case how do I apply Alternate Row Background Color atleast for one grouping. Please let me if theres is solution or fix. Thanks in Advance

asked 5/9/2015 1:26:36 AM
by Mahesh MSBI
1 answers

data cleansing
at interview asked me about: How do you do data cleansing? please help thanks

asked 5/4/2015 7:52:30 PM
by Debbie C
0 answers

Hi. Recently i have heard about SSIS Excel Refresh Task.It seems like this task has been built to support SQL Server 2012, not SQL Server 2014. At least, after running the installer, the task does not show up in my SSIS toolbox after refreshing, and I am

asked 5/4/2015 7:38:12 AM
by Surender
0 answers

Mantainence plan Always on
Hi all, I've new to always on management, I would like to know if thre is a best practice for configuring mantainence plan on a always on system ( two nodes) or is just running the mainainance plan wizard on both nodes. Thank you very much for help

asked 5/4/2015 4:29:40 AM
by Luca Pozzoli
0 answers

SSRS 2012 Error : Report processing has been canceled by the user. (rsProcessingAborted)
Hi All, When I run the reports from Report Manager getting the error as Report processing has been canceled by the user. (rsProcessingAborted). Also the same error comes when the SSRS reports are called from the Aplication What is the Root Cause o

asked 4/30/2015 1:26:09 PM
by Mahesh MSBI
0 answers

How to script out linked in servers from sql 7.0
How to script out linked in servers from sql 7.0

asked 4/28/2015 5:12:08 PM
by Suresh
2 answers

How to achieve this output using SQL Script?
Table A:   code        aname ----------- ---------- 1           A 2           B 3    &nbs

asked 4/28/2015 4:18:02 AM
by SQL Lover
0 answers

FORMAT STRING is not applied to SSAS calculated member nor measures
I am trying to format a calculated members and measures using "Currency" format string, however this property is not being applied to the value. I've checked other posts related to this issue that mention the problem is only seen while browsing the

asked 4/27/2015 3:54:29 PM
by Alejandro Zuleta
0 answers

SSIS.... i have a table like......sales india    usa   srilanka    pakistan a1       a2      a3           a4 b1       b2      b3    

asked 4/24/2015 8:52:20 AM
0 answers

mdf files to big in SQL server 2005
Hi There,I hope someone can advise me on what to do here.I am running my database on SQL Server 2005. I had created a backup maintance job myself using the  SQL Server Management Studio,when using a maintance plan i set up this to delete files based

asked 4/22/2015 2:09:42 PM
by GregoryGood
1 answers

Sql sorting And searching
HiThe following questions are about "Microsoft SQL server 2008 R2" or newer. I have 125 tables in my database, and they are sorted only by their names. I want the largest table to be first. (the table that has more records.) How can we sort tables by

asked 4/18/2015 9:59:25 AM
by bhgh
2 answers

Powershell scripts for upload only current date text file to sql server from various app server
Hi All,   Powershell scripts for upload only current date  text file to sql server from various app server

asked 4/18/2015 2:27:32 AM
by Subhamay Chatterjee
0 answers

Trouble with a couple SSIS packages in SQL Server 2014
I have a SQL Server 2014 Always On QA environment with 3 nodes running Developer Edition 64-bit with Build version 12.0.2456.0.  I’m having an issue with a couple of packages in QA that has me stumped.  It works fine in production, so I&r

asked 4/16/2015 12:16:15 PM
by Phillip Holtquist
0 answers

Procedure to import data daily on DB1 (table 1) from DB2 (table 1)
  Hi all, I have come across an issue and I need some info. I need to create a procedure to enter data into a table in a database (eg DB1, Table1), but the data will come from another database within the same server (eg DB2, Table X). Can anyone

asked 4/16/2015 11:31:09 AM
by Gieorg
2 answers

SQL Server 2008 Agent Job Failing to connect to an Oracle Database
Dear All,   I am running SQL Server 2008 on a OS Windows 2008 64 bit. I have created a Job that needs to update some tables in an Oracle Database. The data source definition is setup only with a user id where i cannot setuo the sysntax as pa

asked 4/16/2015 8:48:37 AM
by Anibal Lopez
0 answers

Refresh Replicated Database from non replicated database
Sever 1 DB1 = replication is set Server 2 DB1= Same database as DB1 but no replication How to I refresh DB1 in Server 1 from DB1 in Server 2 without intrupting the replication.??? Need Help ASAP

asked 4/15/2015 11:00:33 AM
by jama
0 answers

Error: "The server failed to resume the transaction"
After conversion from Visual Studion 2003 to Visual Studio 2005, we started to get some error related to server transaction. "The server failed to resume the transaction".   What possible reasons can cause this? 

asked 4/15/2015 10:06:53 AM
by Eugene
0 answers

How to execute the below SQL query automatically daily and send the result .xlsx format to an emailDL group
The SQL query is something like this declare @run_date varchar(20), declare @run_date_plus_1 varchar(20), select @run_date = '13 April 2015'   -- change this run date select @run_date_plus_1 = dateadd(dd,1,@run_date) select @run_date,@run_d

asked 4/14/2015 12:58:40 PM
by Rakesh Kumar
1 answers

SSL Certificate
can we logon sql server using SSL certificate? how do sql client connect to sql server using SSL certificate?

asked 4/10/2015 10:45:52 AM
by Rahul
0 answers

Active Directory
Hi Since they have change AD structure i'm getting trouble to make my query work as i wanted. Below is the structure containing two groups one nameed 'Coordination' and the oher 'Administrator' Administrator contain Coordination and both are under OU O

asked 4/10/2015 9:09:08 AM
by Alexandre
0 answers

Sponsor Information



Get Free SQL Tips










BI Professionals


Q and A

Today's Tip







Tip Categories

Search By TipID



First Timer?


Free T-shirt



User Groups

Author of the Year

More Info








Copyright (c) 2006-2015 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.