The SQL Server storage engine architecture SQL Server maps the database over a set of operating system files that store database objects, tables, and indexes. Physically, a SQL Server database is a set of two or more operating system files. Each database file has two names, that is, logical file name and physical file name. The logical file name is […]
SQL Server
Tips for using SQL Server 2016 cursors
Tips for using SQL Server 2016 cursors Reduce the number of rows to process in the cursor. To reduce the cursor result set use the WHERE clause in the cursor’s select statement. Do not forget to close SQL Server 2016 cursor when its result set is not needed. To close SQL Server cursor, you can use CLOSE {cursor_name} command. This […]
Information Modeling By means of Entity Relationship (ER) Method Part – 6
Information Modeling By means of Entity Relationship (ER) Method Part – 6 Columns or Attributes Columns or attributes are information objects which either classify or define entities. Columns or attributes which classify entities are known as important columns or attributes. Columns or attributes which define an entity are known as non important columns or attributes. Important columns or attributes will […]
Some tips for using bulk copy in SQL Server 2016
Some tips for using bulk copy in SQL Server 2016 Consider using minimally logged bulk copy whenever possible. The minimally logged bulk copy is much faster than other bulk copy methods, but to use it you must provide all the following conditions: 1. The database option ‘select into/bulkcopy’ is set to true (by the way, using this option causes the […]
Information Modeling By means of Entity Relationship (ER) Method Part – 5
Information Modeling By means of Entity Relationship (ER) Method Part – 5 Phases in Constructing the Information Model Though Entity Relationship (ER) diagram lists as well as describes the concepts which are mandatory for building an information model, but still there is no regular manner for completing so. A number of practices insist on a bottom up progress method where […]
SQL Server 2016 Reporting Services Optimization Tips
SQL Server 2016 Reporting Services Optimization Tips Use Reporting Services web portal. The Reporting Services web portal introduces in SQL Server 2016 and replaces Report Manager from previous releases. This is a modern portal which incorporates KPIs (Key performance indicators), Mobile Reports, Paginated Reports, Excel and Power BI Desktop files. Consider using the Chart data region. SQL Server 2016 supports […]
Information Modeling By means of Entity Relationship (ER) Method Part – 4
Information Modeling By means of Entity Relationship (ER) Method Part – 4 Database Design with Information Modeling The information modeling is one portion of the abstract design procedure. The other portion is known as the function modeling. The information modeling emphases on what information must be kept in the database on other hand the function modeling focus on by what […]
Should I Tell My Current Employer About My Side Business?
Should I tell my current employer about my side business? Career Management Series By Laura Lee Rose Hello, this is Laura Lee Rose – author of TimePeace: Making peace with time – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. I help busy professionals and entrepreneurs create effective systems […]
Guidelines for Scaling your Reporting solution
Guidelines for Scaling your Reporting solution Author: Basit A. Farooq You will not always find it practical to conduct your own performance tests on a new configuration before you deploy it. When this happens, you should use monitoring to establish baseline performance measures on your existing system. You should then repeat the monitoring with the new configuration to assess the […]
Tips for using constraints in SQL Server 2016
Tips for using constraints in SQL Server 2016 Try to create a single column constraint. The more columns the constraint will have, the slowly it will work and the more stored space it will require. Use default constraints instead of DEFAULT objects. DEFAULT object are provided for backward compatibility and has been replaced by default definitions (default constraints) created using […]