Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Popular Content

Understanding the OVER clause

Having a solid knowledge of the window functions if vital to high performance T-SQL Code. The key to these functions is how the OVER clause is used. This article will dive into how to use the OVER clause.  Read more...
By Wayne Sheffield 2015/10/14 | Source: SQLServerCentral.com | Category: over clause
Rating: |  Discuss |   Briefcase | 17,378 reads

Datetime vs. Datetime2

Read a short comparison of datetime and datetime2 types. Learn about their structure, as well as the advantages and disadvantages of each.  Read more...
By Robert Hartmann 2016/01/05 | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 12,763 reads

DBA Salary Survey

We're running a salary survey to find out what database professionals earn in the real world. The survey is completely anonymous, and the results will be published here in a few weeks time.  Read more...
By 2016/08/11 | Source: SQLServerCentral.com
Rating:  Rate this |   Briefcase | 3,634 reads

The Top 4 Job Tasks DBAs Forget

It’s easy to get caught up in daily incidents, tickets, and special projects. Like a good scout, though, a core task in a DBA’s job is to be prepared.  Read more...
Rating:  Rate this |   Briefcase | 6,876 reads

SQL Server CROSS APPLY and OUTER APPLY

Arshad Ali demonstrates what the APPLY operator is, how it differs from regular JOINs, and what its applications are.  Read more...
By Additional Articles 2016/02/17 | Source: MSSQLTips.com | Category: cross apply
Rating:  Rate this |   Briefcase | 6,842 reads

Planning for a Successful Database Lifecycle

Although it is well-known that the best efforts of a development team can be derailed by mistakes in the architecture, design and general governance of a development project, few attempts have been made to describe what needs to be done to increase the chances of success in the development of a database application. William Brewer steps into the breach to itemise what a delivery team needs to succeed.  Read more...
Rating:  Rate this |   Briefcase | 4,219 reads

Database Lifecycle Management: Deployment and Release

So often, the unexpected delays in delivering database code are more likely to happen after the developers initiate the release process. The necessary checks and tests can turn up surprises: The handover process can expose deficiencies. With good teamwork, planning and forethought, though, the process can be made almost painless.  Read more...
By Additional Articles 2016/08/05 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 3,348 reads

Using LAST_VALUE

When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!  Read more...
By Kathi Kellenberger 2016/06/03 (first published: 2015/04/14) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,062 reads

Automating Your SQL Server Best Practice Reports: The Document

If you're making a report from table-based data, an MS Word document is often a good option. In the second part of his introduction to SQL Server best-practice monitoring, Laerte Junior shows how to use PowerShell scripts to create a Word-based report with colour-coded alerts where there are problems or best practices aren't being followed.  Read more...
By Additional Articles 2015/11/12 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 8,021 reads

Questions About PowerShell Basics That You Were Too Shy To Ask

Developers who are already familiar with application languages will be baffled by different aspects of PowerShell to the beginner to programming. Laerte recalls his initial struggles with PowerShell and answers those questions he wished he'd found quick answers to.  Read more...
By Additional Articles 2016/04/29 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 4,300 reads

Insert Stored Procedure Results Into New Table Without Using OPENQUERY

OPENQUERY arrives with a lot of baggage. Try this alternative technique to inserting stored procedure results into a new table.  Read more...
By Orlando Colamatteo 2016/03/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,679 reads

Performance Surprises and Assumptions : SET NOCOUNT ON

Aaron Bertrand (@AaronBertrand) revisits the impact that eliminating DONE_IN_PROC messages using SET NOCOUNT ON may or may not have on query performance  Read more...
Rating:  Rate this |   Briefcase | 5,205 reads

SQL Server Memory

SQL Server Memory in Task Manager - Should I be Worried?  Read more...
By Ginger Keys 2015/12/14 | Source: SQLServerCentral.com | Category: memory
Rating: |  Discuss |   Briefcase | 7,556 reads

Dynamically Query a 100 Million Row Table-Efficiently

This article describes methods of creating dynamic queries without the use of dynamic SQL to efficiently access large tables.  Read more...
By Gary Strange 2016/05/27 (first published: 2015/02/24) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 24,748 reads

Using APPLY to make your queries DRYer

Using the APPLY operator to reduce repetition and make queries DRYer.  Read more...
By Gerald Britton 2016/06/10 (first published: 2015/04/02) | Source: SQLServerCentral.com | Category: queries
Rating: |  Discuss |   Briefcase | 20,220 reads

The Internals of WITH ENCRYPTION

Paul White discusses the internals of SQL Server's WITH ENCRYPTION clause, and explains why it is not as safe as you might think.  Read more...
By Additional Articles 2016/06/14 | Source: SQLPerformance.com | Category: with encryption
Rating:  Rate this |   Briefcase | 3,596 reads

Number of Rows Read / Actual Rows Read warnings in Plan Explorer

Rob Farley looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.  Read more...
By Additional Articles 2016/07/20 | Source: SQLPerformance.com | Category: query plans
Rating:  Rate this |   Briefcase | 2,771 reads

Introducing the Set-based Loop

Set-based programming doesn’t mean “no loops” or a single statement. Finding out the best ways to traverse a full hierarchy.  Read more...
By Luis Cazares 2015/07/27 | Source: SQLServerCentral.com | Category: set-based loop
Rating: |  Discuss |   Briefcase | 13,773 reads

Database Version Control

By placing under source control everything we need to describe any version of a database, we make it much easier to achieve consistent database builds and releases, to find out who made which changes and why, and to access all database support materials. Matthew Skelton explains how to make sure your version control system fully supports all phases of the database lifecycle, from governance, development, delivery and through to operations.  Read more...
By Additional Articles 2016/04/21 | Source: SimpleTalk | Category: version control
Rating:  Rate this |   Briefcase | 3,810 reads

Stairway to U-SQL Level 1: Introduction to U-SQL and Azure Data Lakes

An introductory guide to querying files in Azure Data Lakes using Microsoft's U-SQL language.  Read more...
By Mike McQuillan 2016/06/15 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 3,731 reads