• Using DISTINCT in SQL to eliminate duplicate rows

    Learn how to use the DISTINCT keyword to eliminate duplicate rows in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition." You'll learn how to use DISTINCT on either single or multiple columns when working with SELECT statements in SQL.

    ITKE346,360 pointsBadges:
  • Effective ‘big data’ strategy helps advertising firm attract clients

    Online advertising company adMarketplace uses a mix of NoSQL and SQL databases in a "big data" environment that feeds its search syndication system.

    DRebernik70 pointsBadges:
  • What is SQL?

    The acronym SQL stands for Structured Query Language.

    ITKE346,360 pointsBadges:
  • What is the best practice when defragmenting an MS application server?

    What is the best practice when defragmenting an Exchange, SQL or other Microsoft application server?

    ITKE346,360 pointsBadges:
  • What programming languages should I learn for the SQL DBA?

    I am MCSE on NT 4.0 and working in the networking field for three years. I am an expert in most Windows OS including IIS and Exchange Server. I want to make career as Exchange or Web administrator. I am also looking for career as SQL DBA, but I am not very well aware of programming languages. Which...

    Ed Tittel4,620 pointsBadges:
  • Freeware profiler for SQL Server

    SQLcheck is a neat freeware goodie that you can use to check a wide range of parameters in your SQL Server databases.

    ITKE346,360 pointsBadges:
  • Program code searches with SPEED Ferret

    SPEED Ferret allows SQL programmers to find instances in source code, property values and references.

    ITKE346,360 pointsBadges:
  • Louisiana hospital finds scalable solution in SQL data warehouse

    Curtis Boyd had a miniscule budget. Yet, he needed to quickly replace a nearly 20 year-old mainframe system to reduce report generation times from two weeks to one day. Sounds like Mission: Impossible, right? Well, with a little patience and a lot of testing, Boyd's mission turned into a...

    ITKE346,360 pointsBadges:
  • Are the SQL7 exams going away?

    What is the implication of the certifications being recognized, and those not being recognized, the MCDBA2000 vs the normal MCDBA for SQL7? Is that implying that the SQL7 exams are going away with the certification?

    Ed Tittel4,620 pointsBadges:
  • SQL-on-Hadoop steps out front at Hadoop Summit 2014

    This edition of the Talking Data Podcast takes a look at the recent Hadoop Summit 2014, where SQL where Hadoop shared the spotlight with SQL.

    Jack Vaughan3,120 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.