Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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: | Category: over clause
Rating: |  Discuss |   Briefcase | 14,119 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: | Category: set-based loop
Rating: |  Discuss |   Briefcase | 13,180 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 | 6,487 reads


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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 16,728 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 | 15,313 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 2015/02/24 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 19,402 reads

Using APPLY to make your queries DRYer

Using the APPLY operator to reduce repetition and make queries DRYer.  Read more...
By Gerald Britton 2015/04/02 | Source: | Category: queries
Rating: |  Discuss |   Briefcase | 14,953 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 | 6,289 reads

Visualize the timeline of your SQL jobs using Google graph and email

Generate an HTML page with the timeline of your SQL jobs using Google graph and sp_send_dbmail  Read more...
By Theo Ekelmans 2015/07/28 | Source: | Category: jobs
Rating: |  Discuss |   Briefcase | 9,083 reads

Level 2 - The Ideal SQL Server Virtual Machine Architecture

In Level 2 of the Stairway to SQL Server Virtualization, we examine the ideal VM configuration from a standpoint of the various resources involved.  Read more...
By David Klee 2015/05/13 | Source: | Category: virtualization
Rating: |  Discuss |   Briefcase | 11,561 reads


This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.  Read more...
By Ramya Makam 2015/06/09 | Source: | Category: performance and tuning
Rating: |  Discuss |   Briefcase | 14,191 reads

Developer-Tester Relationships

In a development team, there are times when the relationships between developers and testers can become strained. How can you turn this potential conflict into something more positive? Is it part of the skill of team-working to find ways of avoiding friction, or should one blame a system that relies on good social skills to work well?  Read more...
By Additional Articles 2015/05/22 | Source: SimpleTalk | Category: soft skills
Rating:  Rate this |   Briefcase | 9,660 reads

PowerShell Tool Time: Our First Toolbox

Learn how to begin assembling your functions and code into modules you can easily call from any session.  Read more...
By Mike Fal 2015/10/28 | Source: | Category: powershell tool time
Rating: |  Discuss |   Briefcase | 5,408 reads

Wildcard Searches

Using wildcard to find patterns in strings going from the basics to some more complicated conditions.  Read more...
By Luis Cazares 2015/09/29 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,250 reads

SSIS Package documentor

Read and document multiple SSIS packages in an Excel file. The document can be used to do further code analysis.   Read more...
Rating: |  Discuss |   Briefcase | 8,922 reads

Code Comparison for SQL Server vs. MariaDB

Daniel Calbimonte has written a code comparison for MariaDB vs. SQL Server as it pertains to how to comment, how to create functions and procedures with parameters, how to store query results in a text file, how to show the top n rows in a query, how to use loops, and more.  Read more...
By Additional Articles 2015/02/19 | Source: | Category: mariadb
Rating:  Rate this |   Briefcase | 12,217 reads

Learning SQL Server 2016

Here is a reference that lets you take a quick look at the new features in SQL Server 2016 and dig into the various items with a collection of links we'll maintain.  Read more...
By Site Owners 2015/06/22 | Source: | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 7,683 reads

A Single-Parameter Date Range in SQL Server Reporting Services

Many reports you will generate in SSRS will need to report within date ranges, and most of those will need a date range parameter. Here's an way to make an easy-to-use date range parameter.  Read more...
By John F. Tamburo 2015/11/18 | Source: | Category: ssrs
Rating: |  Discuss |   Briefcase | 5,514 reads

How to Get SQL Server Security Horribly Wrong

It is no good doing some or most of the aspects of SQL Server security right. You have to get them all right, because any effective penetration of your security is likely to spell disaster. If you fail in any of the ways that Robert Sheldon lists and describes, then you can't assume that your data is secure, and things are likely to go horribly wrong.  Read more...
By Additional Articles 2015/05/13 | Source: SimpleTalk | Category: security
Rating:  Rate this |   Briefcase | 8,553 reads

The Internet of Things: A New World Order?

Was the marketing hook 'The Internet of Things' conjured up before the technical definition? Are we being persuaded to spend money on fending off yet another fantasy tsunami of data? Already, we have televisions that listen to, and report, your conversations; so are we facing the Science Fiction future of gadgets that report where you go, who you visit and what medications you take? As Robert Sheldon says; "It's big, almost too big to get your arms around".  Read more...
By Additional Articles 2015/04/10 | Source: SimpleTalk | Category: iot
Rating:  Rate this |   Briefcase | 10,588 reads