Learn more about SQL Server tools


Tutorials          DBA          Dev          BI          Career          Categories          Events          Whitepapers          Q&A List          Join

SQL Server Question and Answers

Ask a SQL Server Question

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

cube creation in ssas
Hi all I need to create 3 fact table in a cube with dimensions ?? is it possible . What are the steps to do. can you guide me through it or send a link so that i can learn it.   Thanks Ranjan 

asked 8/24/2015 10:06:35 AM
by ranjan
0 answers

SSIS - update dimension tables
Hello guys,   The question I`m going to ask might be very silly but as per my knowledge i need a solution for the question which    i couldnot able to find in the google.   Question is:   I have staging database where i ge

asked 8/22/2015 5:21:30 AM
by srikanth
0 answers

Incremental Cube Load in SSAS cube
Hi all, How to increment a data from one database to another database in a cube. Thanks Ranjan DS

asked 8/21/2015 5:45:29 AM
by ranjan
0 answers

SQL SERVER 2012 Job agent
Hi all,through job agent can i transfer the data base from one warehouse to other? if i can do...how can i. what are the stepsThanksRanjan DS

asked 8/20/2015 10:17:49 AM
by ranjan
1 answers

  Dear All,   Greetings of the day,   i want to share with you my one problem i hope all of you provide me the solution. i am using cloud infra, inside this infra i make the virtual machines of windows with mssql 2008and deliver the

asked 8/20/2015 5:09:21 AM
2 answers

Protect our backed up databases with password
We are using SQL Server 2014, all our databases will be automatically backed up as per schedule. Now need to protect our backed up databases with password. We have tried below queries: BACKUPDATABASE Prod121 TODISK='C:\Prod121.BAK'WITH MEDIAPASSWORD ='p@

asked 8/20/2015 1:43:52 AM
by Ramchinni
1 answers

Reg Log Backup LSN chain
Hi, As per my Understanding SQL Server Maintain Log Backup Chain depends upon full backup/last log backup. When ever we took Full backup a new LSN chain will start and next log backups will depend on this full backup. For Ex: Full Backup---6 AM TLOG Ba

asked 8/19/2015 7:31:08 AM
by Pradeep
3 answers

Hi Xiong,   Now the task succeded. I will get u the msg what i am getting for success and for failure. -------------For failure------------------------------ MessageThe job failed.  The Job was invoked by User WUNDERWEAR\dd1.  The last

asked 8/19/2015 6:10:10 AM
by ranjan
0 answers

Sending out SSRS Report
I'm in a SQL 2K5 envirornment and I have subscription reports which go out to my users, I would like to change that so they will get an email message that will point them to a link of the report (instead of sending out serveral reports), however when they

asked 8/18/2015 8:41:22 PM
by Kevin
0 answers

if a server performance is slow? how can troubleshoot a problem?

asked 8/18/2015 5:01:49 AM
by raj
1 answers

System Database Rebuild Process
Hi Jugal, Im New to Database and i searched for the rebuild process for system databases i didn't get any usefull info, can you please write a article for the system databases rebuild process  

asked 8/18/2015 1:12:48 AM
by Ramchinni
1 answers

How does an SQL Program look like, for a client
Hello, I have a really stupid, yet important question to ask here. I am a Computer Sciences student, and having not learned anything about Database yet, I have a friend's father who wants me to make him a program to a database for his clients.He basicall

asked 8/17/2015 5:58:14 PM
by Patrick Y
1 answers

Table Design - monthly goals for multiple units
Hello, I need to store the monthly goals for 50+ business units by year. (UnitID, Year, Month, Goal)  These numbers should be static and new goals inserted yearly.  The data will be used in reports to display % to goal and other calculations. &

asked 8/17/2015 12:46:06 PM
by Darwin
1 answers

What are the possible errors found at the time of restoration of database.  

asked 8/16/2015 3:04:17 AM
by Jiten
1 answers

The operating system returned error 665(The requested operation could not be completed due to a file system limitation)
Got this error message on a ~500GBs database DBCC CHECKDB operation: Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be

asked 8/14/2015 12:36:42 PM
by Elise5000
0 answers

Schema, Pranet_object onwership, and child_object ownership
All, This is a project for a Security Class @ a California State University.  Resources VERY limited for help. Trying to gather SQL Server information across a network.  Specifically, what users own which schemas, which schemas conta

asked 8/13/2015 5:58:16 PM
by Elise5000
3 answers

Changes in parameter value on reports in BIDS are not reflected when deployed to website
I have numerous reports built in SSRS 2008 and I need to change the value in the parameters.   The changes done in Bids are saved and the reports run fine from Bids when the new values.   However, when I deploy those reports, the

asked 8/13/2015 3:31:20 PM
by Cindy Filler
0 answers

Object Ownership: Triggers
Apparently you can't change the owner of a trigger using ALTER AUTHORIZATION OBJECT::.  However, if the trigger is in an owned SCHEMA will changing the owner of the SCHEMA effectively change the owner of the trigger in the SCHEMA?  If so, then d

asked 8/13/2015 11:30:09 AM
by Elise5000
2 answers

Windows Server Cluster and SQL AlwaysOn Avaiabilty Group
Hello, i have a problem with my Windows Server 2012 R2 Cluster. I have two nodes of SQL Server 2012. SQL Server was Standalone and use AlwayOn Availability Groups. I Use a File Share Witnees as Quorum. Now when i reboot the Fileserver on which the Fil

asked 8/13/2015 9:50:00 AM
by Alex
0 answers

initial catalog name change as per db name in ssis configuration.
Dear all, in our ssis package migrartion package project. i have faced a problem. our previous version ssis package there are lot of connection manager and we are configed ssis package configuration at that time db name is like ABC_DEPLOY. but after move

asked 8/12/2015 2:04:20 AM
by Subhamay
0 answers

Sponsor Information



Get Free SQL Tips










BI Professionals


Q and A

Today's Tip







Tip Categories

Search By TipID



First Timer?




User Groups

Author of the Year

More Info








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