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,238 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,232 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,409 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,328 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,134 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,412 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,734 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,563 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,713 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,191 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,672 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,552 reads
Question of the Day

The RPO

By Steve Jones 2016/02/12 | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 744 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
432 7989 SSCertifiable  
2.
ALPESH.KARP
344 1242 Ten Centuries  
3.
Hugo Kornelis
311 7147 SSCertifiable  
4.
Orlando Colamatteo
297 7698 SSCertifiable  
5.
Rick.Cornell.SME
258 5302 SSCertifiable  
Latest forum posts