Daily Archives

Articles indexed Friday March 12 2010

Page 10/130 | < Previous Page | 6 7 8 9 10 11 12 13 14 15 16 17  | Next Page >

• SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT

  - by pinaldave

  During my recent training at one of the clients, I was asked regarding the enhancement in TOP clause. When I demonstrated my script regarding how TOP works along with INSERT, one of the attendees suggested that I should also write about this script on my blog. Let me share this with all of you and [...]

  Read the article

• SQLAuthority News – Keeping Your Ducks in a Row

  - by pinaldave

  Last year during my visit to SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 2 I have received ducks from the event. Well during the same event I had learned from Jonathan Kehayias the saying of ‘Keeping Your Ducks in a Row‘. The most popular theory suggests that “ducks in a row” came [...]

  Read the article

• SQLAuthority News – MUGH – Microsoft User Group Hyderabad – Feb 2, 2010 Session Review

  - by pinaldave

  Earlier this month, I was very fortunate to visit Microsoft User Group Hyderabad lead by Hima Vindu Vejella. Hima is a very enthusiastic leader and kind person. I had a wonderful time meeting her as well her husband during my visit to Hyderabad. I had presented session on Index, which was well received. Brief information on [...]

  Read the article

• SQL SERVER – Introduction to Rollup Clause

  - by pinaldave

  In this article we will go over basic understanding of Rollup clause in SQL Server. ROLLUP clause is used to do aggregate operation on multiple levels in hierarchy. Let us understand how it works by using an example. Consider a table with the following structure and data: CREATE TABLE tblPopulation ( Country VARCHAR(100), [State] VARCHAR(100), City VARCHAR(100), [Population (in Millions)] INT ) GO INSERT INTO tblPopulation VALUES('India', 'Delhi','East Delhi',9 [...]

  Read the article

• SQLAuthority News – Links to Book On Line – Data Mining Algorithms (Analysis Services – Data Mining)

  - by pinaldave

  I have quite often received request for the Data Mining Algorithms details. Book Online has wonderful resources for the same. I suggest to read them here. Data Mining Algorithms (Analysis Services – Data Mining) The data mining algorithm is the mechanism that creates a data mining model. To create a model, an algorithm first analyzes a set [...]

  Read the article

• SQLAuthority News – Blog Subscription and Comments RSS

  - by pinaldave

  Quite often I get email where many readers ask me how to get email from SQLAuthority.com blog. Today very quickly I will go over few standard practices of this blog using you can stay connected with SQLAuthority.com First the most important is search: I received hundreds of emails and hundreds of comments every day. I try [...]

  Read the article

• SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1 from table)

  - by pinaldave

  Few days ago I wrote article about SQL SERVER – Stored Procedure Optimization Tips – Best Practices. I received lots of comments on particular blog article. In fact, almost all the comments are very interesting. If you have not read all the comments, I strongly suggest to read them. Click here to read the comments. The [...]

  Read the article

• SQL SERVER – Recompile Stored Procedure at Run Time

  - by pinaldave

  I recently received an email from reader after reading my previous article on SQL SERVER – Plan Recompilation and Reduce Recompilation – Performance Tuning regarding how to recompile any stored procedure at run time. There are multiple ways to do this. If you want your stored procedure to always recompile at run time, you can add [...]

  Read the article

• SQLAuthority News – Microsoft SQL Server Migration Assistant 2008 for MySQL v1.0 CTP1

  - by pinaldave

  Microsoft SQL Server Migration Assistant (SSMA) 2008 is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2008 and SQL Azure. SSMA 2008 for MySQL v1.0 CTP1 provides an assessment of migration efforts as well as automates schema and data migration. Download Microsoft SQL Server Migration Assistant 2008 [...]

  Read the article

• SQL SERVER – Plan Recompilation and Reduce Recompilation – Performance Tuning

  - by pinaldave

  Recompilation process is same as compilation and degrades server performance. In SQL Server 2000 and earlier versions, this was a serious issue but in SQL server 2005, the severity of this issue has been significantly reduced by introducing a new feature called Statement-level recompilation. When SQL Server 2005 recompiles stored procedures, only the statement that [...]

  Read the article

• SQLAuthority News – SQL Server Technical Article – The Data Loading Performance Guide

  - by pinaldave

  The white paper describes load strategies for achieving high-speed data modifications of a Microsoft SQL Server database. “Bulk Load Methods” and “Other Minimally Logged and Metadata Operations” provide an overview of two key and interrelated concepts for high-speed data loading: bulk loading and metadata operations. After this background knowledge, white paper describe how these methods can be [...]

  Read the article

• SQL SERVER – Stored Procedure Optimization Tips – Best Practices

  - by pinaldave

  We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles. Include SET NOCOUNT ON statement: With every SELECT and DML statement, the SQL server returns a message that indicates the number of affected rows [...]

  Read the article

• Business Logo Design - Is Clients Input Important

  In today';s world, there is a cutthroat competition everywhere, so is in the field of logo designing. In a scenario like this, how you, as a logo design company would differentiate yourself in terms o... [Author: Gisselle Gloria - Web Design and Development - October 05, 2009]

  Read the article

• Empower Your Designer For A Remarkable Corporate Logo Design

  Business owners do come across several problems while designing their logos from logo designers. No matter even if you are succeeded in hiring a reputable logo design company for your project, you st... [Author: Gisselle Gloria - Web Design and Development - October 05, 2009]

  Read the article

• Points To Ponder While Going For A Custom Logo Design

  Every organization, whether small or large, go for designing a logo for its business. And in these days and age, with immense competition, it';s hard to get identified and build a strong brand image. ... [Author: Gisselle Gloria - Web Design and Development - October 05, 2009]

  Read the article

• Logo Design Online: Process Of Hiring And Working With An Online Logo Design Company

  Hiring an online logo design company is not easy these days; you will find hundreds of logo design companies on just click of a mouse. But it';s up to your decision making skills how you select a best... [Author: Gisselle Gloria - Web Design and Development - October 05, 2009]

  Read the article

• Considerations Before Hiring Logo Design Services

  These days, hiring a logo design service is not easy. Just enter a keyword "logo design" in a search engine and you will see thousands of result pages full of online logo design services. Certainly, ... [Author: Gisselle Gloria - Web Design and Development - October 05, 2009]

  Read the article

• Web and Logo Design: Essential for Small Business

  In this era of life, no business can imagine to run without an attractive logo and the state of the art website. Every day, thousands of businesses are established all over the world, and double the ... [Author: Gisselle Gloria - Web Design and Development - October 05, 2009]

  Read the article

• Does Your Website Have ?Calls to Action??

  Does your website have ?Calls to Action?? If your answer is ?NO? then you have greatly diminished the ?Goal Realization Capability? of your website. Think about an interested visitor to your websit... [Author: Neil Paige - Web Design and Development - September 03, 2009]

  Read the article

• Tips For SEO Friendly Marketing Content For Your Website

  Getting your website positioned as high as possible in SERP (Search Engine Result Pages) is one of the main goals for everyone who has a SEO strategy. Statistics prove that the percentage of getting... [Author: Neil Paige - Web Design and Development - September 03, 2009]

  Read the article

• Graphic Designers: Fuel Behind a Site?s Success

  The success of a site or say an online business depends on several factors. Not only the products and services that you specialize in coin the success strategy for a business, other factors like prom... [Author: David Jackson - Web Design and Development - August 31, 2009]

  Read the article

• Choose Your Logo Design Company Only After Proper Research

  A logo speaks about the identity of any firm or business set-up. Without a company logo, you won?t be able to give a true name to your presence. However, many people take it just as a mere graphic sy... [Author: David Jackson - Web Design and Development - August 31, 2009]

  Read the article

• Flash Web Design with the Help of Flash Professionals

  Flash has often been criticized by web specialists for its relatively slow loading time. It?s also been targeted by many people who have experienced loading problem of a Flash site on the web. But no... [Author: David Jackson - Web Design and Development - August 31, 2009]

  Read the article

• Grids In Web Design: Organized And Effective Designing

  Website designs are creative creations, which do exhibit the culmination of an artist?s outlook, usage of latest tools and progression of skill. Indeed, it is an art, but there are some parameters or... [Author: David Jackson - Web Design and Development - August 31, 2009]

  Read the article

• Website Designing: Right Moves, Right Results

  Creating a website is like nurturing a plant, where the process begins with choosing the right sapling or seed and ends with sowing ? the productive phase begins afterwards. Likewise, website designi... [Author: David Jackson - Web Design and Development - August 31, 2009]

  Read the article

< Previous Page | 6 7 8 9 10 11 12 13 14 15 16 17  | Next Page >