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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,853,240 DBAs, developers and SQL Server users

Rss
Headlines today   February 12, 2016

Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...  Read more...
By Dwain Camps 2016/02/12 (first published: 2014/04/07) | Source: SQLServerCentral.com | Category: sql like search
Rating: |  Discuss |   Briefcase | 35,284 reads

SQL Server System Views: The Basics

When maintaining or refactoring an unfamiliar database, you'll need a fast way to uncover all sorts of facts about the database, its tables, columns keys and indexes. SQL Server's plethora of system catalog views, INFORMATION_SCHEMA views, and dynamic management views contain all the metadata you need, but it isn't always obvious which views are best to use for which sort of information. Many of us could do with a simple explanation, and who better to provide one than Rob Sheldon?  Read more...
By Additional Articles 2016/02/12 | Source: SimpleTalk | Category: system views
Rating: (not yet rated)  Rate this |   Briefcase | 2,513 reads

Moved to the Cloud?

Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.  Read more...
By Additional Articles 2016/02/12 | Source: Redgate | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,424 reads
Previous headlines

SSIS: Case sensitivity may expose issues with change deployment

Because SSIS is case sensitive, random VS_NEEDSNEWMETADATA errors on case-insensitive databases may indicate issues in your database change management & deployment process.  Read more...
Rating: |  Discuss |   Briefcase | 1,137 reads

SQL Server 2016 Row Level Security Block and Filter Predicates Example

Rajendra Gupta takes a look at the additional enhancements made to Row Level Security in SQL Server 2016 CTP 3.1 and explores the new features with examples.  Read more...
By Additional Articles 2016/02/11 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 1,443 reads

Redgate Cloud Research

Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.  Read more...
By Additional Articles 2016/02/11 | Source: Redgate | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,772 reads

Foreign Key Indexes and Binding

Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes.  Read more...
By Steve Hood 2016/02/10 | Source: SQLServerCentral.com | Category: foreign keys
Rating: |  Discuss |   Briefcase | 2,569 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2016/02/10 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 49,721 reads

Cloud Adoption Survey

Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.  Read more...
By Additional Articles 2016/02/10 | Source: Redgate | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,234 reads

Enabling TDE on Databases in an AlwaysOn Scenario

Enabling Transparent Data Encryption on Databases in Always On Scenario  Read more...
By Sanjiv Doshetty 2016/02/09 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 1,677 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Are SQL Server 2014 Table Variables Different From Temporary Tables?

What are the Table Variables in SQL Server? In our previous blog we have discussed How to find free space In...  Read more...
By zorastalin 2016/02/12 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,591 reads
Question of the Day

The RPO

By Steve Jones 2016/02/12 | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 752 reads

I have the following backup schedule for my SALES instance.


Full backup - Every Monday, 11pm
Differential backup - every night at 8pm
Transaction log backups - Every 15 minutes, from midnight on.
...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Ed Wagner
435 7993 SSCertifiable  
2.
ALPESH.KARP
344 1242 Ten Centuries  
3.
Hugo Kornelis
311 7147 SSCertifiable  
4.
Orlando Colamatteo
294 7700 SSCertifiable  
5.
Rick.Cornell.SME
258 5302 SSCertifiable  
Latest forum posts