About Collations in SQL Server
This post will be fore the purpose of documenting all my findings regarding Collations in SQL Server, including changing the collation on an…
Read MoreCategory: T-SQL
Some database design guidelines and best practices
Below are some best practices known within the SQL Server database community use when designing tables. 1. All data columns should be properly…
Read More
SQL documentation tools and permissions required
Database documentation tools like Devarts’ dbDocumenter will require, at a minimum, VIEW DEFINITION rights to the login:
|
1 2 3 4 |
USE myDatabase GO GRANT VIEW DEFINITION TO [DOMAIN\MyADGroup] |
Views – 1040
Read More
Bulk-copy SQL Server Agent jobs to new server
The easiest way to bulk-copy all SQL Agent jobs to a new server is to follow these steps 1. Load SSMS and connect…
Read More
A Visual Explanation of SQL Joins
A good blog-post on joins from a visual aspect. Nicely done. A Visual Explanation of SQL Joins Views – 1614
Read More
Moving the TempDB database to a new drive
Often you will need to add or move the tempDB data files, either to match the core count (up to 8 as best…
Read More
Resolving “Cannot resolve collation conflict for equal to operation”
I recently had to run a query for one of our developers where the script was inserting a number of rows. All went…
Read More
PASS 2015 – Seattle WA – Day 3
PASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…
Read More
PASS 2015 – Seattle WA – Pre-Con Day 2 – Dmitri Korotkevitch
PASS 2015 10-27-30 Seattle WA Pre-Con Day 2 – SQL Server Internals – The Practical Angle Dmitri Korotkevitch Data Storage 101 Data Pages…
Read More
T-SQL Querying and Query Processing Order
The order in which we write T-SQL queries happen in this order:
|
1 2 3 4 5 6 |
SELECT FROM WHERE GROUP BY HAVING ORDER BY |
however, the order the Query Processor on SQL Server processes…
Read More