Statistics keep track of our data and will tell SQL Server how to make the best optimization decisions. Knowing how they work can make understanding query and performance problems much easier!
2014-06-09
5,627 reads
In this tip, we will demonstrate the installation of SQL Server 2014 on a notebook. While processing large amounts of data on a system like this might not be feasible, one can still learn how to configure and use the features of SQL Server 2014.
2014-06-09
3,879 reads
A simple problem that can become complex in T-SQL. How do you find the rows that match 2 conditions, but not a third, in an efficient manner. MVP Jeff Moden gives us a solution.
2014-06-06 (first published: 2012-03-29)
41,667 reads
Although many of the important tasks a DBA has to perform should be done 'by hand', keying in commands or using SSMS, the canny DBA with a heavy workload will always have an eye to automating routine tasks wherever possible, or using a tool.
2014-06-06
5,011 reads
Are all RDBMS heading towards "The Cloud"? Is this something we DBAs and consultants should be doing for our client?
2014-06-05
101 reads
You have been asked to deploy a brand new SQL Server instance. Your management asks you to come up with the best balance of availability, performance and cost for SQL Server. Richard Vantrease has some recommendations.
2014-06-05
4,676 reads
Tthe term DBA is too broad and we should strive to institute more granular terms.
2014-06-04
237 reads
Join SQL Server MVP Grant Fritchey and other SQL Server professionals for a free day of training and networking at SQL Saturday Louisville, June 21. This is a free event, however there are also two paid-for precons available, run by Grant Fritchey and David Fackler. Register for SQL Sat while space is available.
2014-06-04
1,577 reads
SQL Server User-Defined Functions are good to use in most circumstances, but there just a few questions that rarely get asked on the forums. It's a shame, because the answers to them tend to clear up some ingrained misconceptions about functions that can lead to problems, particularly with locking and performance
2014-06-04
7,408 reads
Lowering the bar for entry does not mean lowering the bar for quality. New to SQL Server? Find out where to start.
2014-06-03
371 reads
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
Comments posted to this topic are about the item The Max PK Length
Comments posted to this topic are about the item My experience using the GitHub...
Comments posted to this topic are about the item The Microsoft SQL Year in...
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers