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 | 16,582 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,645 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,535 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,489 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 | 7,707 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,414 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 | 4,984 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,426 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 | 3,950 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,717 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 2015/04/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 17,326 reads

How to get Database Design Horribly Wrong

Database Design is one of those tasks where you have to carefully get all the major aspects right. If you mess-up just one of these, it can all go horribly wrong. So what are these aspects that can ruin database design, and how can you get them right? Robert Sheldon explains.  Read more...
By Additional Articles 2015/03/19 | Source: SimpleTalk | Category: database design
Rating:  Rate this |   Briefcase | 16,024 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,465 reads

Time and Space: How to Monitor Drive Space in SQL Server

How to monitor drive space in T-SQL and calculate when your drives will run out of space.  Read more...
By Ed Wagner 2016/01/19 | Source: SQLServerCentral.com | Category: drive space
Rating: |  Discuss |   Briefcase | 6,293 reads

Why Scalar Functions Can Be Costly

Scalar user defined functions can be costly in more ways than you know. Watch Mickey Stuewe show the hidden costs of using them incorrectly.  Read more...
By Mickey Stuewe 2016/01/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,359 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 | 22,239 reads

Analysing Sales Patterns: R + SQL Server

We show how to use RevolutionR to analyse & visualise purchasing behaviours in AdventureWorksDW2012.  Read more...
By Nick Burns 2015/12/15 | Source: SQLServerCentral.com | Category: revolutionr
Rating: |  Discuss |   Briefcase | 5,960 reads

3 Things I Wish I Knew When I Started Using Entity Framework

Coming from a SQL developer background these few inner workings of Entity Framework caught me by surprise.  Read more...
By Bert Wagner 2016/05/17 | Source: SQLServerCentral.com | Category: entity framework
Rating: |  Discuss |   Briefcase | 3,283 reads

How to Avoid Conditional JOINs in T-SQL

Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within the query might be. The 'conditional join' can be executed, but at great cost. As always, it is much better to sit back and restate the problem in a set-based way - Dwain Camps explains.   Read more...
By Additional Articles 2015/10/02 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 7,035 reads

Creating a Date Dimension in a Tabular Model

As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either runs in-memory or in DirectQuery mode. The in-memory analytics engine allows the users of Excel or Power View to base reports on tabular model objects. Having shown how to handle date-based information using the Multi-dimensional model, Dennes now turns his attention on the in-memory tabular model.  Read more...
By Additional Articles 2016/03/31 | Source: SimpleTalk | Category: tabular model
Rating:  Rate this |   Briefcase | 3,507 reads