Tag: Best

SQL SERVER – 15 Best Practices for Better Database Performance – Journey to SQL


SQL SERVER 15 Best Practices for Better Database Performance

In this blog post we will see 15 best practices for better Database Performance.

I have written 14 best practices here, read them all and let me know what is as per your opinion should be the 15th best practice.

1. Store relevant and necessary information in the database instead of application structure or array.

2. Use normalized tables in the database. Small multiple tables are usually better than one large table.

3. If you use any enumerated field to create look up for it in the database itself to maintain database integrity.

4. Keep primary key of lesser chars or integer. It is easier to process small width keys.

5. Store image paths or URLs in database instead of images. It has less overhead.

6. Use proper database types for the fields. If StartDate is database filed use date time as datatypes instead of VARCHAR (20).

7. Specify column names instead of using * in SELECT statement.

8. Use LIKE clause properly. If you are looking for exact match use “=” instead.

9. Write SQL keyword in capital letters for readability purpose.

10. Using JOIN is better for performance than using sub queries or nested queries.

11. Use stored procedures. They are faster and help in maintainability as well security of the database.

12. User comments for readability as well as guidelines for the next developer who comes to modify the same code. Proper documentation of application will also aid help too.

13. Proper indexing will improve the speed of operations in the database.

14. Make sure to test it any of the database programming as well administrative changes.

Let me know what should be the 15th best practice.

15th best practice might be

Avoid using Triggers to ignore deadlock or recursive trigger situation that loads server free space and crashes.
Better to use trigger related logic in a function or SP and to be called from application codes at times for data stability and safety.

16th best practice might be

Avoid using cursor for simple / single table update. instead use merge query for faster query execution time and more compact SQL query.

Nupur Dave is a social media enthusiast and and an independent consultant.

PDF Downloads
SQL Coding Standards
SQL FAQ Download
SQL Server Performance Tuning Practical Workshop
Download SQL SERVER 2016 (FREE)
SQL PASS Summit 2017 Discount $150 Code LC15SXW9

Exclusive Newsletter

Tags : , , , ,

Best 295 Business Schools 2016 #business #continuity

#business school rankings


The Best 295 Business Schools 2016 Edition is here

We surveyed more than 22,000 students at 295 business schools so we can tell you which b-schools have the best professors, the most competitive students, and more. Find out if your dream MBA program made one of our 11 unique ranking lists.

See the complete list of our 295 Best Business Schools, or view the list by region.

Featured Rankings

Check out our complete list of 295 Business schools, based on surveys of school administrators and over 22,000 students.

You re pursuing your MBA for a brighter future. Find out which schools have the best track records for getting students jobs and the highest starting salaries.

Looking to smash the glass ceiling? These schools will give you a boost by offering the best experience for women.

These schools provide specific resources and supportive cultures to the most diverse faculty and student populations.

Find out which schools have the most competitive applicant pools and celebrate big-time if you get in!

Exciting and accessible professors can make or break your b-school experience. Find out which schools have the most highly rated faculties.

Check out which schools are home to the most celebrated faculty, the brightest class discussions, and most cutting edge trends in both business and learning.

You ll be living on or near campus for at least three years find a beautiful b-school in a livable location.

Want to be sure you ll get the business classes you want on your schedule? These schools run smoothly, making it easy for students to register for required and popular courses.

If you re bringing your family to b-school with you, you need this list. These schools have the happiest married students and offer support to students with children.

Do you perform best under pressure? Check out the schools with the biggest workloads and the most intense environments.

Looking to apply your MBA to sustainability or social issues? Students at these schools feel the most prepared for those challenges!

Why The Princeton Review?

Productive Preparation

We know that great scores take work. That’s why we design our courses to be efficient, targeted and strategic so you make the most of every minute you spend prepping.

Quality Content Delivery

Our experts know how to design lessons based on how you’re learning. That means we don’t just record classroom lessons and put them in our Self-Paced prep we design lessons FOR Self-Paced.

Engaging Teachers

We love our teachers, and so will you. We look for proven expertise and a sense of humor, and that’s BEFORE we put them through 40 hours of training!

Better Scores, Guaranteed

We guarantee progress in our programs that include live instruction and proctored exams.

Tags : , , , ,

Fast Business Loans: Best Options for Quick Cash #sba #business #loans

#fast business loans


Credit Cards






Credit Cards






Fast Business Loans: Best Options for Quick Cash

You can trust that we maintain strict editorial integrity in our writing and assessments; however, we receive compensation when you click on links to products from our partners and get approved. Here’s how we make money .

Sometimes, your small business just can’t afford to wait for funding. Maybe a major piece of equipment has failed, or your pipes burst. Or perhaps you don’t want to miss out on a business opportunity. You need fast cash, and you’re willing to pay more for the speed and convenience.

Business loans from banks are great for keeping loan costs down, but the lengthy application and underwriting process means it can take months to get your money. Online business loans can make sense when speed is your top concern. Below, we compare some of the best business loans for fast cash.


If you want fast cash for immediate needs: Kabbage, OnDeck and Lending Club

Kabbage, OnDeck and Lending Club can provide you with fast cash to handle virtually any immediate need, including dealing with a financial emergency, buying inventory, meeting payroll or other business purposes.

If you have shaky credit, Kabbage could be a good option. The lender does not require a minimum credit score to qualify; instead, your business needs a year of history and at least $50,000 in annual revenue. Kabbage provides a line of credit up to $100,000. You can complete the company’s online application in minutes, with approval and funding just as fast or within a few days, depending on how quickly Kabbage can obtain your business data and verify your bank account. Kabbage, though, comes with high borrowing costs, from 32% to 108% annual percentage rate.

If your personal credit score tops 500 and your annual revenue starts at $100,000, consider an OnDeck term loan. As with Kabbage, you only need a year in business. But OnDeck borrowing costs are lower than those of Kabbage, with APRs of 9% to 98% on term loans and 14% to 40% on lines of credit. The line of credit, which provides more flexibility than a term loan, is a good choice if you have a personal credit score of 600 or more. You can draw and repay funds on an as-needed basis, and with lower overall APRs the line could be less costly than the term loan. You can finish OnDeck’s online application in 10 minutes, with funding as fast as 24 hours but typically in a few days.

Lending Club offers the lowest overall borrowing costs of the three lenders, and funding for its term loan and line of credit typically arrive in less than a week. APRs range from 8% to 32%. You’ll need a personal credit score of at least 600, $75,000 in annual revenue and two years in business to qualify for either product.

  • Loan amount: $5,000 to $500,000 for term loans; up to $100,000 for lines of credit.
  • APR: 9% to 98% for term loans; 14% to 40% for lines of credit.
  • Loan term: Term loans repaid daily or weekly for three to 36 months; lines of credit are repaid weekly.
  • Funding time: As fast as 24 hours but typically a few days.
  • Read our OnDeck review .

Before you apply for an OnDeck loan, find out whether you meet the lender s minimum qualifications.

  • 500+ personal credit score for term loans; 600+ personal credit score for lines of credit.
  • 1+ year in business for term loans; 9+ months in business for lines of credit.
  • $100,000+ in annual revenue for term loans; $75,000+ in annual revenue for lines of credit.
  • No bankruptcies in the last two years.
  • Personal guarantee required.

Before you apply for a Lending Club line of credit, find out whether you meet the minimum qualifications.

  • 600+ personal credit score.
  • 2+ years in business.
  • $75,000+ in annual revenue.
  • Own at least 20% of the business.
  • No recent bankruptcies or tax liens.
  • Provide collateral for loans and lines of credit of more than $100,000.

Lending Club is currently unavailable to borrowers in Iowa and Idaho.

If you need fast cash for a business opportunity: Lending Club, OnDeck and Dealstruck

Small businesses have a number of choices when looking to finance fast expansion or growth.

Lending Club’s term loans come with low rates, but qualifying may be more difficult compared with OnDeck and Dealstruck. You’ll need at least a 600 personal credit score, $75,000 in annual revenue and two years in business.

If you don’t qualify for Lending Club or need cash sooner, OnDeck’s funding turnaround can be as fast as a single day —though, more often, several days to a week. To qualify, you need at least a 500 credit score, a year in business and $100,000 in annual revenue. Your APR will likely be higher than at Lending Club. And, unlike other lenders, OnDeck requires daily or weekly repayments on its term loans, so your business should have steady cash flow to handle the frequent repayments.

If you need more than one type of financing or are unsure which type of financing you need, Dealstruck could be your best bet. The lender has a variety of loan products, such as term loans and inventory lines of credit, with an average of 10 days to funding. To qualify, you need one year of business history, a personal credit score starting at 600 and $150,000 in annual revenue.

Before you apply for a Lending Club loan, find out whether you meet the minimum qualifications.

  • 600+ personal credit score.
  • 2+ years in business.
  • $75,000+ in annual revenue.
  • Own at least 20% of the business.
  • No recent bankruptcies or tax liens.
  • Provide collateral for loans of more than $100,000.

Lending Club is currently unavailable to borrowers in Iowa and Idaho.

Before you apply for an OnDeck loan, find out whether you meet the lender s minimum qualifications.

  • 500+ personal credit score.
  • 1+ year in business.
  • $100,000+ in annual revenue.
  • No bankruptcies in the last two years.
  • Personal guarantee required.

  • Loan amount: $50,000 to $500,000 for term loans; up to $500,000 for inventory and asset-based lines of credit.
  • APR: 10% to 28% for term loans; 22% plus prime rate for inventory and asset-based lines of credit.
  • Loan term: Six months to four years for term loans; six months per draw for lines of credit.
  • Funding time: Average of 10 days.
  • Read our Dealstruck review .

Before you apply for a Dealstruck loan, find out whether you meet the lender s minimum qualifications.

  • 600+ personal credit score.
  • 1+ year in business.
  • $150,000+ in annual revenue.
  • Breaking even or profitable.
  • Personal guarantee and a lien on business assets required.

You may also like

Lender reviews

See how different lenders stack up in NerdWallet’s expert reviews

We want to hear from you and encourage a lively discussion among our users. Please help us keep our site clean and safe by following our posting guidelines. and avoid disclosing personal or sensitive information such as bank account or phone numbers. Any comments posted under NerdWallet’s official account are not reviewed or endorsed by representatives of financial institutions affiliated with the reviewed products, unless explicitly stated otherwise.

2016 NerdWallet, Inc. All Rights Reserved

Disclaimer: NerdWallet strives to keep its information accurate and up to date. This information may be different than what you see when you visit a financial institution, service provider or specific product’s site. All financial products, shopping products and services are presented without warranty. When evaluating offers, please review the financial institution’s Terms and Conditions. Pre-qualified offers are not binding. If you find discrepancies with your credit score or information from your credit report, please contact TransUnion® directly.

Additionally, this site may be compensated through third party advertisers. However, the results of our comparison tools, blog content and editorial reviews are based on objective analysis. For more information, please see our Advertiser Disclosure .

Tags : , , , , , , ,

Best Business Smartphones 2016 (and Why We Love Them) #business #valuation

#best business phone


Best Business Smartphones 2016 (and Why We Love Them)

What do you need in your next business phone? Whether it s a big display, a built-in stylus, or just something that fits into your budget, there s a great smartphone for you. Here are our top picks for 2016.

[For more information on how we test mobile devices, visit our testing methodology page .]

Best Overall Business Phone

  • Early software updates
  • Always-listening voice commands
  • Fingerprint scanner
  • Fast performance
  • Long battery life

Click here for a full review of the Nexus 6P on our sister site Tom s Guide.

Best Battery Life Business Phone

Huawei Ascend Mate 2

You May Also like

Samsung Galaxy S5 Review: Is It Good for Business?

  • Huawei Ascend Mate 2 4G LTE: Top 3 Business Features

  • Apple iPhone 6 Review: Is It Good for Business?

    Tags : , , , , , , , ,

  • Tags : , ,

    Best Top 10 Email Marketing Services #best #marketing #email


    Best Top 10 Email Marketing Services

    Email marketing is a form of direct marketing which uses electronic mail as a means of communicating commercial or fund-raising messages to an audience.

    Although there are multiple options available for those looking to start their own newsletter or email marketing campaigns, Awwwards presents top 10 Email Marketing Services for do it the best way.

    We hope you like it.

    Best Top 10 Email Marketing Services

    Mail Chimp

    Campaign Monitor

    Email Brain

    Stream Send

    Mad Mimi

    Benchmark Email

    Get Response

    Constant Contact

    Graphic Mail


    The awards for design, creativity and innovation on the Internet

    Tags : , ,

    Best Printers for Business #business #names

    #business printers


    Business Printer Reviews, Ratings, and Pricing

    Need a printer for your home office or small office? Computer Shopper’s expert reviews will help you find the best business printer for your needs. Our reviews and business printer ratings walk you through the features and specifications to look for when shopping, whether you’re looking for a multifunction all-in-one printer for your home office or the top laser printer for a small workgroup.

    EcoTank’s a Lot!

    Epson’s $1,199 WorkForce Pro WF-R4640 EcoTank printer speeds along, prints well, and can net you a supremely low cost per page—if you can stomach the initial price.

  • Inking in a New Biz-Printing Flagship

    With an all-new look, HP’s Officejet Pro 8740 packs advanced duplexing and reasonable per-page costs into a solid small-office inkjet.

  • The Inkjet, Accelerated

    HP’s stellar Officejet Pro X Series PageWide printers? Your replacements are here. Can the 2016 PageWide Pro 577dw top the classic Pro X576dw?

  • Mind the Tony Toner

    Pricey toner undermines HP’s Color LaserJet Enterprise M553dn, an otherwise excellent single-function LaserJet that is competitively fast and prints well (surprisingly so, with photos).

  • New Reviews

    Tags : , , ,

    Where can you go for the best business advice? #sell #business

    #small business advice


    Where can you go for the best business advice?

    Starting a business is an exhilarating experience but can also be quite treacherous, if you’re really sure where you’re going. Luckily there is a wealth of information out there to help you prepare. The only issue is, where to start?

    Ever on the pilgrimage to make your business endeavors easier, we have collated a list of the best places to look for startup and small business advice. The best part is, most of them are completely free.

    1. Startup advice

    Gov.uk provides a range of business and financial support options, including advice on writing a business plan. help with finance and support, loans and Growth Voucher opportunities.

    The government’s Growth Accelerator scheme is also well worth checking out. Eligible small businesses can access coaching and advice, as well as up to £2,000 of match funding per senior manager involved in the strategic direction of the business.

    The government isn’t the only place you can find funding for your business more funding info here .

    Startup Britain is characterised as a “national campaign by entrepreneurs for entrepreneurs” and provides free events and advice for budding businesses. They also work with the government in order to create better initiatives and funding options for startups, which aims to give small businesses the opportunity to have their say.

    99u is online portfolio company, Behance’s effort to “make ideas happen”. The site offers a selection of articles, videos and advice on innovation and creative thinking. If you’re feeling a little depleted and you need some business motivation, 99u is a great place to start.

    2. HR advice for small business

    ACAS provides information, advice, training and other services for employers and employees relating to employment and HR issues. As well as advice and training, ACAS also offers online modules to help you achieve the ‘model workplace’ and get to grips with employment law.

    Early conciliation is a particularly useful section of the ACAS site if you find yourself in a workplace dispute. The free service offers the opportunity to resolve issues without having to go to an employment tribunal.

    HR Zone has a decent mix of informative blog posts, white papers and employment law features. They also have a library and online resource centre, which offers a 14 day free trial for all new members. It is free to join and you will be alerted of all up-and-coming events near your area.

    Human Resource Solutions support small businesses who may not have the capital or need to hire HR professionals. The website offers professionally written free resources, as well as downloadable HR policies and procedures templates.

    3. Accounting advice

    J4b provides funding and grant information to startups and small businesses. The site also offers advice and guidance on relevant awards and tax relief and is easier to navigate than HMRC.

    HMRC is the almighty ruler of all British tax issues and has all of the financial information required to set up your business and manage your finances. It is not the easiest website to navigate so here are some of the most useful areas for you:

    The new HMRC section on the gov.uk website is much more user friendly.

    4. Business mentoring services

    Horsesmouth describes itself as “the social network for informal mentoring” and offers the opportunity to sign up to have or be a mentor. They have a specific section on starting a business where you can search for mentors on a variety of subjects including, interviewing, managing people, business plan and investment.

    Mentorsme is designed to help you find a business mentor as quickly and easily as possible. You can also find a range of useful resources on their website, including accounting a business advice, better financial control and how to complete a lending request.

    Tags : , , , , , , , ,

    Online Colleges in Texas #best #online #colleges #in #texas


    Online Colleges in Texas

    Overview of Online Colleges in Texas

    In 2007, the Texas Virtual School Network was established by the Texas Legislature to provide online learning opportunities to high school students. Since its inception in 2009, TxVSN has provided 8th through 12th grade students with state-supported online education, in collaboration with texas school districts.

    In October 2010, the US Department of Education issued new program integrity regulations that declares that colleges and universities offering online programs should receive some sort of authorization from their home state. In Texas, this meant that, before online students living outside the state could enroll in a program, the schools offering said programs had to comply with a set of state-specific distance education regulations. This ensures that after a strict approval process, Texas distance learning programs are providing the best possible curriculum for students.

    While Texas s tuition fees continue to rise, costs are increasing at a slower pace than the national average. Tuition inflation rates at the state s public four-year schools over the past 5 years increased 9%, compared to the 17% increased national average. Between 2004 and 2014. students at public two-year schools experienced a 32.2% tuition hike, while public four-year schools saw a 38.4% tuition increase during the same period. The spike in tuition costs can be partially credited to the 22.5% decrease in state funding for higher education between 2008 and 2014.

    Despite increased tuition costs, enrollment at Texas institutions is on the rise. Between 2002 and 2012, Texas public institutions experienced a 31% increase in enrollment, surpassing the 19% increased national average. According to the Texas Higher Education Data. public two-year schools have seen a dip in enrollment in recent years, although enrollment increased from 2009 to 2011. Enrollment in public four-year schools steadily increased from 2009 to 2013. Texas s public four-year schools have a 50.2% overall graduation rate, and a 74.7% first year student retention rate.

    For more information on Texas s top distance learning programs, consult our extensive school database. Find available scholarships and financial assistance tools in the College Savings section below.

    Top Featured Schools Sponsored Schools

    Capella is an accredited online university dedicated to providing an exceptional, professionally-aligned education that puts you in the best position to succeed in your field. Capella’s challenging curriculum is competency-based, combining foundational theory with real-world application, to ensure our students receive a high-quality education.

  • As a Keiser University student, you will learn degree-specific theory and gain valuable experience on key technologies to prepare you for a career ahead. Keiser University offers over 100 different doctoral through associate degrees in a variety of health care, business, information technology, culinary arts, legal studies, and education fields.

    Official State Links

    College Savings

    • Texas College Savings Plan. Texas College Savings Plan offers two investment styles: age-based portfolios and static portfolios. Both of these options are managed by OFI Private Investments. This plan gives account holders the flexibility to rebalance their contributions or change allocations at any time.
    • Texas Tuition Promise Funds. This prepaid tuition plan is one of the newest 529 plans for Texas residents. There are three types of plans, and participation is limited to Texas residents; account holders pay for tuition and fees to be used by a beneficiary at a later date at public two-year and four-year colleges and universities in Texas.
    • Lonestar 529 Plans. To open a Lonestar 529 plan, account holders need just $25, and they choose from age-based or static investment options. Investments are managed by OFI Private Investments Inc. a subsidiary of OppenheimerFunds, Inc. TIAA-CREF, Dreyfus Investments and Thornburg Investments.

    Education Nonprofits

    • Texas Coalition for Excellence in Higher Education. The Texas Coalition for Excellence in Higher Education is dedicated to raising awareness of issues in higher education. The coalition’s membership is focused on promoting policies to expand access to, and increase affordability of, higher education across the state.
    • Texas Association of Chicanos in Higher Education. This organization is dedicated to improving education and employment opportunities for Hispanics in Texas. The advocacy group works to provide forums for discussion of education-related issues.
    • Educate Texas. This nonprofit works with student to prepare them for higher education and the workforce. It is a public-private organization that uses collaborative methods to reach its goals.

    Higher Education News

    • The Lowdown on Higher Education. A blog through the Statesman newspaper, this publication focuses on higher education issues in Central Texas.

    Tags : , , , ,
  • Best company cars 2016 #t #shirt #business

    #business cars


    Best company cars 2016

    If you’re choosing a company car our guide to the best company cars 2016 will help you find the perfect match

    Company cars are still big business in the UK, with around a half of all new sales going to the fleet market.

    So manufacturers are keen to cash in, even developing special ‘business models’ to maximise value for money for thousands of user chooser motorists. These machines are kitted out with extras that help them stand out in the corporate car park and ease the stresses and strains of life on the road.

    But which model makes the most business sense? To help, we’ve crunched the numbers and scrutinised the spec sheets to pick some of the cars that’ll beat down your Benefit-in-Kind bills; our colleagues at online car retailer BuyaCar.co.uk explain what BIK is and why it’s significant (below). Our picks were split into five price categories and we named six of the best in each. As company car taxes are based on CO2 emissions, all our choices are clean and efficient. But you won’t be lumbered with a stripped-out eco special.

    In fact, you’ll be amazed at the variety of machinery you’ll be able to get your hands on, because the constant drive to improve efficiency and the fierce fight for sales means you can get a lot of car for your cash.

    From city cars to hybrids, people carriers to premium saloons, there’s something for everyone, plus they won’t leave a large dent in your wallet when the Inland Revenue calls.

    But picking a company car doesn’t always have to be all about the bottom line. To prove it, in each price band we’ve selected a fun choice that will put a smile on your face when you’re driving it and see how much it’ll save you.

    What is BIK and what will it cost me?

    Annual Benefit-in-Kind (BIK) tax is charged on a proportion of a company car’s brand new value. It’s determined by CO2 emissions – benefiting electric cars. Lower-rate earners pay 20 per cent of this proportion; higher-rate taxpayers 40 per cent.”

    Company car numbers guide

    A company car is essential for many drivers’ work, but Her Majesty’s Revenue Customs sees it as a perk. The Government calls it a Benefit in Kind and, as with your wages, it’s liable to tax.

    The amount of salary you have to sacrifice to get your hands on a company car depends on a number of factors, including the model’s CO2 emissions and P11D value. The latter is essentially the price of the car, including any options, minus the non-taxable costs such as the registration fee and the first year’s road tax.

    There are currently 25 Benefit in Kind (BIK) bands, each based on a car’s CO2 emissions. The lowest-polluting cars attract a seven per cent BIK rate, with the highest levied at 37 per cent.

    Until recently, electric cars were exempt from these charges, but these zero-emissions machines are now rated at seven per cent. Crucially, this figure is set to increase each year; by 2019 battery-powered models will be taxed at 16 per cent.

    It’s also worth keeping in mind that diesel models have a three per cent surcharge over petrol versions with the same emissions. So make sure you do enough miles that the fuel savings outweigh the bigger BIK bills.

    The final part of the company car cost calculations involves your salary. If you fall into the 20 per cent income tax bracket, you’ll pay 20 per cent of the P11D value, while higher-rate earners will fork out 40 per cent. Usually this will be deducted from your monthly pay packet.

    Best company cars by price bracket

    Tags : , , ,