Standard Members

Pro Members SQL Server Standard Members

Tips for using indexed views in SQL Server 2017

Tips for using indexed views in SQL Server 2017 Keep the indexes on the views as narrow as possible. Because each index takes up disk space try to minimize the index key’s size to avoid using superfluous disk space. This reduces the number of reads required to read the index and boost overall index performance. Try to create indexes on...

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 4

HIERARCHY OF DATA Information are the important assets of any organization. Information stored in computer system shape a hierarchy extending from a single bit to a database, the real record keeping element of a firm. Each higher rung of this hierarchy is sorted out from the segments beneath it. Information are coherently sorted out into: 1. Bits (characters) – A...

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

5 Biggest Mistakes People Make in Presentations

This question came from a busy professional. I’m searching for career experts who can tell me the biggest mistakes people make when making a presentation at work. Most everyone has heard of the more common mistakes of not making eye contact with the audience and relying too heavily on note cards. But here are some of the bigger mistakes that...

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 to work with SQL Server 2017 clustering

Tips to work with SQL Server 2017 clustering You should proper configure the SQL Server 2017 service accounts. Ensure that each SQL Server 2017 service account is a domain account and a member of the Local Administrators group of each cluster node and a member of the Domain Users group. Set the SQL Server 2017 service accounts passwords to be...

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 3

Tape file systems A tape file system is a file system and tape format intended to store records on tape in a self-depicting structure. Magnetic tapes are sequential storage media with considerably longer random data access times than disks, posturing difficulties to the creation and proficient administration of a universally useful file system. In a disk file system, there 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

How to Stay Connected as a Remote Worker

This question came from a busy professional. How do you stay connected as a remote worker? As a remote worker, how do you fight feelings of isolation? Especially looking for advice that newcomers to remote work can use. Thank you! In these technological times, it’s even simpler to stay connected. With the advent of video conferencing, online chatting and texting,...

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 User-Defined Functions in SQL Server 2017

Tips for using User-Defined Functions in SQL Server 2017 Consider using user-defined table type as a parameter for user-defined function. SQL Server 2017 supports a user-defined table type that supports representing table structures for use as parameters in user-defined function. Using UDF type can simplify user-defined function’s programming and may increase UDF performance. Use TRY-CATCH logic to trap and handle...

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 2

The Database Management System (DBMS) modifies entered information to fit in with required data structures. The Database Management System (DBMS) mitigates an individual of the errand of influencing a distinction between the logical information format and the physical information format. That is, the Database Management System (DBMS) organizes the physically recovered information to influence it to comply with the end...

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 Merge Replication in SQL Server 2017 (Part 2)

Tips for using Merge Replication in SQL Server 2017 (Part 2) If you do not need continuous replication, do not configure the Merge Agent to run continuously. Try to schedule the Merge Agent to run at regular intervals instead of running continuously. Try to schedule it during CPU idle time and slow production periods. By using it, you can decrease...

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 Stress Less During the Day

This question came from a busy professional. How to stress less throughout the day What are some tips for busy woman regarding how to stress less throughout the day? What are some ways in the morning, afternoon, and night that you can relax a little more — physically, mentally, emotionally? Easy ways and easy to remember! There are a few...

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