Buffering of Disk Blocks The recovery procedure is frequently carefully tangled with operating system (OS) functions in specific, the buffering as well as caching of disk pages in main memory. Naturally, one (1) or more (N) disk pages which include the information items to be modified are cached into main memory buffers and then updated in memory prior to start...
Standard Members
What should I consider when pricing my product?
Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – the The Book of Answers: 105 Career Critical Situations – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. A busy entrepreneur has this question regarding his product: What...
Some tips for using SQL Server 2016 Database Console Commands
Some tips for using SQL Server 2016 Database Console Commands Consider using a MAXDOP option with the DBCC CHECKTABLE, DBCC CHECKDB and DBCC CHECKFILEGROUP. This option was first introduced in SQL Server 2016. By using a MAXDOP option with the DBCC CHECKTABLE, DBCC CHECKDB and DBCC CHECKFILEGROUP you can specify the degree of parallelism. If you don’t need to check...
Database Recovery Methods Part 1
Introduction In this article a number of methods which can be castoff for database recovery from failures are discussed. The various reasons of database failures are already to known to us, like system crashes in addition to transaction faults. The very first section of the article will be outlining the usual recovery techniques as well as the classification of recovery...
How can you choose the most appropriate job title when wearing many ‘hats’ in your company?
Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – the The Book of Answers: 105 Career Critical Situations – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. A busy business owner asks a question leading his team:...
Tips for using indexes in SQL Server 2016 (Part 2)
Tips for using indexes in SQL Server 2016 (Part 2) Drop indexes that are not used. Because each index take up disk space and slow down the adding, deleting, and updating of rows, you should drop indexes that are not used. You can use Database Engine Tuning Advisor to identify indexes that are not used in your queries. Keep your...
How do you get your people to read and follow processes?
Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – the The Book of Answers: 105 Career Critical Situations – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. A busy professional asks a question leading his team: How...
Tips for using indexes in SQL Server 2016 (Part 1)
Tips for using indexes in SQL Server 2016 (Part 1) Consider creating the columnstore indexes on the memory-optimized tables. Beginning with SQL Server 2016, you can create a memory-optimized table with a columnstore index. You can use the ALTER TABLE ADD INDEX statement to add the columnstore index after the memory-optimized table is created. Create a clustered index for each...
How do I get rid of my biggest time wasters?
How do I get rid of my biggest time wasters? Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – the The Book of Answers: 105 Career Critical Situations – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies....
Some useful SQL Server 2016 trace flags
Some useful SQL Server 2016 trace flags Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. There are 3 types of trace flags in SQL Server 2016: query trace flags global trace flags session trace flags Query trace flags are active for the context of a specific query. A global trace flag...