Bigator - bigator.com - Khilit's Business Intelligence Blog
General Information:
Latest News:
Three Things I’ve Learned From Warren Buffett – By Bill Gates 14 Jun 2013 | 06:52 am
Hi Friends, Just wanted to share with you quickly… a good article by Bill Gates. http://www.linkedin.com/today/post/article/20130612065727-251749025-three-things-i-ve-learned-from-warren-buffett?trk...
MDX and DAX Query Formatter …. is back :) 13 May 2013 | 07:12 am
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
Recover Backed-up query files in SQL Server Management Studio 7 May 2013 | 06:15 am
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 ...
Retrieving id of inserted record: What to use @@IDENTITY or SCOPE_IDENTITY() or OUTPUT 6 Feb 2013 | 08:27 am
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 simp...
The Story of Precision, Scale, and Length in SQL Server 28 Jan 2013 | 01:26 pm
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 opera...
Tracking Down Ghost Characters: WHERE Clause Does Not Work Properly In T-SQL Query 25 Jan 2013 | 03:11 pm
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....
MSSQL: Find total records of each Table in given Database 23 Jan 2013 | 09:38 am
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_DATABASETABLES...
Microsoft SSAS Solution: Cube Design Considerations 16 Jan 2013 | 12:33 pm
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 pret...
User ‘Domain\User’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) res... 16 Jan 2013 | 11:03 am
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 solu...
Quick Introduction – What is FileTable in SQL Server 2012 ? 6 Dec 2012 | 08:43 am
Hi guys, With the release of SQL Server 2012, couple of Programmability enhancements are also introduced. One of the cool feature is “FileTable”. So, what is FileTable and Why do we need it? Applic...
