SQL Server

Pro Members SQL Server Standard Members

Some tips for using DBCC commands in SQL Server 2017

Some tips for using DBCC commands in SQL Server 2017 Use the DBCC SHOW_STATISTICS command to displays the current distribution statistics for the specified target on the specified table. You can use this DBCC command to see how distributed the data is and whether the index is really a good candidate or not. Avoid using the DBCC SHOWCONTIG command. This...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Tips for Delegating Work

In the past few weeks, several busy professionals have asked questions about how to best delegate work. This article contains the answers to their various questions. Is there a right time for one to delegate and at what point should an entrepreneur feel comfortable enough to delegate? When it comes to delegating tasks, what advice can you give to get...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here