sqlsuperfast.com
SQL Superfast | Data Warehouse
http://www.sqlsuperfast.com/category/Data-Warehouse.aspx
It's all about SQL! Tips, tricks, articles, code and comments. 17 March 2011 20:03. What is Data Warehouse? Is data warehouse testing important? Following questions will answer the question. Are decisions based on correct data? Do organization and its employees have sufficient confidence in the new system? How can organization be sure there are no anomalies in the huge amount of migrated data from source to data warehouse? Does it comply with all organization needs? Challenges in Data Warehouse Testing:.
sqlsuperfast.com
SQL Superfast | T-SQL to get string between two strings
http://www.sqlsuperfast.com/post/2013/07/17/T-SQL-to-get-string-between-two-strings.aspx
It's all about SQL! Tips, tricks, articles, code and comments. T-SQL to get string between two strings. 17 July 2013 09:17. Below is the user defined function created in SQL Server to find the string between two strings. CREATE FUNCTION dbo.udf GetStringBetween2Strings ( @String varchar(max), @FirstString varchar(256), @SecondString varchar(256) ) RETURNS VARCHAR(max) AS BEGIN DECLARE @FirstPosition int, @SecondPosition int SET @FirstPosition = CHARINDEX(@FirstString,@String) LEN(@FirstString) SET @S...
sqlsuperfast.com
SQL Superfast | All posts by admin
http://www.sqlsuperfast.com/author/Admin.aspx
It's all about SQL! Tips, tricks, articles, code and comments. Use NOT IN operator carefully. 25 May 2014 20:50. Whenever you use NOT IN operator you will have to be more conscious. Following example will explain why we need to be careful while using NOT IN operator. 0 rows will be returned when you execute the above statements. And this not the correct answer. This is because ultimately NOT IN operator is equivalent to. NOT (Language = English OR Language = Spanish OR Language = NULL). 17 July 2013 09:17.
sqlsuperfast.com
SQL Superfast | General
http://www.sqlsuperfast.com/category/General.aspx
It's all about SQL! Tips, tricks, articles, code and comments. Use NOT IN operator carefully. 25 May 2014 20:50. Whenever you use NOT IN operator you will have to be more conscious. Following example will explain why we need to be careful while using NOT IN operator. 0 rows will be returned when you execute the above statements. And this not the correct answer. This is because ultimately NOT IN operator is equivalent to. NOT (Language = English OR Language = Spanish OR Language = NULL). 17 July 2013 09:17.
sqlsuperfast.com
SQL Superfast | Definition
http://www.sqlsuperfast.com/category/Definition.aspx
It's all about SQL! Tips, tricks, articles, code and comments. 19 February 2011 11:15. Dimensions are often recycled for multiple applications within the same database. For instance, a "Date" dimension can be used for "Date of Order", as well as "Date of Delivery", or "Start Date, End Date. these dimensions are called as a "role-playing dimension". 7cd19bcb-f980-44be-8d0c-0be3b5a6e1c3 3 3.0. Tags: Role playing dimension. What is Role playing dimension. 19 February 2011 11:12. What is Degenerate Dimension.
sqlsuperfast.com
SQL Superfast | Data Modeling
http://www.sqlsuperfast.com/category/Data-Modeling.aspx
It's all about SQL! Tips, tricks, articles, code and comments. 23 February 2011 10:31. Modeling is an efficient way to represent, communicate organization needs. Modeling is an information provided to the members of an organization to understand business and its rules. Business Process Modeling is an efficient way to represent the business processes, activities, main entities in graphical form. Below figure indicate typical busicess process model. Badffbc1-03fb-4a56-88c4-15c27cc99e38 0 .0. Logical and Ph...
sqlsuperfast.com
SQL Superfast | Use NOT IN operator carefully
http://www.sqlsuperfast.com/post/2014/05/25/Use-NOT-IN-operator-carefully.aspx
It's all about SQL! Tips, tricks, articles, code and comments. Use NOT IN operator carefully. 25 May 2014 20:50. Whenever you use NOT IN operator you will have to be more conscious. Following example will explain why we need to be careful while using NOT IN operator. 0 rows will be returned when you execute the above statements. And this not the correct answer. This is because ultimately NOT IN operator is equivalent to. NOT (Language = English OR Language = Spanish OR Language = NULL). SQL Server Tips a...
sqlsuperfast.com
SQL Superfast | SQL Server Analysis Services
http://www.sqlsuperfast.com/category/SQL-Server-Analysis-Services.aspx
It's all about SQL! Tips, tricks, articles, code and comments. MDX - What is Set? 14 March 2011 11:49. Is a collection of tuples which defined using same dimensions, both type and number. Set is enclosed within curly braces { and }. following is the example of set based on Adventure Works sample cube. Tuples ([Customer].[Country].[India]) and ([Customer].[Country].[France]) are from exact same dimension. So collection of such tuples are valid Set. 439e45b9-c4ac-4c32-84e7-60045f9dc2b8 0 .0. SQL Server Par...
sqlsuperfast.com
SQL Superfast | Archive
http://www.sqlsuperfast.com/archive.aspx
It's all about SQL! Tips, tricks, articles, code and comments. SQL Server Analysis Services. SQL Server Tips and Tricks. Organize Data Warehouse Objects. Types of Data Warehouse Dimension. Use NOT IN operator carefully. T-SQL to get string between two strings. Load Delimited CSV file using ACE Driver. EOMONTH () Function in SQL Server Denali. CHOOSE() function in SQL Server Denali. AdventureWorks Sample Databases for SQL Server Denali. SQL Server 2008 R2 Cumulative Update 5 released. MDX - What is Set?
sqlsuperfast.com
SQL Superfast | Download PowerPivot V1
http://www.sqlsuperfast.com/post/2013/08/26/Download-PowerPivot-V1.aspx
It's all about SQL! Tips, tricks, articles, code and comments. T-SQL to get string between two strings. Use NOT IN operator carefully. 26 August 2013 20:32. Download Power Pivot V1. Download Power Pivot V2. Donload Power Pivot V1 32 Bit - Zip Version. 3bbe5417-2e7b-4da9-a2ac-f5a729a96b2a 0 .0. Tags: Download PowerPivot V1. AdventureWorks Sample Databases for SQL Server Denali. AdventureWorks Sample Databases for SQL Server Denali are available for download. Whats new SQL Server Denali SQL Server 2011.