Standard Members

Pro Members SQL Server Standard Members

Some tips for using jobs in SQL Server 2017

Some tips for using jobs in SQL Server 2017 Try to separate very large job into several small jobs. This can improve performance, and can be useful to maintenance the jobs and locate any problems. Specify the understandable job name. Try to specify the job’s name so, that the name describes what the job makes. By using so, you can...

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) Should a Project be Monitored on an Ongoing Basis?

How should a project manager monitor projects on an ongoing basis? The short answer is “YES” Step to Project Management Every step of the project and project management process needs to be monitored on an ongoing basis. Here are some steps to project management: Project Initiation. Project Planning. Project Execution. Project Monitoring and Control. Project Closure. Each step has its...

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 data types in SQL Server 2017

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

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

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

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

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

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

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

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

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