The Young DBA

Dear Friends, Today I want to share my experience in Excel.. I think Line Break Character is most popular issue we faced day to day when trying to data cleaning/Transformation in excel or exporting Large data from Excel to SQL for Data warehouse. Sometimes Users typing Enter mistakenly in cell or sometimes copy paste from web page to excel create new line character.  So before using this excel we need to remove this character to make it proper. There is quite a few ways to do so, one of them is to use   Excel find/replace dialog box .  Using this feature is really straightforward, the only problem is that not everyone knows   how to type in the line break symbol . The trick here is to   press ALT and then enter 010 using the numeric keypad . Happy Reading SumnJha

Hi Friends ,  Few month before  this question was asked to me  , at that time it was totally surprising for me, so my answer was No IDEA sir.. I thought this is Non-Technical question because by name its like any kind of Garden and I am aware about such garden... But This is very interesting Topic in  IIS and Web Technology.. This question forced me to searched and share about this GARDEN .. So,  I planned to implement and test in our current Organization..  he he.... Actually , When a single Application pool contain multiple Worker process is called web garden and  Web application hosted on multiple server and access based on the load on servers is called Web Farms.. Difference between Web Farm and WEB Garden.. Web FARM : When we hosting our single web site on multiple web server over load balancer called WEB FARM . Think if we have only one   web server and multiple clients   requesting for the resources from the server. But when there is huge numbers of 

When   we   installation or upgrade Sql Server   from a previous version   into 2008, by default a job will be created syspolicy_purge_history.   What does it do? Sql Server 2008 introduced a new feature called Policy Based Management.  For example, one could define a policy that says all tables must have a clustered index.  Once defined, the policy can be evaluated against targets to check for compliance. Each evaluation of compliance will be recorded in below tables :- 1. msdb, 2. syspolicy_policy_execution_history_details_internal,  3. syspolicy_policy_execution_history_internal, and  4. syspolicy_policy_category_subscriptions_internal  The evaluation condition is built on top of object facets, which is predefined by Microsoft. The purpose of that job, syspolicy_purge_history, is to remove records in those tables to maintain so it does take up space unnecessarily .  Happy Readding. @Sumnjha

Dear Friends, We allready know Normalization is the process to optimize the storage and increase the performance of system by eliminating redundancy from database. But there is also circumstances when Normalization can reduce database performance.Due to Joins-Jonis-Joins system makes complex to select a simple record-set. A normalized database requires much more CPU , memory ,  and I/O to process transactions and database queries than does a normalization database. Ref:  1.)  advantages-disadvantages-normalizing-database 2.)  www.informit.com/articles

Sometimes there would be a requirement to add serial number (or) row number to the result set. Example: The requirement would be to select some columns from the database tables along with Serial Number like below SNo Customer_Name Customer_Phone_Number 1 aaa xxx-xxx-xxxx 2 bbb xxx-xxx-xxxx So, in this post we will see how we can select that using T-SQL on Microsoft SQL Server 2008 We can achieve this in several ways: 1) Using  Row_Number ()   Row_Number() Returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.  T-SQL Script:          SELECT ROW_NUMBER() OVER (ORDER BY CUSTOMER_ID) AS [S.No]                         ,CUSTOMER_NAME                         ,CUSTOMER_PHONE_NUMBER         FROM database.dbo.tblTableName 2) Using  Identity (Property)   Identity() property creates an identity column in the table. So, first we need to cre

Enterprise Systems and IT Application can be categories in two types OLTP and OLAP . In General Terms OLTP is day to day Record Keeping of any organization and OLAP is the Historical Data of Warehouse..   OLTP (On-line Transaction Processing)   is characterized by a large number of transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second. In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (usually 3NF) OLAP (On-line Analytical Processing)   is characterized by relatively low volume of transactions. Queries are often very complex and involve aggregations(DISTINCT,GROUP BY,SUM,COUNT ..). For OLAP systems a response time is an effectiveness measure. OLAP applications are widely used by Data Mining techniques. In OLAP database ther

Dear Friends , Last week I was doing Database Re-Engineering of our few Legacy Applications. Actually Re-engineering is a set of activities that are carried out to re-structure a Legacy System to a new system with better functionalities and conform to the hardware and software quality constraint. I tested 3 Tools for Data-Modeling for this process. (1) Toad Data Modeler 4.1 (2) Microsoft Visio and (3) SSMS 2008 . Data Modeling is a process used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations. All are the good software for Data-modeling but I liked all time favorite SQL Server Management Studio Relationship Diagrams simple-easy, free and having good options.. A little formatting in SSMS database diagrams editor As more tables will be added, these may not be arranged for easy viewing. To change the arrangement of the diagrams you can right click in the