SQL Server analytic functions can fix problems quickly

With the help of T-SQL analytic functions, we can quickly solve complex analytical tasks. Learn more from SQL Server expert Basit Farooq.
T-SQL tricks for SQL Server 2012: T-SQL statements

In the final part of Robert Sheldon's series on features and tricks in T-SQL, learn about important T-SQL statements like LAG, LEAD and more.
T-SQL tricks for SQL Server 2012: T-SQL formatting

Learn the advantages of new T-SQL formatting tools in this third part of expert Robert Sheldon's series on new T-SQL tricks for 2012.
T-SQL tricks for SQL Server 2012: T-SQL functions

In this second in a series of tips about new T-SQL features in SQL Server 2012, expert Robert Sheldon explores more tricks for getting the most out of T-SQL functions.

SQL-Transact SQL (T-SQL)

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.

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

query

A database query can be either a select query or an action query. A select query is simply a data retrieval query. An action query can ask for additional operations on the data, such as insertion, updating or deletion. Definition

Business Analytics
- Wixom: BI applications need visual appeal
  
  Business intelligence teams should upgrade their visual design skills to create winning applications for BI users, says IT professor Barbara Wixom.
- Business intelligence program needs long-term tending to fully blossom
  
  The evolution of Quicken Loans' business intelligence strategy from static reporting to self-service BI holds useful lessons for other organizations.
- O'Reilly Strata conference tackles big topics in data science, Hadoop
  
  The O'Reilly Strata conference was the place to be to learn about the role of the data scientist and big data technologies.
Data Center
- Is energy-efficient software the next step to reduce operating costs?
  
  When the limits of hardware innovation have been reached, energy-efficient software could be way to cut electricity costs.
- Q&A;: Markley looks to lighten load as an IaaS provider
  
  Interest in cloud continues to gain traction, so how does a small infrastructure services provider compete with the Amazon Web Services of the world?
- Big data analytics software for intelligence community goes commercial
  
  IT shops that need to analyze huge volumes of data can look to a newly available big data analytics tool that was previously reserved for the intelligence community.
Data Management
- Wikibon analyst scopes big data market, predicts explosive growth
  
  Big data technologies challenge the status quo. In this Q&A;, analyst Jeff Kelly sorts through the issues and sees big-time growth in new methods.
- Gartner Magic Quadrant finds rising demand for data warehouse services
  
  A look at the latest Gartner Magic Quadrant for Data Warehouse Database Management Systems and more data management news from around the Web.
- Business capability model helps data pros sell MDM, Gartner says
  
  Data management pros need business buy-in to get funding for MDM initiatives. Modeling business capabilities can help, according to a Gartner analyst.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- Oracle Sun hardware is not for hobbyists, by a long shot
  
  Old Sun enthusiasts lament the way it used to be, and the way it will never be again. Oracle Sun hardware is a whole other animal.
- Why Ray Wang is excited about Collaborate 2013
  
  Find out what analyst R 'Ray' Wang of Constellation Research is most excited about regarding the upcoming 2013 Oracle Collaborate conference.
- What's out there for Oracle third-party tools
  
  Oracle products come with an array of integrated tools, but an ecosystem of third-party tools exists that can make an Oracle developer's life even easier.
Content Management
- Chief content officer can create value from content management noise
  
  The Google Reader RSS controversy could give chief content officers an opportunity to see what matters in content management and what doesn't.
- Rich media flood pushes digital asset management strategy to forefront
  
  Without an effective plan for managing digital assets, the increasing digital content collected by organizations could end up being a real headache.
- Avoid the pitfalls of cloud collaboration management
  
  Analyst Tim Walters explains how to build a strong case for cloud collaboration management and how to avoid problems that pop up along the way.
Windows Server
- Five things you might not know about the Hyper-V virtual switch
  
  One of the most significant improvements in Windows Server 2012 might be the Hyper-V virtual switch. What makes this low-cost option such a big deal?
- A quick look at BitLocker installation requirements
  
  A basic BitLocker installation doesn't require any unusual steps, but deploying it on Windows Server 2012 comes with a few caveats.
- How to use the BitLocker recovery options in Windows Server 2012
  
  BitLocker offers two recovery methods in Windows Server 2012. Our expert defines the options and explains how to use recovery passwords and keys.

Latest Headlines

Featured

E-Books

E-Zines

Topics

Hot Topics

Advice & Tutorials

Technology Dictionary

Tips

Ask a Question

Research Library

Product Demos

Resource Centers

Blogs

SQL-Transact SQL (T-SQL)

Email Alerts

More from Related TechTarget Sites