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 >>

SQL query behind an SSAS datasource view
Hi,   Is there a way to get the SQL query behind an SSAS datasource view?   Thanks, Bryan

asked 6/25/2015 12:57:46 AM
by Bryan
0 answers

SSIS Package with dynamic source and multiple tables in each source and dynamic staging
Hi Guys, I have to import multiple table from different servers and once I import it should load to my target table but first my package should create a staging table for all those target tables and then load into target table from staging. Now when I ru

asked 6/24/2015 6:35:25 AM
by Rajeev Kumar
1 answers

agregar observaciones/comentarios en tablas de sql server 2008
Buena tarde, se me ocurrio agregar comentarios u observaciones en algunas tablas de sql existe una forma de agregar mis comentarios en algunas tablas 

asked 6/23/2015 5:45:00 PM
by fernando
0 answers

Want to hide the Database Structure, Schema & Objects In SQL Server & SQL Azure
Hello All,  I have a secnario in my project, we are in process of developing a tool & sell to customers , in this i want to hide the database schema & structure to the client & Clients DBA is there any solution in it from the database en

asked 6/23/2015 1:47:51 AM
by Chandru Shekar
0 answers

Divide Total Rate by Number of Records
my table includes detailed records with total Rate repeated in each record:   CREATE TABLE Table1 ( Providerid varchar (6) NOT NULL, Providername char (30) NOT NULL, Clientid varchar (15) NOT NULL, Rate            

asked 6/22/2015 3:23:07 PM
by helal
0 answers

Error event id : 17066 and 3624 while restoring Diff backup.
Hi Friends,   I am getting the following error while restoring the Diff back up after restoring the Full backup in Norecovery mode.   I am unable use dbcc checkdb as the database in restoring db.   Issues happens only in three instanc

asked 6/21/2015 9:02:19 AM
by Swami
0 answers

How to allow three types of parameter input (blank, one, multiple comma separated)
Hi I am having some trouble with my Microsoft SQL Server Report Builder. It is a simple matrix report with one dataset for the output and one parameter for the input. I’m trying to allow three different types of data input into my parameter: 1. 

asked 6/18/2015 7:19:04 PM
by Ryan
0 answers

Insert records performance to SQL server table
If I have a tabel with millions of records and another table has empty records I like to insert 3000 records into both table which one will be faster insertion ?and why will be faster ? I am confuse about that please answer me .Thanks

asked 6/17/2015 3:04:31 PM
by Ziaul
1 answers

Take a backup of sql jobs (Scheduled Jobs) through TSQL
I have 5 servers, i am creating a scenario if one of the server is down then I can restore the database and run the jobs in another server. Through scripts I am taking the database structure(table, views and storedprocedure) of all server and maintaining

asked 6/17/2015 8:35:50 AM
by mahesh
1 answers

Script All Server Level Objects to Recreate SQL Server article
Script All Server Level Objects to Recreate SQL Server i have vs2010 and can not use the download you supplied in the article. apparently you used a newer version of vs.  is there a way that i can use the code provided ?

asked 6/16/2015 10:56:44 PM
by RagTopMan
1 answers

Error en BCP - Error en la secuencia de función
Buenas tarde he realizado un procesimiento almacenado para exportar unos registros de mi base de datos a archivo de texto plano en mi servidor, pero cuando ejecuto el procedimiento almacena me manda el siguiente error a que se debe el error :   SQL

asked 6/16/2015 5:14:01 PM
0 answers

Calculate number of groups and group size with multiple criteria
My data looks like this: Date Clientid    BegTime EndTime   Minutes  NoofGp   GrpSize 5/6/2015 1 1030 1200 90   Grp1   5/6/2015 2 1030 1200 90   Grp1   5/6/2015 4 1030

asked 6/15/2015 1:07:27 PM
by Helal
0 answers

Sir,   Hoe to deplay SSIS-2012 Pakage using visual studio for SQL SERVER. 

asked 6/15/2015 8:31:24 AM
by Ankit Jain
1 answers

i'm going to delete the value in database useing sql DELETE command.   but i got the error message is ""<<<The DELETE statement conflicted with the REFERENCE constraint "FK_SecEquipbyPlant_SecEquipList". The conflict occurred in database "

asked 6/15/2015 6:09:02 AM
by gokulkannab
1 answers

Delete SSIS Packages with T-SQL - can this safely be done?
Can Delete SSIS Packages with T-SQL be safely done, if so, what is the code?  

asked 6/11/2015 3:36:38 PM
by Richard Peninger
2 answers

Maintenance Plans and AlwaysOn Availability Groups
We have recently gone live with SQL Server 2012 R2 SP2 AlwaysOn Availability Groups.  When running maintenance plans on the secondary database, they fail.  I'd like to put a check in to not run the maintenance plan if it is not the primary datab

asked 6/11/2015 8:48:14 AM
by Scott Canaan
1 answers

Stop and Start Logshipping Jos
  I am running sql server 2008 R2 in my Live environment and also have configured an secondary sql server containing my Primary server databases with restoring mode. Primary server shipping databases logs files to secondary server with a delay of

asked 6/11/2015 3:40:17 AM
by Sohaib
1 answers

Manage multiple SSIS versions 2012/2014 on same machine
I have a SQL Server 2012 SP1 instance installed with Integration Services 2012. I just recently installed SSIS 2014. The 2012 version has both packages stored in SQL Server and the Integration Catalog Store. When I  open SSMS 2014 and tell it to co

asked 6/10/2015 1:03:50 PM
by mkal
0 answers

bcp sql server 2008
Buen dia, estoy creando un bcp le acabo de agregar encabezados con un union hasta ahi va todo bien, el problema es cuando lo ejecuto me sale el siguiente error "Query hints exceed maximum command buffer size of 1023 bytes (1227 bytes input)." como puedo a

asked 6/9/2015 12:56:30 PM
by fernando
1 answers

calculate no.days from two date's values retrieving from two tables using cursor.
hello i'm trying to retreive date value from two different tables to calculate number of days between these two date's values Table 1 : Account (ActNumber, Name, Status, DateOpen, type). Table 2 : Transaction ( TransNumber ,Actnumber ,DateTransact

asked 6/6/2015 5:00:49 AM
by hams101
1 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-2016 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.