SQL Server Development and Deployment Standards The purpose of this article is to highlight a set of standards for the development and deployment of database code. This will allow best practices to be complied with, standards to be maintained and ownership to be traced. It will also mean that developers and DBAs alike can share common practices that will assist...
SQL Server
How to Overcome Nervousness of Public Speaking of Attending Networking Events – Part 1
How to Overcome Nervousness of Public Speaking of Attending Networking Events Part 1 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...
Some tips for SQL Server 2016 clustering
Some tips for SQL Server 2016 clustering Avoid running other software on the SQL Server 2016 cluster nodes. To increase SQL Server 2016 performance, SQL Server clusters should be dedicated to SQL Server only. Consider using Distributed Availability Groups (DAG) if you have two availability groups residing on different Windows Server Failover Clusters (WSFC). DAG enables you to associate two […]
Managing Query Execution in Database Engine Part 5
Managing Query Execution in Database Engine Part – 5 Elementary Algorithms for Executing Query Processes The effectiveness of query handling in a Relational Database Management System (RDBMS) is grounded on the competence of the relational operators. Even the easiest actions can frequently be implemented in a number of different methods as well as the costs of the different methods could […]
How Can I Test Whether a Person has Strong Leadership Skills?
How can I test whether a person has strong leadership skills? 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 […]
Some tips for using table hints in SQL Server 2016
Some tips for using table hints in SQL Server 2016 Use the INSERT … SELECT statement with the TABLOCK hint. In SQL Server 2016, the insert in an INSERT … SELECT statement is multi-threaded or can have a parallel plan. To get a parallel plan, you can use the compatibility level 130 and the INSERT … SELECT statement must use […]
Managing Query Execution in Database Engine Part – 4
Managing Query Execution in Database Engine Part – 4 Heuristic Method for Query Processing Heuristic process frequently includes creation of alterations for the query tree by means of stirring the operators up as well as down the tree as a result the altered tree is the same to the tree before the alterations. Earlier to start the heuristic method in […]
Some tips for using query hints in SQL Server 2016
Some tips for using query hints in SQL Server 2016 If your query is very slow, try the following before using query hints: – rebuild indexes used in the query (or defragment them using DBCC INDEXDEFRAG), – update statistics on the relevant tables, – consider creating new indexes for this query, – rewrite your query to provide better execution plan. […]
Managing Query Execution in Database Engine Part – 3
Managing Query Execution in Database Engine Part – 3 Internal Query Arrangement As it was known previously, a query created in a query language like Structural Query Language (SQL) should be 1st transformed to an internal arrangement which is appropriate for a machine to understand and represent as well. Every internal query arrangement should be adequately influential to signify every […]
What are some good ways to bring back lost customers?
What are some good ways to bring back lost customers? 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 […]
