Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

   Items 1 to 20 of 12629    Older >>
 

Unexpected View Performance

Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer.  Read more...
By Thom Bolin 2014/04/18 (first published: 2011/01/11) | Source: SQLServerCentral.com | Category: views
Rating: |  Discuss |   Briefcase | 10,157 reads

Advice for Newcomers

If you could look back on your career, is there some advice you wish you had? Is there something you'd tell people considering your job as a career? Let us know this Friday.  Read more...
By Steve Jones 2014/04/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 46 reads

SQL Server Performance Tuning Using Wait Statistics: A Beginner's Guide

This beginner's guide to Wait Stats by Jonathan Kehayias and Erin Stellato is a free PDF download brought to you by SQL Skills and Simple-Talk.  Read more...
By Additional Articles 2014/04/18 | Source: SimpleTalk | Category: wait statistics
Rating: (not yet rated)  Rate this |   Briefcase | 1,985 reads

SQL Saturday #305: Dallas, BA Edition

Please join us on Saturday, May 3rd, 2014, as both business analysts and IT professionals come to learn and network with experts for the first SQLSaturday Business Analytics edition. Please register while space is available  Read more...
By Press Release 2014/04/18 | Source: SQL Saturday | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 108 reads

One Database to Rule Them All

Twitter is working on a new database that can handle unstructured as well as structured data well. Is this a competitor for SQL Server?  Read more...
By Steve Jones 2014/04/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 114 reads

XML Schema validation in SQL Server

An introduction to the XML Schema Collection and XML validation.  Read more...
By Eirikur Eiriksson 2014/04/17 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 2,585 reads

Explaining the Calculations of Probability and Importance for Complex Association Rules in SSAS

The output from the Association Rules data mining model in SSAS 2012 can be difficult to understand, especially when the generated rules become more complex. In this tip we go through an example to provide a better understanding.  Read more...
By Additional Articles 2014/04/17 | Source: MSSQLTips.com | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 1,090 reads

Call for participants in deployment process research

The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers for participants.  Read more...
By Press Release 2014/04/17 | Source: SimpleTalk | Category: research
Rating: (not yet rated)  Rate this |   Briefcase | 1,315 reads

Stairway to SQL Server Agent - Level 9: Understanding Jobs and Security

Security is a confusing topic to many, especially when it comes to understanding what rights are needed to monitor and use SQL Server Agent. This article will examine the rights and roles used for SQL Server Agent, as well as the security context requirements for jobs.  Read more...
By Richard Waymire 2014/04/16 (first published: 2012/01/11) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,620 reads

Byte Me: For Every Lock

Database Security is serious business.  Read more...
By Bob Lang 2014/04/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 317 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 2014/04/16 (first published: 2013/07/24) | Source: Red-Gate | Category: hardware
Rating:  Rate this |   Briefcase | 14,135 reads

SQL Server 2014 In-Memory OLTP Dynamic Management Views

Greg Larsen provides a quick primer of the new Dynamic Management Views (DMVs) to help you better understand and manage your In-Memory OLTP tables and your Instances that support In-Memory OLTP tables.  Read more...
By Additional Articles 2014/04/16 | Source: Database Journal | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 2,021 reads

Doing What It Takes To Get The Job Done

It can be a point of pride in technology that we work ourselves to get the job done. Is that a good thing? Andy Warren has a few thoughts.  Read more...
By Andy Warren 2014/04/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 145 reads

Why every SQL Server installation should be a cluster

In this article, I’ll attempt to “convince” you that every SQL Server you put into production should be a SQL Server Failover Cluster Instance (FCI).  Read more...
By Francis Apel 2014/04/15 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 7,856 reads

SQL Server Backup Crib Sheet

Robyn Page's crib sheet was a Simple-Talk classic, providing a terse but thorough roadmap of all of the important SQL Server backup-related considerations. It returns, newly revised for SQL Server 2014.  Read more...
By Additional Articles 2014/04/15 | Source: SimpleTalk | Category: backup
Rating:  Rate this |   Briefcase | 3,981 reads

SQL Monitor Custom Metric: Table size (MB)

This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes. If a database is growing quickly within a short time and you suspect a certain table is responsible, you can monitor its actual size, or the rate at which it is increasing.  Read more...
By Press Release 2014/04/15 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 763 reads

Big Data - Cost of acquiring skills

If your companies first foray into Big Data project starts with a big cheque then you are doing it wrong!  Read more...
By David Poole 2014/04/14 | Source: SQLServerCentral.com | Category: big data
Rating: (not yet rated) |  Discuss |   Briefcase | 189 reads

SQL Server 2014 Key Features and Enhancements

SQL Server 2014 comes with a set of enhancements as compared to its processors that brings a lot of business benefits to the applications in OLTP and OLAP environments. This articles highlights a few key enhancements that are built into the product.  Read more...
By Suresh Yaram 2014/04/14 | Source: SQLServerCentral.com | Category: in-memory option
Rating: |  Discuss |   Briefcase | 9,467 reads

Call Me, Maybe

Rodney Landrum on his week of responding nicely to unsolicited sales calls.  Read more...
By Rodney Landrum 2014/04/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 77 reads

SQL Server Reporting Services Embedding .NET Code for Report Formatting and Error Handling

I want to embed code into my SQL Server Reporting Servers (SSRS) to allow special formatting for report output. How do I implement and deploy this code and what functionality can use this embedded code?  Read more...
By Additional Articles 2014/04/14 | Source: MSSQLTips.com | Category: error handling
Rating: (not yet rated)  Rate this |   Briefcase | 2,547 reads
   Items 1 to 20 of 12629    Older >>