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

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

T-SQL Window Function Speed Phreakery: The FIFO Stock Inventory Problem

Sometimes, in the quest for raw SQL performance, you are forced to sacrifice legibility and maintainability of your code, unless you then document your code lavishly. Phil Factor's SQL Speed Phreak challenge produced some memorable code, but can SQL features introduced since then help to produce code that performs as well and is also easy to understand? Kathi Kellenberger investigates.  Read more...
By Additional Articles 2016/04/15 | Source: SimpleTalk | Category: fifo
Rating:  Rate this |   Briefcase | 5,245 reads

Successful Projects

What makes a successful software project? Steve Jones has some thoughts.  Read more...
By Steve Jones 2016/04/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 95 reads

Data Mining Part 37: The Data Mining query transformation task

This new chapter will show you how to work with the SSIS Data Mining Query Transformation Task  Read more...
By Daniel Calbimonte 2016/04/14 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 951 reads

What is Code Coverage For?

Code coverage is a practice that goes hand in hand with automated testing, reporting the percentage of your code that has been exercised during a test run. Ed Elliott and Redgate have partnered to make a code coverage tool available for SQL Server, both free and open source. SQL Cover measures the coverage of your SQL Server stored procedures and functions. It has built-in support for the popular tSQLt unit testing framework, but can also be used alongside any automated testing framework of your choosing. Find out more in this blog post.  Read more...
By Additional Articles 2016/04/14 | Category: code coverage
Rating: (not yet rated)  Rate this |   Briefcase | 4,135 reads

TEMPDB Enhancements in SQL Server 2016

TEMPDB Enhancements in SQL Server 2016 - By default enforced to follow best practices.  Read more...
By Dharmendra Keshari 2016/04/13 | Source: SQLServerCentral.com | Category: tempdb
Rating: |  Discuss |   Briefcase | 4,067 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2016/04/13 (first published: 2013/07/24) | Source: Redgate | Category: hardware
Rating:  Rate this |   Briefcase | 54,867 reads

Build a POC

One way to tackle a new technology is with a proof of concept.  Read more...
By Steve Jones 2016/04/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 93 reads

Changes to a Writable Partition May Fail Unexpectedly

Paul White shows how an update may fail when a partition has some data on a read-only filegroup, and explains several workarounds.  Read more...
By Additional Articles 2016/04/13 | Source: SQLPerformance.com | Category: partitioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,057 reads

Splitting Strings in SQL Server 2016

Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods  Read more...
By Wayne Sheffield 2016/04/12 | Source: SQLServerCentral.com | Category: string_split
Rating: |  Discuss |   Briefcase | 3,362 reads

A Welcoming Conference

It's almost time for SQLBits, Steve's favorite conference.  Read more...
By Steve Jones 2016/04/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 87 reads

How to fix SQL Server deadlocks with monitoring

Learn about deadlocks and how you might better troubleshoot the issues involved.  Read more...
By Additional Articles 2016/04/12 | Source: Redgate | Category: sql monitor
Rating:  Rate this |   Briefcase | 4,591 reads

The 2015/2016 Simple-Talk Awards: Winners Announced

The 2015/16 Simple-Talk Awards have concluded, the votes have been counted and recounted, and the winners have now been announced.  Read more...
By Additional Articles 2016/04/12 | Source: SimpleTalk | Category: simple-talk
Rating: (not yet rated)  Rate this |   Briefcase | 2,109 reads

NonClustered Index Structure

Learn how the clustered index keys affect the non clustered index structure.  Read more...
By Mayank Shukla 2016/04/11 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,988 reads

The Data Dewey Decimal System

Steve Jones looks at the idea of cataloging our data sets in order to make it easier for  Read more...
By Steve Jones 2016/04/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 93 reads

Hunting in Packs

Waterfall is the practice most destructive to developer productivity? Nonsense, according to Phil Factor. Lack of basic team coordination skills comes much higher in the list.  Read more...
By Phil Factor 2016/04/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 96 reads

Getting Started with Temporal Table in SQL Server 2016 – Part 1

With the new temporal table feature, SQL Server 2016 internally manages two tables: a base table, which contains the latest data all the time, and a history table, which contains a history of all of the changes. Arshad Ali looks at the new feature, how it works, and how to either create a new table with this feature or enable it for an existing table.  Read more...
By Additional Articles 2016/04/11 | Source: Database Journal | Category: temporal tables
Rating: (not yet rated)  Rate this |   Briefcase | 3,532 reads

Finding Special Characters within Character Strings

Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.  Read more...
By Michael Morin 2016/04/08 (first published: 2014/08/19) | Source: SQLServerCentral.com | Category: special characters
Rating: |  Discuss |   Briefcase | 13,296 reads

The Comeback of Migrations-Based Deployments

With database deployments, not all script-based processes are equal. Some use change scripts in a free-and-easy way, and some, which are normally called ‘migrations-based approaches’, have more discipline around them. In this article, Redgate Product Manager Elizabeth Ayer covers ‘migrations’, and shows some of the benefits that have come with new tooling which is specifically designed to assist the change script processes.  Read more...
By Additional Articles 2016/04/08 | Source: SimpleTalk | Category: migrations-based
Rating: (not yet rated)  Rate this |   Briefcase | 2,783 reads

How Much Can You Learn?

This Friday Steve Jones wonders about the upper limits for what you may learn in a year.  Read more...
By Steve Jones 2016/04/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 123 reads

Naming Is Hard

Naming objects and variables in software can create contention in a team. While there are good conventions and standards, ultimately a team just needs to agree on something.  Read more...
By Steve Jones 2016/04/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 103 reads
<< Newer    Items 41 to 60 of 14677    Older >>