Re: Please, enlighten me!

No - pages will not migrate between files during an index reorganization!

Submitted by Muhammed Faheem

Quality!

A software developer is a person who should do QUALITY work. That is my counsel to all young developers starting off in IT. Programming is no kid’s workshop and it requires discipline, time and lots of hard work. Always keep up to date with new technologies. Keep your head straight, focus on task at hand, be responsible, pay attention to detail (very IMPORTANT) and avoid HACKS! (What we boastingly call, “Chay-pees”)!

A message by Zeeshan Mirza, Director of Software Services, trg tech

Please, enlighten me!

During an index reorganization operation, if the index spans multiple files, will pages be allowed to migrate between files?

Deadlock!

A deadlock occurs when two or more tasks permanently block each other by each task having a lock on a resource which the other tasks are trying to lock. In a deadlock situation, both transactions in the deadlock will wait forever unless the deadlock is broken by an external process – in a standard blocking scenario, the blocked task will simply wait until the blocking task releases the conflicting lock scenario.

A little humour doesn't hurt

Definition of Programmer

A person who passes as an exacting expert on the basis of being able to turn out, after innumberable poundings, an infinite series of incomprehensive answers calculated with micrometric precisions from vague assumptions based on debatable figures from inconclusive documents and carried out on instruments of problematical accuracy by persons of dubious reliability and questionable mentality for the avowed purpose of annoying and confounding a hopelessly defenseless department that was unfortunate enough to ask for the information in the first place.

Technology has the shelf life of a banana!

Keep yourself updated! Download the new .NET framework 3.5 and Sql Server 2008 (Developer Edition) and start exploring

Get Time Part of the DateTime in .net

Imran Younus, a software engineer and a relational algebra expert (believe me!) has an interesting tip for people who wish to get time part of datetime, in .net, for comparison purposes;

dMyDateTime.Ticks - DateTime.Parse(dMyDateTime.ToShortDateString).Ticks

This will give least value for 12:00 AM and max value for 11:59:59 PM

Well done Zain!

Zain, our brilliant analyst software engineer from Karachi has done his homework!

Answer to yesterday's post is;

"DCM"(Differential-Changed-Map) pages.

Differential backups read just the DCM pages to determine which extents have been modified. This greatly reduces the number of pages that a differential backup must scan. The length of time that a differential backup runs is proportional to the number of extents modified since the last BACKUP DATABASE statement and not the overall size of the database. The interval between DCM pages and BCM pages is the same as the interval between GAM and SGAM page, 64,000 extents. The DCM and BCM pages are located behind the GAM and SGAM pages in a physical file.

You think you've got what it takes to be a DBA?

If yes, I've got one for ya;

What special type of page within SQL Server that is responsible for tracking (via a simple bitmap) extents that have been modified since the last "BACKUP DATABASE" statement?

Answer will be posted tomorrow


email your answers to trgtechmaster@gmail.com

Cool Tip of the Day!

Did you know that when copy/pasting your results from Management Studio, SQL Server 2005(Grid view) into excel, you can copy the column headers too?

Go to Query>Query Options>Results>Grid and check (Include column headers when copying or saving results)

Submitted by Irfan Ali Qureshi

trg tech; where we encourage the creative geniuses to pursue their dreams

I am very pleased to post the very first trg tech blog. On this blog, we will share ideas from our developers, DBA and system architects about all aspects of technology.