MAXDOP

http://msdn.microsoft.com/en-us/library/ms181714.aspx
MAXDOP number

Overrides the max degree of parallelism configuration option of sp_configure and Resource Governor for the query specifying this option. The MAXDOP query hint can exceed the value configured with sp_configure. If MAXDOP exceeds the value configured with Resource Governor, the Database Engine uses the Resource Governor MAXDOP value, described in ALTER WORKLOAD GROUP (Transact-SQL). All semantic rules used with the max degree of parallelism configuration option are applicable when you use the MAXDOP query hint. For more information, see max degree of parallelism Option.
Caution note Caution

If MAXDOP is set to zero then the server chooses the max degree of parallelism.

Using MAXDOP

The following example uses the MAXDOP query hint.
Copy

USE AdventureWorks2008R2 ;
GO
SELECT ProductID, OrderQty, SUM(LineTotal) AS Total
FROM Sales.SalesOrderDetail
WHERE UnitPrice < $5.00
GROUP BY ProductID, OrderQty
ORDER BY ProductID, OrderQty
OPTION (MAXDOP 2);
GO

Live Space Mover | broom's blog

Live Space Mover | broom's blog: "# Install Python runtime and Beautiful Soup. There are 2 combinations tested by me:

1. Python Runtime 2.5.2 and Beautiful Soup 3.0.6
2. Python Runtime 2.5.1 and Beautiful Soup 3.0.4 and a small fix in note 1

Place the file BeautifulSoup.py in the same directory of live-space-mover.py, or install it into Python runtime by yourself
# Download the newest release zip from the hosted page, extract it. (Older versions may become unusable because of the HTML changes of Live Space).
# Change your live space settings

1. Make sure it is open to anyone (not only to your contacts)
2. Set time zone to the same with your wordpress blog
3. Set date format to yyyy/mm/dd, or mm/dd/yyyy. This probably depends on the locale setting of your system or browser, the point is to make the “YEAR” appear in your date. If the program fails and complains about date parsing, try to use the option -t to specify date time format. For example, the time on my space is shown like “9:45 PM”, but if your time is shown like “9:45:15 PM”, you may want to use a command line like below

python live-space-mover.py -s http://yourspaceid.spaces.live.com/ -t '%m/%d/%Y %I:%M:%S %p'

An introduction for the time format parameters are available here.
4. Set “Blog entry date display” to “Show the blog entry date in the header”
5. From some users’ feedback, I noticed themes of live space differ slightly in structure, which may lead to failure of this program. So please change your live space theme to “Journey” (the same as my experiment space).

# Run the live-space-mover.py script. In Windows, open the command line (win+R, enter “cmd” and return), change to the directory (use “c:”/”d:” to change disk, use “cd” command to change directory, please google it for help if need) of live-space-mover.py, run command like this

python live-space-mover.py -s http://yourspaceid.spaces.live.com/

Replace the example parameter with your own. This will generate an XML file named “export_xxxxx.xml” in the same directory of this script, which is in WordPress export file format.
# Use the import function in WordPress to import the XML file generated in the last step, remember to choose “WordPress” type in the import page, rather than “LiveJournal” or something else.

- Sent using Google Toolbar"

Unlock iPhone 3.1.3 3G/3GS OS with Ultrasn0w 0.92

Unlock iPhone 3.1.3 3G/3GS OS with Ultrasn0w 0.92


We have published guide to jailbreak iPhone 3.1.3 using Redsn0w 0.9.4 now here is good news for iPhone 2G/3G & 3GS owners latest version of sn0wbreeze 3.1.3 has been released which can jailbreak iPhone 3.1.3 2G, 3G and 3GS with old boot rom and also preserves the iPhone baseband.

Now using Sn0wbreeze 3.1.3 you can unlock your iPhone 3G/3GS 3.1.3 with Ultrasn0w 0.92. This will only work if you haven’t updated to stock firmware 3.1.3. The procedure to unlock iPhone 3.1.3 is quite easy just follow simple steps and get your iPhone 3.1.3 unlocked.

1. Download Sn0wbreeze 3.1.3 and jailbreak your iPhone 3G & 3GS 3.1.3 OS for iPhone 2G 3.1.3 you can use Redsn0w 0.9.3

2. Once you have jailbreaked your iPhone 3.1.3 you can go to Cydia under manage tab then access sources. (T-Mobile users should disable 3G before installing Ultrasn0w)

3. Now edit and add http://repo666.ultrasn0w.com source url and click on Add sources.

4. Now search for ultrasn0w 0.92 and install it. It will automatically unlock your iphone.

5. Now restart your iPhone and enjoy unlocked iPhone 3G/3GS 3.1.3

Why is tempdb full, and how can I prevent this from happening?

Why is tempdb full, and how can I prevent this from happening?

Developing your Research Statement

Developing your Research Statement: "Developing your Research Statement
Britt Argow, Wellesley College, and Rachel Beane, Bowdoin College, wrote this page for the 2009 Pursuing Academic Careers Workshop.

Variably called a Statement of Research Goals or Interests, Research Agenda, or Research Statement, many academic job searches give you the opportunity to present your scholarly accomplishments in a summary document. A research statement is often a critical part of your job application packet, but it doesn't end there. Throughout a career in academia you are likely to be asked to prepare similar documents for annual reviews, reappointment and tenure packages, and for promotion. Shorter summaries may be submitted for awards or publicity, or may appear on your departmental web pages. For this reason, the time you commit to crafting a thoughtful and provocative statement of your research interests is an investment in your academic career.
Purposes of a research statement

An effective research statement accomplishes three key goals:

1. It clearly presents your scholarship in non-specialist terms;
2. It places your research in a broader context, scientifically and societally; and
3. It lays out a clear road-map for future accomplishments in the new setting (the institution to which you're applying).

Another way to think about the success of your research statement is to consider whether, after reading it, a reader is able to answer these questions:

1. What do you do (what are your major accomplishments; what techniques do you use; how have you added to your field)?
2. Why is your work important (why should both other scientists and non-scientists care)?
3. Where is it going in the future (what are the next steps, and how will you carry them out in your new job)?

Tailor your research statement

Research statements are not one-size-fits-all, and of necessity will reflect the nature of your research, your level of experience and expertise, and the type of institution to which you are applying. When applying to top-tier research universities, your research statement ideally works to demonstrate that you will bring unique and critical expertise, grant opportunities, and potential for high productivity to the institution. Liberal arts colleges often expect a balance between teaching and research, and therefore you might want to include examples of how students have been or will be involved in your research program. Two-year colleges rarely request a research statement as part of the application package, and in general it is a good idea to respect their guidelines. If, however, you have research plans that you could conduct in this setting with little funding that would involve students in a research experience, you may want to volunteer an additional statement that showcases the educational impact of your work and makes your application stand out (while making clear that you understand the environment and mission of the institution).

Consider carefully the needs of the institution to which you are applying, and tailor your research statement to meet those needs. Keep in mind the realities of facilities, teaching loads, and other institutional support, especially if you are applying to institutions quite different from your doctoral institution. Write a statement that proposes a plan of research compatible with the opportunities available at the target school, or explain what collaborations you expect to develop to gain access to needed facilities or equipment. You may want to consider the current research programs of the faculty at the target institution, and then explain how your proposed research program broadens, strengthens, and complements the current program. If you are applying to several different types of job opportunities, you may need several versions of your research statement.

Some general do's and don'ts

* Do ask your doctoral research adviser, a recent hire in your department, or former graduate student colleagues who have moved on to academic jobs (especially in your target type of institution) to look over your research statement.
* Do (respectfully) ask to look over copies of the research statements of friends and colleagues who have had successful job searches, or those of junior faculty in your department.
* Do refer to your own past publications and presentations (cite them) as appropriate when describing your research.
* Do tailor your statement to each type of institution to which you are applying.
* Do proof-read carefully, and ask a friend or mentor to review it as well, before sending it out.
* Don't wait until the last minute to write your research statement!

Further Resources

* Planning your Research Program is one of the great challenges of transitioning from being a graduate student to a PI in your own right. This is a page of resources from the workshop for Early Career Geoscience Faculty on teaching, research, and managing your career, including a worksheet to help you plan your research program."

Purdue OWL

Purdue OWL: "When you're applying for a faculty position with a college or university, the cover letter is your first chance to make a strong impression as a promising researcher and teacher. Below you'll find some strategies for presenting your qualifications effectively in an academic context.
Distinctions between Academic and Business Cover Letters

A cover letter for an academic job has a function similar to one for a business job, but the content differs significantly in quantity and kind. While the general advice for business cover letters—such as tailoring your letter for the specific job and selling your strengths—still applies, a cover letter for an academic position should be long enough to highlight in some detail your accomplishments during your graduate education in research, teaching, departmental service, and so on. The typical letter is thus usually one and a half to two pages long, but not more than two—roughly five to eight paragraphs.
The First Paragraph

In the opening of your letter you need to convey some basic information, such as what specific position you are applying for (using the title given in the job notice) and where you learned of the opening. Since a cover letter is a kind of persuasive writing (persuading a hiring committee to include you on a list of candidates for further review), the first paragraph of your letter should also make the initial claim as to why you are a strong candidate for the position.
Tailoring for Your Audience

In an academic context knowing your audience means reading the job notice carefully and knowing the type of institution to which you are applying. Most graduate students have studied a broad range of material within their discipline before specializing in a narrow field for the dissertation project. Since it is rare to find a job notice specifying your exact qualifications, you need to emphasize those aspects of your graduate training that seem particularly relevant to the position advertised.

* Job notice: If you've written a political science dissertation on populism in early twentieth-century US national politics, you probably won't respond to a notice seeking a specialist in international politics during the Cold War. But you may wish to apply for a position teaching twentieth-century US political parties and movements. In this case you would want to stress the relevance of your dissertation to the broad context of twentieth-century US politics, even though the study focuses narrowly on the pre-World War I period. You might also highlight courses taken, presentations given, or other evidence of your expertise that corresponds to the job notice.
* Type of institution: Often the job notice will provide a brief description of the college or university, indicating such factors as size, ownership (public, private), affiliation (religious, nonsectarian), geography (urban, suburban, rural), and so on. These factors will influence the kind of information emphasized in your letter. For example, for a job at a small liberal arts college that focuses on undergraduate teaching, you would emphasize your teaching experience and pedagogical philosophy early in the letter before mentioning your dissertation. On the other hand, for a job at a large research university you would provide at least one detailed paragraph describing your dissertation early in the letter, even indicating your plans for future research, before mentioning your teaching and other experience.

Other Advice

If you're still working on your dissertation, you should mention somewhere in the letter when you expect to be awarded the Ph.D., even being as specific as to mention how many chapters have been completed and accepted, how many are in draft version, and what your schedule for completion is. Last-paragraph tips include the following:

* Mention your contact information, including a phone number where you can be reached if you will be away during a holiday break.
* If you will be attending an upcoming major professional conference in your field, such as the MLA convention for language and literature professionals, indicate that you will be available for an interview there. Be sure to mention that you are available for telephone or campus-visit interviews as well.
* If you have some special connection to the school, type of institution, or region, such as having attended the school as an undergraduate or having grown up in the area, you may wish to mention that information briefly at some point.
* Mention your willingness to forward upon request additional materials such as writing samples, teaching evaluations, and letters of recommendation."

Deveoping your Teaching Statement

Deveoping your Teaching Statement: "Through the exercises that follow, you will develop your own, individual, teaching statement. (These exercises, and a few others, are published in Ellis and Griffin, 2000.) Although the teaching statement is often called a statement of teaching philosophy or a statement of teaching interests, these terms are somewhat misleading. It may help you to think of your teaching statement as a persuasive essay, the purpose of which is to persuade your readers that you are an excellent teacher, and would make a valuable addition to their department. As with any persuasive essay, the more concrete examples you can give to support your statements, the more persuasive it will be.

In preparation for writing your essay, take some time to gather your thoughts.... The three exercises below are designed to help you reflect on your experiences as a student, and your experiences and aspirations as a teacher. You can work your way through them at your own pace; you may find it helpful to give yourself a few hours or days to mull over some of the questions. You also, of course, can choose to skip any questions that don't seem applicable to you, or jot down any thoughts that come to you as you answer other questions."