Information Organizations In Database – Part – 3 As stated in the last article that “In the forthcoming article we will be noticing particular fine points concerning Entity Centered Rational Replica’s – Associations, Natures of Associations, Attributes of An Entity and Sub-types & Super-types”, here is the article. Entity Centered Rational Replica:- There are numerous entities – grounded replicas. The...
SQL Server
Tips for using Join Hints in SQL Server 2014
Tips for using Join Hints in SQL Server 2014 Use join hints very carefully. Because SQL Server 2014 query optimizer usually proposes the best execution plan, it is very unlikely that you can optimize your query by using join hints, more often, this will hurt performance. Try to rewrite the query to provide better execution plan. If your query is...
Information Organizations In Database Part 2
Information Organizations In Database – Part – 2 As stated in the last article that “In the forthcoming article we will be noticing particular fine points concerning Entity Centered Rational Replica’s – The Entity Relationship (ER) Model and Entities”, here is the article. Entity Centered Rational Replica:- There are numerous entities – grounded replicas. The generally used is the Entity...
Memory management for In-Memory OLTP Server – Part 1
Memory management for In-Memory OLTP Server Part-1 Microsoft introduced a new functionality in SQL 2014 namely memory optimized objects. As the name implies, this technology is about having tables reside in memory. This means that the memory usage on your database will be much higher. In this series of articles we will see how we can manage the memory in...
Memory management for In-Memory OLTP Server – Part 2
Memory management for In-Memory OLTP Server – Part II In my previous article, we saw how to calculate the memory needed for memory based objects when using In-Memory technology that was introduced in SQL Server 2014 version. We also saw how we can monitor the memory usage by these objects. In this article we will see how we can make...
SQL Server 2014 Reporting Services Optimization Tips
SQL Server 2014 Reporting Services Optimization Tips Consider using the Google Chrome browser to run the Reporting Services native mode Report Manager. SQL Server 2014 release of Reporting Services adds support for the Google Chrome browser. So, you can use the Google Chrome browser to run the Reporting Services native mode Report Manager to manage reports and the report server....
Information Organizations In Database Part 1
Information Organizations In Database – Part 1 Introduction The Database Management System (DBMS) is an application castoff to pile as well as shape the data. A DBMS piles data in databases then routine through the data standards to define the several means of managing data. The Relational Database Management System (RDBMS) is a cutting-edge form of a DBMS which as...
SQL Server 2014: Stored Procedures
SQL Server 2014: Stored Procedures Author: Basit A. Farooq Introduction A stored procedure is a named, precompiled collection of SQL statements, variables, and control-of-flow statements. You can create stored procedures that accept input parameters and return values and status information. Typical uses for stored procedures include automating repetitive tasks, ensuring tasks are performed consistently, enhancing application and user access security...
Tips for using data types in SQL Server 2014
Tips for using data types in SQL Server 2014 Use Date/Time data types to store date/time information separately. In SQL Server 2014 you can store the date and time information separately. For example, if you need to work with date data only, use the Date data type instead of datetime or smalldatetime to optimize storage space and simplify date modifications...
