Mashed Articles

For any interested female candidates in the technical field.

As part of Google’s ongoing commitment to furthering Anita’s vision, Google are pleased to announce The Google Anita Borg Memorial Scholarship: Europe, the Middle East and Africa.

Through the scholarship, Google Anita Borg aim to encourage women to excel in computing and technology, and become active role models and leaders.

Multiple scholarships will be awarded based on the strength of candidates’ academic performance, leadership experience and demonstrated passion for computer science. A group of female Bachelor’s, Master’s, and PhD student finalists will be chosen from the applicant pool.

The scholarship recipients will each receive a €7,000 (or equivalent) scholarship.

Eligibility requirements

Candidates must:

Be a female student entering her final year of a Bachelor’s degree, or enrolled in an a Master’s or PhD programme (or equivalent), in 2010/2011.

Be enrolled at a University in Europe, the Middle East, or Africa. Citizens, permanent residents, and international students are eligible to apply.

Be studying Computer Science, Computer Engineering, Informatics, or a closely related technical field.

Maintain an excellent academic record (e.g. a First Class Honours degree).

How to apply

Please complete the online application http://google.eresources.com/applications/login.asp and submit all requested documents

Deadline: 1st February each year

A survey is a very simple and cost effective technique to help you get a better idea of what your customers want and desire. A survey is the best tool for feedback about various products and services available to gain offered by an organization.

Data is correctly displayed in the right way that will benefit any organization. Survey has an economical way, the data supporting the needs of a company. Survey Processing is generally to the organization / company, involved in market research, customer or product data or surveys data collection Project.

A team of professionals are waiting to help you analyze the impact of your staff productivity, management competence and marketing strategies on your valuable customers. Survey Processing Services solution provides you aggressive benefit, letting clients respond to customer feedback more quickly.

There variety of area of survey processing likes:

* Survey Setup and Design
* Printing and Mailing Services
* Web-based Surveys
* Survey Scanning
* Survey Data Entry
* Reporting
* Comment Coding and Entry
* Statistical Reporting

Now a day the Survey is the best and simple way that gives a solution to collect the information from a common group through the application of questioners and interviews.

The benefits of outsourcing survey processing:

* Cost-effective survey mediums including custom envelope design and mailing services
* Accurate data-digitizing techniques like OCR, OMR and ICR
* Highly skilled and committed workforce at every phase of survey processing
* Customized survey processing suites to suit your business requirements
* Petite and effective delivery timeframes
* Valuable suggestions from our business experts to improve your business process and increase revenue
* Nominal package prices compared to the benefits from catalyzing your revenue generation capabilities

Survey processing an inclusive online survey processing service solution, ranging from questionnaire design through analysis interpretation to reports, graphics and presentations that will give you a clear idea about the employee productivity, management capability, customer satisfaction and organizational performance of the organization.

About the Author

Survey processing service gives you a competitive advantage, letting clients respond to more rapidly. Survey processes have become highly dependent on computerized systems.

Article Source: http://www.goarticles.com/

I have a client who has viewes that contain UNION ALL command for number of very large tables. The logic is to apply a WHERE condition to that view to get the data. Even having indexes on those tables SQL Server applies a WHERE condition to each SELECT statement within a view that may lead to performance proble. To demonstate it please considetr AdwentureWork data and two tables Sales.SalerDetails and SalesOrderHeader

CREATE VIEW v1
AS
SELECT S.SalesOrderID
FROM
Sales.SalesOrderDetail S
UNION ALL
SELECT S.SalesOrderID
,S.CreditCardID FROM
Sales.SalesOrderHeader S

SET STATISTICS IO ON
SELECT TOP 100 * FROM v1 WHERE SalesOrderDetailID >40000 AND SalesOrderDetailID<45000

Table ‘SalesOrderDetail’. Scan count 3, logical reads 1359, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table ‘SalesOrderHeader’. Scan count 1, logical reads 34, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

You can see that SQL Server ‘touched’ those tables by using Clustered Index Scan on
Sales.SalerDetails and Clustered Index Seek on Sales.SalesOrderHeader. Indeed I realy simplified the logic as in reality it has horrible performance. How to improve?

I create a Multi-Statement Table-Valued UDF that accepts a parameter
CTREATE FUNCTION dbo.udf1
(
@SalesOrderID INT
)
RETURNS @t TABLE (c1 INT,c2 INT)
AS
BEGIN
INSERT INTO @t
SELECT S.SalesOrderID
FROM
Sales.SalesOrderDetail S
WHERE SalesOrderID > @SalesOrderID AND SalesOrderID<@SalesOrderID+5000
UNION ALL
SELECT S.SalesOrderID
FROM
Sales.SalesOrderHeader S
WHERE SalesOrderID > @SalesOrderID AND SalesOrderID<@SalesOrderID+5000
RETURN
END
Table ‘#74AE54BC’. Scan count 1, logical reads 12, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

See , I applied a WHERE condition within an UDF for every statement as UDF must get parameters.This is another argument to use Table-Valued UDF …

From my previous post,I note the importance of having a good anti-virus on one’s system,I now post my favorite anti virus programs based on performance and its a 3 program download.

After installing any of the program make sure to update the virus pattern, then full scan your system. Regular full scanning of one’s PC is recommended at least once a month, sometimes malware, trojan, rootkits, slip on one’s system unnoticed and will activate when certain conditions exist.

Enjoy!

Click link to download!
Anti-Virus1

Anti-Virus2

From my previous post,I note the importance of having a good anti-virus on one’s system,I now post my favorite anti virus programs based on performance and its a 3 program download.

After installing any of the program make sure to update the virus pattern, then full scan your system. Regular full scanning of one’s PC is recommended at least once a month, sometimes malware, trojan, rootkits, slip on one’s system unnoticed and will activate when certain conditions exist.

Enjoy!

Click link to download!
Anti-Virus1

Anti-Virus2