How to Generate Sequence without using Ranking functions in SQL Server?
Ans: Spose you have a temp table with only one column 'A' as above, Now you can use following query to gen…
01:06Ans: Spose you have a temp table with only one column 'A' as above, Now you can use following query to gen…
Vikas 01:06Spool operator scans the input and places a copy of each row in a hidden spool table that is stored in the tempdb da…
Vikas 11:27Join is used to display results(combined rows) from two or more than two table . Below are the types of joins are: …
Vikas 10:25Data base Testing is segmented into below four different categories. Data validity testing Data integrity testing …
Vikas 10:18Syntax errors Execution errors Logic Errors Syntax errors: The syntax errors are those that appear as you ty…
Vikas 10:05When custom software is built for a customer, a series of acceptance tests is performed to allow the customer to valid…
Vikas 09:59Integration testing (sometimes called I & t integration and testing) is the software testing phase in which indivi…
Vikas 09:53When a test is performed and a defect has been identified, it is the duty of the developers to first locate the defect…
Vikas 09:51In programming, a unit test is a way to test the correct functioning of a code module. This is to ensure that each of …
Vikas 09:46Software testing is the process of verifying and revealing the quality of a software product. They are used to identif…
Vikas 09:44Verify: It consists of verifying the implementation of the requirements. This involves providing objective evidence t…
Vikas 09:36Dirty reads occur when a transaction is allowed to read a row that was modified by another transaction that has not ye…
Vikas 09:01Evaluate how applications work when real activities are implemented. Perform load tests on SQL scripts, PL / SQL, T-SQ…
Vikas 08:57Scalability is a performance benchmark that investigates a system's ability to grow by increasing the workload per…
Vikas 08:53Database testing objective is to be ensure that access methods and processes work properly and without causing data co…
Vikas 08:32Create your own queries: In order to test the operation in a database in a proper and accurate manner, first a test…
Vikas 08:23Data mapping in a database: It should be ensured that regardless of the visual (front-end) part of the application,…
Vikas 08:16C : Create - When the user "saves" any new transaction or information to the database. A : Retrieve - When …
Vikas 08:13Atomicity, Consistency, Isolation and Durability(ACID) are a set of properties necessary for a set of instructions to …
Vikas 08:02Click here for answer
Vikas 07:53AnyDbTest DBFit DBUnit NDbUnit SQLUnit TSQLUnit(for testing T-SQL in SQL Server)
Vikas 07:49Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational m…
Vikas 07:45Gather database requirements Create test scenarios against each requirements Test schema data and test scenarios…
Vikas 07:39The Query Parameter will filter your data in the DataSource level. We can use these parameters in dataset of SSRS repo…
Rohit 21:52What are Different types of SSRS Reports? There are basically following types of different SSRS Reports-- •Param…
Rohit 21:19In April 2013, Sisense introduced an alternative to in-memory technology called In-Chip analytics, designed to maximiz…
Vikas 00:16What are DataSource and DataSets in SSRS? Benefits Of Shared DataSource and Shared Datasets? If you need to show in…
Rohit 00:03Sisense works with Hive–the data warehouse system designed for Big Data analytics. works well, but it is a developer t…
Vikas 00:03As you know with previous generation in-memory BI software the amount of data that you can analyze is limited by the n…
Vikas 00:01Most data visualization and business intelligence tools allow you to visually explore data sets. They work well if you…
Vikas 23:58Not at this time, however Sisense only needs to be installed on a centralized Windows machine to pull data from multip…
Vikas 23:49A build is a process that pulls the data from the sources and prepares it to be used in your dashboards. Before you us…
Vikas 23:47The Elasticube Manager is component of the Prism suite that helps you design the Elasticube (connect to tables, build …
Vikas 23:46The Elasticube Manager stores the design of the data schema in a .ecube file. It is not the data itself, but actually …
Vikas 23:44Connecting to data with Elasticube Manager is very easy, and it supports many data source types: Excel files, database…
Vikas 23:43SELECT OBJECT_NAME([PS].[object_id], [PS].[database_id]) AS [ProcedureName], [PS].[execution_count] AS [Procedur…
Vikas 23:27Sisense Architecture The Sisense system is comprised of the following components. Sisense Web Application: T…
Vikas 22:53In today IT world companies had two options for data analytics: complex and pricey BI tools that can handle big and co…
Vikas 23:48Sisense is a BI tool that was developed for all types of user, even those with little or no prior experience with BI …
Vikas 23:44What do you understand by Sisense BI? Why Sisense? What makes it unique? How do I connect to data with Elasticu…
Vikas 23:42SSRS interview Question; What Is SSRS and What reports can we make using SSRS? SSRS is a Server based Report generat…
Rohit 21:24SQL Server interview question asked in TCS interview. Q: What would be the output of following script? An…
Vikas 22:46