T-SQL Tip : Finding Running Total Value
Hi Guys, In one of my SSRS Reporting needs, I need to display RunningTotal in some funny colors. Here is the script that I have used. I hope it may help you somewhere too 🙂 Thanks, Khilit
Continue reading →Category Archives: SQL Server
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 of the case where you are inserting a record in table A and there is a trigger which fires as soon as there is a insert in table A which insert a record in table B. so in such case @@IDENTITY wont give you the … Continue reading →
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 to column data type which stores the BIG numbers. I ran into this issue couple of times, and reason behind this issue was same all the time. So decided to do a quick post. And that reason is “Improper or insufficient precision, scale and length defined for storing … Continue reading →
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 CD3000 Table B Year Month RecCustomerCode <Extra Columns> 2012 JAN CX1000 2012 JAN CX7000 2012 JAN CD8000 What is expected was – Table A’s following records: Year Month CustomerCode <Extra Columns> 2012 JAN CX2000 2012 JAN CD3000 … Continue reading →
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 SI ON SO.ID = SI.ID WHERE TYPE = ‘U’ AND SI.INDID IN (0,1) ) SELECT * FROM CTE_DATABASETABLESIZE /*ORDER BY SCHEMANAME ORDER BY TOTALROWS ASC*/ ORDER BY TOTALROWS DESC Note: Customize this query according to your needs 🙂 Thanks, Khilit
Continue reading →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: http://www.jamesserra.com/archive/2013/01/ssas-one-giant-cube-or-many-small-ones i hope you also find this interesting. thanks, khilit
Continue reading →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 Manager site -> Add your user in “System Role Assignment” (settings) etc. But there is tini-tiny step you have to do before you run your IE as Administrator. Open your IE -> Tool -> Internet Options. Security tab -> Local intranet -> Sites -> Advanced … Continue reading →
SQL Server User Group Event on 4th Oct 2012, Singapore
Hello friends, how are you doing? There is an event (SQL User Group, Singapore) on 4th October 2012. Following is the detail about the event. Send an email to “Chen Liang <liangchen@dataraid.info>” with your name, working place and contact number for reservation of your seat. There is no charge for all members of SQL Server Singapore User Group. You can become the member of this group by joining this group: https://www.facebook.com/groups/sqlugsg/ Topic SQL Server Integration Services 2012 Unplugged Time 4th Oct 18:30 – 21:00 Place One Marina Boulevard, 22CF-15 Speaker Dr. Wee Hyong, Tok Dr. Wee Hyong is a Senior … Continue reading →
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 rules. 1. Fast Analysis (FA): Data retrieval should be less than 5 seconds. Should support any business scenarios for any type of analysis. The structure should support such flexibility that new calculations can be easily and quickly defined.
Continue reading →E-Book Gallery for Microsoft Technologies
Hi guys, good morning !!! here is the list of cool FREE E-Books from Microsoft Press.
Continue reading →