Steve:

I keep running into people looking for some advice on "what's a good book to start with in learning SQL Server?", and similar questions about starting the DBA path.

In the...

An FAQ on "How to get started learning SQL Server" would definitely be a good idea. I'll suggest it to Steve.

The way I started learning SQL Server was through...

Yeah, I got what you meant on that one, Grant. Was just expanding on it.

Sorry. Forgot to include the script for that.

-- Creates a Numbers table for various uses. This script is SQL 2005 or later only

create table dbo.Numbers (

Number int primary...

Right-click on the database in Management Studio.

Properties

Files

It will list the files that the database is composed of, both data and log files. Usually, the log file is second.

Two of...

Glad I could help.

Jonathan Kehayias (6/4/2009)

I'd test that with SQLIO before implementing it in production use. A 8 disk...

Output all your procs into a single script. Modify the script so that it gets rid of the string for you (Ctrl-H in Management Studio ought to do the...

Wrap it all in a transaction:

begin transaction

disable trigger ...

your update

enable trigger ...

commit

I've done that and not had problems with it.

One problem I've run into with char(1) for this is that some clever developer somewhere along the way inevitably wants to put T/F in a column that also has Y/N,...

Here's what I came up with:

create table #T (

ID int identity primary key,

Col char(9));

insert into #T (Col)

select '123456789' union all

select '987654321' union all

select '111222333';

insert into #T (Col)

select '111112222' union all

select...

I'm assuming what you did was truncate the log file and then shrink it, and now you want to expand it again. Is that correct?

If so, expanding it again...

You could potentially avoid a cursor in this. But it'll take more work and be less efficient.

Cursors do have their uses. Limited, yes, but uses nonetheless.

That's called a "correlated sub-query". Is that what you're looking for?

That makes sense then.