bigator

Archive for the ‘Interview QA’ Category

MDX and DAX Query Formatter …. is back :)

Hi Friends, Just to share with you quickly that “MDX and DAX Query Formatter” site is back online. Here is the link: http://formatmdx.azurewebsites.net/ Thanks, Khilit

bigatorMay 13, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , ,  Â· Posted in: Business Intelligence, Data Mining, DMX, General, Interview QA, MDX, Query Tuning, SQL Server 2012, SSAS

Recover Backed-up query files in SQL Server Management Studio

Hi guys, I just want to share quickly very handy tip regarding your SQL query sessions. When you open SQL queries in SSMS, you generally go on and work in newly opened pane/window but sometimes dont save that work. SSMS by default saves them in the event of pre-mature closure or crash of SSMS or [...]

bigatorMay 7, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , ,  Â· Posted in: Business Intelligence, General, Quick Tips, SQL Server 2012, Tutorial

Retrieving id of inserted record: What to use @@IDENTITY or SCOPE_IDENTITY() or OUTPUT

Hi guys, This seems very basic information but need to know properly. Issue: I need to find out or have the id of the records which I inserted in table. Analysis: This requirement seems very simple but there could be various cases where you would not get the correct id just by using @@IDENTITY function. Think [...]

bigatorFebruary 6, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , , , ,  Â· Posted in: Business Intelligence, Free, General, Interview QA, Quick Fix, Quick Tips, Script, SQL Server, SQL Server 2012, SQLServerPedia, T-SQL, Training, Tutorial

The Story of Precision, Scale, and Length in SQL Server

Hi guys, Did you ever faced issues with BIG mathematical figures – related to either overflow or any  other arithmetic errors. This may be applicable to SQL arithmetic operations or arithmetic  operations you do with SQL table in SSIS etc. Well, check 1 more time, if you have any issues in your database design related [...]

bigatorJanuary 28, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , , ,  Â· Posted in: Business Intelligence, Free, General, Interview QA, Quick Fix, Quick Tips, Script, SQL Server, SQL Server 2012, SQLServerPedia, SSAS, SSIS, SSRS, T-SQL, Tutorial

Tracking Down Ghost Characters: WHERE Clause Does Not Work Properly In T-SQL Query

Hi guys, I would like to share an experience with you when I was working on 1 SSIS related issue. Scenario was: I have to exclude some records from Table A by matching some keys of Table B.  Table A Year Month CustomerCode <Extra Columns> 2012 JAN CX1000   2012 JAN CX2000   2012 JAN [...]

bigatorJanuary 25, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , , , , , , ,  Â· Posted in: Business Intelligence, Free, General, Interview QA, Quick Fix, Quick Tips, Script, SQL Server, SQL Server 2012, SSIS, T-SQL, Tutorial

MSSQL: Find total records of each Table in given Database

hi guys, i wanted to do a quick post on how you can find total number of records in each table of the database. here is the script you can use: USE <Your Database Name> GO ;WITH CTE_DATABASETABLESIZE (DATABASENAME, SCHEMANAME, TABLENAME, TOTALROWS) AS ( SELECT  DB_NAME(), SCHEMA_NAME(SO.UID), SO.NAME, SI.ROWS FROM  SYSOBJECTS SO  INNER JOIN SYSINDEXES [...]

bigatorJanuary 23, 2013 · bigatorKhilitchandra Prajapati · bigatorOne Comment
bigatorTags: ,  Â· Posted in: Business Intelligence, General, Interview QA, SQL Server, SQL Server 2012, SQLServerPedia, SSAS, SSIS, SSRS

Microsoft SSAS Solution: Cube Design Considerations

Hi guys, today i read James Serra’ post – whether 1 single BIG cube is good as comapred to multiple small cubes. Check out the advantages and disadvantages with both design approaches. he made a pretty nifty list of both of these. i would also recommend you to read this post. here is the link: [...]

bigatorJanuary 16, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , ,  Â· Posted in: Business Intelligence, General, Interview QA, Quick Fix, SQL Server, SQL Server 2012, SSAS

User ‘Domain\User’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

Hi guys, its seems like this issue have been faced by many prople. i have checked the solutions on web and found that not all answers contains the complete solution. so decided to put 1 complete solution here. in most of the places, you will find answers like… Run IE as Administrator -> Open Report [...]

bigatorJanuary 16, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , , ,  Â· Posted in: Business Intelligence, General, Interview QA, Quick Fix, SQL Server, SQL Server 2012, SSRS

What is OLAP Database ? What is FASMI?

Hi guys, i was reading an article and came across this term “FASMI“. i have done a little bit of RnD to find out its head & tail. This is what it means: FASMI is an acronym of “Fast Analysis of Shared Multidimensional Information“. A database when called “OLAP Database” if it satisfies following FASMI [...]

bigatorSeptember 7, 2012 · bigatorKhilitchandra Prajapati · bigator3 Comments
bigatorTags: , , , , , ,  Â· Posted in: Business Intelligence, Data Mining, DMX, General, Interview QA, MDX, Pivot Table, Power Pivot, Query Tuning, SQL Server, SQL Server 2012, SSAS, Training, Tutorial

E-Book Gallery for Microsoft Technologies

Hi guys, good morning !!! here is the list of cool FREE E-Books from Microsoft Press.

bigatorSeptember 7, 2012 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , , , , , , , , , , ,  Â· Posted in: Business Intelligence, E-Book, Free, General, Interview QA, New Features, Quick Tips, SharePoint, SQL Azure, SQL Server, SQL Server 2012, SSIS, SSRS, Training, Tutorial, Windows


bigator