roy.tollison (3/17/2008)

---

I have 2 tables.

master & detail

select * from detail

where date >= :start_date and date <= :end_date and

status <> 'Successful'

select * from master

where Client not in (select client from detail

where...

That will only show you what SQL Server is doing during that time. You should also schedule a Performance Monitor session to run during that time. Spcifically capture the Process:%ProcessorTime/All...

Have you confirmed that the SQL account backing up to the network drive has sufficient privileges to write to that drive?

DAB

Check out Encryption:Columns in SQL Server BOL

DAB

Trevor, first, check out the perfmon counter for sql server:general statistics:logins/sec counter. btw, this can also be found in the sys.perfinfo table. Then check out the following article:

Yes, it's called the HAVING clause...

SELECT COUNT(*) AS total

,last_name

,first_name

FROM account_contact

WHERE account_id = '11997'

...

Check out syslogins

dab

Equal is an exact match while greater than or less than is a ranged match. Without looking at the query plan my guess is that the EQUALS operation just performs...

Matt's correct, why the function? If that column does contain an index then it will not be used. Simply put, the function will use all rows in the column (a...

jamiejulius (3/12/2008)

---

I have a very large table called People, with a field (int) named PersonID serving as the primary key. There is also a field (int) named Status. The table...

There are 2 differences between SELECT INTO and INSERT INTO...

SELECT INTO only works for if the inserted table does not exist. INSERT INTO works if the inserted table already exists.

DAB

Try Kalen Delaney's

Inside SQL Server 2005

and Ken Henderson (rest his soul) Guru's series

DAB

Also check out the Upgrade Advisor at http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en

DAB

Mark has the best solution with sp_spaceused. Just beware if your database has multiple schemas. It will return schema-less results. For example

exec sp_spaceused 'dbo.summarydata'

exec sp_spaceused 'test.summarydata'

returns the following results...

name...

Preach on brother! Amen and halleluah!