t-sql
SQL 102 — DROP DATABASE
While deleting a database is a fairly rare occurrence, I'm teaching you now, since it's a pretty easy task to learn. Before teaching you this, you do know rule
Latest
SQL102
DROP and Truncate
It's only a matter of time before you need to clean up after yourself in Microsoft SQL. You'll have to get rid of an index, or a table, or maybe even a whole
SQL102
SQL 102 — CREATE DATABASE
The most fundamental task you'll have to learn to do as a Database Administrator is to create a database. Please remember it's probably a good idea to make
microsoft sql
Alias
Within a few days of using SQL, you're going to start wondering if there is a way to speed up your code writing. The good news is you can do that with Aliases.
t-sql
ALTER TABLE
After you've spent time designing the perfect table, someone is going to come along and ask you a question that will lead you to changing your table. It can be
t-sql
SQL 201-SELECT INTO
I've already shown you how to create a table, and how to INSERT data into that table. But did you know you can do both in one statement? The SELECT INTO
book reviews
Pro SQL Server 2005 Replication
I found this book to be very useful, but even 1000 pages is not enough to cover everything you need to know about replication. This book is great for
microsoft sql
SQL 201 – Locking Hints
If you've spent any time looking at another programmers code, I'm sure you've see something like this: SELECT columnName FROM tableName (NOLOCK) I'm sure you
t-sql
SQL 102 – Foreign Keys
In the simplest terms a Foreign Key in one table refers to the Primary Key of another table. Let's go back to our demo tables products and productSales. -
personal
Merry Christmas!
I just wanted to thank you all for a wonderful year. I've really enjoyed pushing myself to produce a post a week this year. It was challenging, but fun. I'd
SQL201
Optimizing Queries
This is the first article in a never ending series of articles on how to optimize your queries. Honestly, this is a topic I'm still learning volumes about. I
SQL102
SQL 201 – Statistics
Microsoft SQL Servers collect statistical information on indexes and column data stored in each database. These statistics are used by the query optimizer to