SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 41 to 60 of 16552    Older >>
 

Adaptive Query Processing – Interleaved Execution

Interleaved Execution allows SQL Server's query optimizer to get accurate cardinality estimates in places where it couldn't before.  Read more...
Rating: |  Discuss |   Briefcase | 594 reads

Mobile Report Publisher – Dashboards Everywhere

The new feature, Mobile Reports, was added to SSRS in 2016. It provides the ability to create attractive and useful dashboards that can run on devices and most browsers. Robert Cain shows you how to get started building Mobile Reports with the Mobile Report Publisher.  Read more...
By Additional Articles 2018/02/08 | Source: SimpleTalk | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 3,013 reads

Introducing database automation with the SQL Toolbelt

In this post, Mary Robbins explains how Absa bank improved development efficiency and minimized risk by implementing SQL Toolbelt.  Read more...
By 2018/02/08 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,383 reads

Hint Word Search

This is a word search for most (but not all) of the hints available in T-SQL.  Read more...
By Kenneth Fisher 2018/02/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

Stairway to Advanced T-SQL Level 6: Creating Rows Of Data Using The UNPIVOT Operator

The UNPIVOT operator does just the opposite of the PIVOT operator, which we looked at in the previous level. By using the PIVOT operator we can take multiple rows of data and create as single row as output. The UNPIVOT operator will take values from a single row and will create multiple rows. Microsoft introduced the UNPIVOT operator when they rolled out SQL Server 2005. In this level I will be showing you different examples of how to use the UNPIVOT operator.  Read more...
By Gregory Larsen 2018/02/07 (first published: 2015/06/24) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,011 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2018/02/07 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 101,304 reads

Heaps, Deletes, and Optimistic Isolation Levels

Erik shows that heaps have even more drawbacks under optimistic concurrency.  Read more...
By Additional Articles 2018/02/07 | Source: Brent Ozar Unlimited Blog | Category: heaps
Rating: (not yet rated)  Rate this |   Briefcase | 2,536 reads

How to use the SQL Prompt snippet placeholders for selecting and copying text

There are four SQL Prompt snippet placeholders that are all about selection and copying of text. These placeholders are very handy if, for example, you have two blocks of code that need to be part of a snippet. One part you hold on the clipboard, and the other part is a block of snippet text, selected using the $SELECTEDTEXT$ placeholder.  Read more...
By 2018/02/07 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,019 reads

SSIS Package with a Derived Column

I created this article to demonstrate the use of derived columns inside a ForEachLoop Container for a client requirement for some auxiliary marketing reports. I found the Data Conversion tool useful to escape the problem of mismatched data types, which is an issue with versions of Microsoft SSIS.  Read more...
By Thomas Stricker 2018/02/06 | Source: SQLServerCentral.com | Category: derived columns
Rating: |  Discuss |   Briefcase | 673 reads

SQL Server Replication for Temporal Tables

In this tip, Ameena Lalani looks at how you can setup replication to include temporal history data.  Read more...
By 2018/02/06 | Source: MSSQLTips.com | Category: replication
Rating: (not yet rated)  Rate this |   Briefcase | 2,128 reads

Influence the Program

You have the opportunity to influence the makeup of the conference agenda for the PASS Summit  Read more...
By Steve Jones 2018/02/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 31 reads

Building a Custom Blocked Process Report

Blocking in SQL Server is normal behavior, but excessive blocking can lead to many complaints and is a symptom of poor performance. SQL Server contains a vast amount of information that can help when troubleshooting performance issues like blocking, but understanding and gathering that information when you need it is a lot of work. Darko Martinovic explains his solution for a custom blocking report.  Read more...
By Additional Articles 2018/02/06 | Source: SimpleTalk | Category: monitoring
Rating:  Rate this |   Briefcase | 2,814 reads

Realistic, simulated data for testing, development and prototypes

This article proposes a scheme for using Redgate SQL Data Generator (SDG) as a ‘data generation and translation’ tool. We generate the data using a free copy of SQL Server Express, and then use standard bulk copy mechanisms to translate it to various formats, then distribute it out to the different data technologies and platforms that require a copy of the data. The tool becomes a mechanism to support ‘polyglot persistence’.  Read more...
By 2018/02/06 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,387 reads

Configure Read Only Routing

The advantage of Setting the readable secondary as Read-Intent Only will allow the secondary server to serve the read-only workload only if the connection string of the application contains Application Intent=Readonly parameter.   Read more...
By Ganapathi varma Chekuri 2018/02/05 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 570 reads

Add a SQL Server Database to an Existing Always On Availability Group

In this tip, Manvendra Singh will cover how to add another database to an existing Always On Availability Group.  Read more...
By Additional Articles 2018/02/05 | Source: MSSQLTips.com | Category: availability group (ag)
Rating: (not yet rated)  Rate this |   Briefcase | 2,016 reads

Finding the Right Data

Big Data hasn't been in the news, perhaps because more organizations are realizing they need the right data.  Read more...
By Steve Jones 2018/02/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

We Do Need To Upgrade

Security issues in older systems are going to be a problem.  Read more...
By Steve Jones 2018/02/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

Bringing DevOps to the database. Part 1: Version control

Continuous delivery, continuous integration, automated release management – the phrases alone are enough to make the talk about DevOps for the database sound more complicated than it actually is - this post explains that the key is to start small.  Read more...
By 2018/02/05 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,029 reads

Liberating the DBA from SQL Authentication with AD Groups

It's 15 years after the beginning of the century. Time to eliminate the security exposure of SQL logins, and implement integrated security. Active Directory Groups make this easy for the DBA.  Read more...
By John F. Tamburo 2018/02/02 (first published: 2015/12/21) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 6,200 reads

Bad Days

This Friday Steve Jones wants you to look back and cringe a bit. Share with the rest of the community what a bad day was for you and see if it was really as bad as you think.  Read more...
By Steve Jones 2018/02/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 230 reads
<< Newer    Items 41 to 60 of 16552    Older >>