sql
The DBA’s Rules — Rules 3 and 4
In previous posts I shared with you my rules for who does and doesn't have access to sa, and keeping your data safe by having tested backup and restore
Latest
t-sql
TOP PERCENT
We have a multi-threaded process that grabs it's fair share records and then processes them. It basically looks at the total number of records to process, and
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