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 MoreThis post will be fore the purpose of documenting all my findings regarding Collations in SQL Server, including changing the collation on an…
Read MoreBelow are some best practices known within the SQL Server database community use when designing tables. 1. All data columns should be properly…
Read MoreDatabase 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 – 1769
Read MoreThe easiest way to bulk-copy all SQL Agent jobs to a new server is to follow these steps 1. Load SSMS and connect…
Read MoreA good blog-post on joins from a visual aspect. Nicely done. A Visual Explanation of SQL Joins Views – 2130
Read MoreOften you will need to add or move the tempDB data files, either to match the core count (up to 8 as best…
Read MoreI recently had to run a query for one of our developers where the script was inserting a number of rows. All went…
Read MorePASS 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 MorePASS 2015 10-27-30 Seattle WA Pre-Con Day 2 – SQL Server Internals – The Practical Angle Dmitri Korotkevitch Data Storage 101 Data Pages…
Read MoreThe 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