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

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

Auto-suggesting foreign keys and data model archaeology

If you can understand the data model then you can understand the intent of the application developers.  Read more...
By David Poole 2016/01/26 | Source: SQLServerCentral.com | Category: foreign key
Rating: |  Discuss |   Briefcase | 2,565 reads

Declarative SQL: Using CHECK() & DEFAULT

SQL is unusual is that data is not passively stored. Instead you use declarative SQL to specify the rules that underlie the data and its integrity. When used properly, constraints can avoid having to provide a lot of logic elsewhere. CHECK() and DEFAULT can do a lot to ensure that your data is correct  Read more...
By Additional Articles 2016/01/26 | Source: SimpleTalk | Category: check()
Rating: (not yet rated)  Rate this |   Briefcase | 3,845 reads

Crafting Your Resume

Today Steve Jones talks about how you can present yourself better within the confines of a resume.  Read more...
By Steve Jones 2016/01/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 146 reads

Backup File Inventory

Are you using Ola Hallengren's Maintenance Solution? Here's a Python script that helps you keep track of your backup file inventory.  Read more...
By Joel Askey 2016/01/25 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 1,930 reads

Microsoft IT: A Case Study on “Hekaton” against RPM

I/O latch can cause session delays that impact application performance. This white paper describes the procedures and common I/O latch issues when migrating to Hekaton in SQL Server 2014. It also includes challenges that occurred during the migration and the performance analysis at different stages.  Read more...
By Additional Articles 2016/01/25 | Source: Microsoft MSDN | Category: hekaton
Rating: (not yet rated)  Rate this |   Briefcase | 2,087 reads

The Market

This Friday Steve Jones asks about the market price for your skills. Do you know what it is?  Read more...
By Steve Jones 2016/01/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 310 reads

Create/write to an Excel 2007/2010 spreadsheet from an SSIS package

Excel spreadsheets are useful for distributing data generated by SQL Server. EPPlus is an open source .NET library that reads/writes Excel 2007/2010 files using the Open Office XML format (XLSX). It is a mature project, and plays well with SSIS.  Read more...
By Stan Kulp 2016/01/22 (first published: 2014/02/11) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 13,835 reads

Correct SQL Server TempDB Spills in Query Plans Caused by Outdated Statistics

Sergey Gigoyan looks at how to address the warning: Operator used tempdb to spill data during execution with spill level 1.  Read more...
By Additional Articles 2016/01/22 | Source: MSSQLTips.com | Category: tempdb
Rating: (not yet rated)  Rate this |   Briefcase | 3,313 reads

Scripting Environments in SSIS

Demo and script on how to script out SSIS Environments and their associated variables  Read more...
Rating: |  Discuss |   Briefcase | 4,405 reads

Microsoft Azure DocumentDB

Microsoft's DocumentDB is a late-entrant in the Document-oriented database field. However, it benefits from being designed from the start as a cloud service with a SQL-like language. It is intended for mobile and web applications. Its JSON document-notation is compatible with the integrated JavaScript language that drives its multi-document transaction processing via stored procedures, triggers and UDFs. Robert Sheldon investigates its SQL-like query language.  Read more...
By Additional Articles 2016/01/21 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,024 reads

Design a Better SQL Server Pricing Model

Today we have a guest editorial from Andy Warren that talks about SQL Server the no one's favorite topic: licensing.  Read more...
By Andy Warren 2016/01/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 139 reads

Stairway to Columnstore Indexes Level 6: Updating and Deleting Data in a Columnstore Index

This level looks in detail at what happens when we update or delete data from a clustered columnstore index, the impact it has on concurrent data access, and how without careful maintenance the efficiency of columnstore indexes can degrade over time.  Read more...
By Hugo Kornelis 2016/01/20 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,167 reads

Hard Data v Gut Feel

Data is more important than gut feel, or at least, Steve Jones thinks it should be more important. Today he talks about using data to support decisions.  Read more...
By Steve Jones 2016/01/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 223 reads

Network Load Testing Using iPerf

Tim Radney of SQLskills shows how to measure your network so you have more ammo to take to your network team when there is a performance issue.  Read more...
By Additional Articles 2016/01/20 | Source: SQLPerformance.com | Category: network load testing
Rating: (not yet rated)  Rate this |   Briefcase | 2,964 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 | 5,637 reads

Getting Started with Stretch Database Functionality in SQL Server 2016 - Part 2

Arshad Ali explains and demonstrates the impact of enabling the Stretch database feature on backup and restore operations. He also discusses ways to pause, resume, and disable this feature altogether when not needed.  Read more...
By Additional Articles 2016/01/19 | Source: Database Journal | Category: stretch database
Rating: (not yet rated)  Rate this |   Briefcase | 4,215 reads

The DBA Tax

Are you a DBA tax on your company? Or an asset that's worth the cost. Steve Jones talks about trying to be the latter and not the former.  Read more...
By Steve Jones 2016/01/19 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 437 reads

The Real World: Implementing Data Compression in SQL Server 2008 R2

Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008  Read more...
By Kenneth Igiri 2016/01/18 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 2,712 reads

Muting the Immutable

Phil Factor on dealing with "immutable" domain data during database development and deployment.  Read more...
By Phil Factor 2016/01/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 72 reads

Turn Out the Lights

Today we have a guest editorial from Andy Warren that looks at the costs associated with our behavior.  Read more...
By Andy Warren 2016/01/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 126 reads
<< Newer    Items 41 to 60 of 14455    Older >>