Tips for using data types in SQL Server 2017 Avoid using timestamp column as a primary key. Timestamp is a data type that exposes automatically generated, unique binary numbers within a database. Every time that a row with a timestamp column is modified or inserted, the incremented database rowversion value is inserted in the timestamp column. This property makes a...
Standard Members
File Organization & Indexing – Part 5
DIRECT FILE ORGANIZATION In the index – sequential file organization as it can be considered with the earlier sections, the mapping from the search – key value to the storage location is by means of index entries. In direct file organization, the key value is mapped with the storage location. The same old technique of direct mapping is by performing...
Why Are ‘Soft Skills’ More Difficult to Learn than ‘Hard Skills’?
Soft skills are just as important as hard skills. But why are they more difficult to learn than hard skills? Breaking a myth Soft skills are not actually “more difficult to learn”. But they are less tangible and more aligned with personalities. Soft skills relate to your attitudes and your intuitions which are harder to describe and define. Soft skills...
Tips for using views in SQL Server 2017
Tips for using views in SQL Server 2017 Consider using stored procedures instead of using views. The stored procedures much more flexible than views. For example, a stored procedure can contain insert, delete, update statements, can call other stored procedures, or extended stored procedures, and so on. Use views instead of heavy-duty queries to reduce network traffic. Using views instead...
File Organization & Indexing – Part 4
SECONDARY INDEXES A secondary index is also an ordered file with two (2) fields, and, as within the alternative indexes, the second field may be a pointer to a disk block. The first field is of identical data type as some non – ordering field of the information file. The field on that the secondary index is built is named...
How to Manage Work-Life Balance
Apart from professional life, what are your hobbies and interests? Do you believe in work-life balance? If so how do you manage it? Deliberately schedule the time The best way to manage your work-life balance is to deliberately schedule it. Make a list of your imperatives (list of things that – if everything else were to disappear except those things,...
Tips for using stored procedures in SQL Server 2017
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...
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...