sql

The DBA’s Rules — Rule #2

Rule #2: Have a tested Backup and Recovery Plan I'm sure no one out there isn't doing a backup on their database server at some interval compatible with the

t-sql

Beginning SQL Server 2005 Programming

I was looking for a good reference book to use in creating training lessons for the site. I have to say this book is great for that. Lucky for me, it's not as

sql

The DBA’s Rules

I don't know if you're a fan of NCIS, but for those of you who aren't let me give you a little back story. Gibbs is the leader of an investigative team and he

t-sql

Determine the Space Used by Tables

Eventually you'll be faced with running out of space on a SQL server. Usually, before you get more drive space, you're asked to find out if you can get rid of

t-sql

Inter-Database Queries

I've had this question come up a few times now. "How do I copy data from one database to another?" It's after getting a question like that, I explain fully

t-sql

SQL 201 — CREATE PROCEDURE

Now that you have the basics of SQL, I think it's time to learn something a bit more involved. If you need to accomplish a task within SQL you will run a series

microsoft sql

SQL101-Homework Assignment #6 Answer Key

Here are the answers for homework #6. Let me know if you have any questions! USE AdventureWorks GO 1. How many rows are there in Sales.SalesOrderHeader? SELECT

microsoft sql

SQL101-Homework Assignment #6

We're starting to cover some more difficult subjects in these homework problems. Please let me know if you need any help! 1. How many rows are there in Sales

t-sql

SQL 201 – CREATE TABLE

CREATE TABLE I've showed you how to get data out of a table, put data in, change it, and delete it. But I haven't showed you how to create your own table...

SQL101

SQL101-Homework Assignment #5 Answer Key

These answers have been updated to work with Adventureworks on 2008R2. 1. Write an UPDATE query that would set your middle name, for only your record by

SQL101

SQL101-Homework Assignment #5

Here's another set of questions for you to practice on. As always, if you have any questions, let me know and I'll help you. UPDATE 1. Write an UPDATE query

SQL101

SQL101-Homework Assignment #4 Answer Key

Here are my solutions updated to work with AdventureWorks on 2008R2. 1. Write a DELETE query that would remove a record from person.contact by contactID, pick a