SQL Server

Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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....

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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....

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

Database and File System Organization – Part 5

REDUNDANT ARRAY of INDEPENDENT DISKS (RAID) RAID is short for Redundant Array of Independent (or Inexpensive) Disks. It is a classification of disk drives that utilize at least two (2) drives in blend for adaptation to non-critical failure and execution. Redundant Array of Independent (or Inexpensive) Disks (RAID) disk circle drives are utilized habitually on servers yet aren’t for the...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

How to Get an Interview When You’re Under-Qualified

How Can We Get an Interview When We’re Under-Qualified? for the job because they don’t meet all the qualifications or have the specified experience. Why should they apply anyway?The mistake that many make is to assume that the employer is looking for that 1 perfect candidate that meets all their wishes. Therefore, if you wait until your 100% qualified, you...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register