Tips for using stored procedures in SQL Server 2017 Consider using natively compiled stored procedures. Natively compiled stored procedures are Transact-SQL stored procedures compiled to native code. These stored procedures allow for efficient execution of the queries and business logic in the stored procedure. The difference between interpreted (disk-based) stored procedures and natively compiled stored procedures is that an interpreted...
SQL Server
File Organization & Indexing – Part 3
PRIMARY INDEXES A primary index is an ordered file whose records are of fixed length with two (2) fields. The very first field is of identical data types because the ordering key field of the information file, and also the second field may be a pointer to a disk block – a block address. The ordering key field is termed...
The Best Option for Promoting Your Business
Hello there, I am a manager of a small company and we are trying to hit the market for information about cryptocurrencies. Our services provide data on what to invest in and how to make the most profit out of it. Since our budget is quite limited we decided to think about two options. · First one is to order...
Tips for using table hints in SQL Server 2017
Tips for using table hints in SQL Server 2017 If you want to set any table hints, do not remember to test the query with hint and without the hint and compare results. Because SQL Server 2017 query optimizer usually proposes the best execution plan, you should test the query with table hint and use this hint only when it...
File Organization & Indexing – Part 2
INDEXED – SEQUENTIAL ORGANIZATION In the indexed-sequential files technique, records are physically hold on in sequential order on a magnetic disc or alternative direct access memory device based on the key field of each and every record. Every file contains an index that references one or additional key fields of each and every information record to its storage location address....
Tips for using query hints in SQL Server 2017
Tips for using query hints in SQL Server 2017 You can use the KEEP PLAN query hint if you want to reduce the estimated recompile threshold for a query. For example, using this hint reduces the number of recompiles when multiple table updates occur. This example shows how you can use the KEEP PLAN hint: SELECT * FROM authors OPTION...
File Organization & Indexing – Part 1
Sequential Organization In the sequential organization, records are physically put away in a predefined order as indicated by a key field in each and every record. The most general method for organizing the collection of records that from a file is to make use of sequential organization. In a sequentially organized file records are composed consecutively when the file is...
When Should Someone Be Fired?
This question came from a busy professional. When an employee seems to be very poor with time management, should he be fired? No employee should be fired without going through a PIP (Performance Improvement Plan). The PIP is specifically designed to help employer and employee work on the areas that need improvement. Coaching the employee Once the manager identified the...
What Type of Digital Marketing Strategies Should You Implement for a Startup?
This question came from a busy professional. What type of digital marketing strategies should we implement for a startup? We are in the primary stage and do not have much money. Congratulations on starting your business. The amazing thing regarding digital marketing is that it doesn’t cost much money to get started. But you do need to invest time, energy...
Tips for using full-text search in SQL Server 2017
Tips for using full-text search in SQL Server 2017 Make full-text index population during periods of low database access. Because full-text index population takes some time, these updates should be scheduled during CPU idle time and slow production periods. Reduce the full-text unique key size. To create a full-text index, the table to be indexed must have a unique index....