I need to set up a named set within a cube selecting only 2 members, can anyone out there provide me with a simple piece of MDX that will achieve this?
I did not took backup for a database.My colleague had mad some changes to some Stored procedures and I want to roll back to the original codr.Since he did not used the begin transaction i am not able to rollback the changes.>How can I get back to my original code?
What is the use of database index (apart from fast searching of records);What is use of composite key ?
Latest Answer: SQL profiler is a graphical tool that allows system administrator to monitor in an instance of the SQL Server.Use of SQL Profiler:Monitor the performance of an instance of SQL Server.Debug Transact-SQL statements and stored procedures.Identify slow-executing ...
Latest Answer: Create [shared/public] database link connect To identified by using Any problem Don't hesitate write to rahultripathi@myway.com ...
Latest Answer: Oracle is more secure than MS Access.Oracle stores unlimited data while MS
Access is not.Sequence creation is not possible in MS Access.Oracle is scalable but not
MS Access. ...
What is the difference among "dropping a tableâ€,†truncating a table" and deleting all records" from a table?
Latest Answer: Varchar2 in Oracle is equal to varchar in SQL Server. There is no varchar2 data type in SQL Server ...
Latest Answer: View is a logical partition of one or more table in horizontally(by putting condition) or vertically (by including selected columns). View can be used to update table, provides security mechanism. view defionition(qurey) stored as ...
Latest Answer: Hints are options or strategies specified for enforcement by the SQL Server 2005 query processor on SELECT, INSERT, UPDATE, or DELETE statements. The hints override any execution plan the query optimizer might select for a query. ...
View page << Previous 4 5 6 7 [8] 9 10 Next >>
Go Top
