Here it is:

Transact-SQL

Three-part and four-part column...

I'm sorry, but I really don't understand the question, but here is a shot at it.

At 12:00 AM a full backup is started that doesn't finish until 5:02 AM. ...

Can you post the code for your stored procedure?

Jeff Moden (11/22/2008)

---

GilaMonster (11/21/2008)

---

Yeah, but at...

Matt Miller (11/22/2008)

---

Lynn Pettis (11/20/2008)

---

Jeff Moden (11/20/2008)

---

Adrian Nichols (11/20/2008)

---

I wouldn't say that...

Unfortunately, you can't decide what indexes should be created just looking at the table. What is important are the different queries (select/insert/update/delete) that will be run against the table(s)...

I'm not really sure what you are asking here. With SQL Server 2005 and later, full backups no longer block transaction log backups from running. Any transaction log...

Gail,

Just checked out your blog and it looks like you had a pretty good and exciting time here in the USA. Have some fun doing the tourist thing in...

You probably tried to create and use the database at the same time. The CREATE DATABASE statement must be in its own batch. Try this:

create database mytestdb

go

use mytestdb

go

Ahh geez, Gail, you're taking the fun out of it! :P;)

Sergiy (11/22/2008)

---

jsteinbeck (11/21/2008)

---

Well it seems to be working... would you care to give me a date that wouldn't work and I can go from there...

No offense, I come here to...

The sample databases pubs and NorthWind are gone. They were replaced with the AdventureWorks database.

As for creating your own user databases, I'd start with reading Books Online and the...

Care to elucidate more on what you are trying to ask?

Based on the following:

Backup & Restore example:

FULL Backup 1:00 am

DIFF # 1 5:00 am -- all changes between 1:00 am and 5:00 am

t-log #1 ...

I don't know. You haven't shown me what you are talking about.

You might also want to read the first article linked in my signature block below. It will...