Some tips for using indexed views in SQL Server 2016 Consider creating two or more smaller views instead of creating a single large indexed view. Sometimes it can greatly improve performance especially if the underlying tables are located in different databases. Add an index to a view very carefully. When the underlying tables of the view are modified, the clustered […]
SQL Server
Introduction to Structured Query Language (SQL) — Part — 5
Introduction to Structured Query Language (SQL) – Part – 5 Commit To finish the existing transaction as well as to make everlasting modifications as done by the transaction an individual can make use of COMMIT command. This command removes every save-point in the transaction as well as releases the transaction’s locks. An individual can also make use of this command […]
Top 5 Ways to Make a Bad First Impression
Top 5 ways to make a “bad” first impression 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 so […]
Some tips for using User-Defined Functions in SQL Server 2016
Some tips for using User-Defined Functions in SQL Server 2016 Use scalar user-defined functions when you need to do the same mathematical calculations at multiple places in code. For example, if you need to calculate the factorial for the given number, you can write appropriate scalar user-defined function to encapsulate code for reuse. Consider using CLR user-defined functions. The CLR […]
Introduction to Structured Query Language (SQL) — Part — 4
Introduction to Structured Query Language (SQL) – Part – 4 In What Manner to Update Information The INSERT statement is castoff to insert new data in a table or relations, then again what if an individual want to perform a modification to a specific data? In this circumstance the Structured Query Language (SQL) statement completes the modification with the help […]
Some tips for using Merge Replication in SQL Server 2016 (Part 2)
Some tips for using Merge Replication in SQL Server 2016 (Part 2) Avoid publishing unnecessary data. Try to restrict the amount of published data. This can results in good performance benefits, because SQL Server will publish only the amount of data required. This can reduce network traffic and boost the overall replication performance. Set the “Maximize Throughput for Network Applications” […]
Introduction to Structured Query Language (SQL) — Part — 3
Introduction to Structured Query Language (SQL) – Part – 3 In What Manner to Delete A Table or Relation If an individual have previously implemented the original CREATE TABLE statement then the database will have the table or relation known as XYZBank . Customer . Details, so let’s remove that by means of the DROP statement: DROP TABLE XYZBank . […]
How to Make a Sale without Selling
How to Make a Sale without Selling 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 so that they […]
Some tips for using Merge Replication in SQL Server 2016 (Part 1)
Some tips for using Merge Replication in SQL Server 2016 (Part 1) Avoid replicating text, ntext and image columns. These data types require more storage space and processing than other column data types. Consider setting the -OutputVerboseLevel parameter of the Merge Agent to 0. This parameter specifies whether the output should be verbose. There are three available values: 0 – […]
Introduction to Structured Query Language (SQL) — Part — 2
Introduction to Structured Query Language (SQL) – Part – 2 Data Definition Language (DDL) in Structured Query Language (SQL) The Data Definition Language (DDL) is a part of Structured Query Language (SQL) which allows database tables or relations to be formed or removed. An individual can describe indexes, different keys, relationship among the different tables or relations, as well as […]