For clarity, I like to use the full year YYYY in my dates. It helps prevent any confusion.

Another thing that trips people up is objects owned by a schema other than "dbo".

You might run this, which assumes "dbo" select * from TableA

when in fact...

okiftequar (2/23/2010)

---

if i use this query so i can find out how many rows does our largest SQL Server table contains?

USE AdventureWorks

SELECT o.name as [Name], i.rowcnt as [Row Count]

FROM sysindexes...

Then, after I qet the query results of monthly growth averages, I paste them into a spreadsheet to calulate average growth percent per database per month. I then use that...

I don't delete my full backup history so that I can use previous backup size to predict future growth.

-- Average DB size by month for ALL Databases

-- Backups DO NOT...

That's like asking for help arranging the furniture in your house, without being able to see the furniture or the house.

Self blocking is ok. There's an explanation somewhere if you search for it.

Not to work with operators, assuming you already have mail working.

If you are setting up...

Create an Operator that has multiple people in it.

Operator: "Job Alert Group"

Email Name: Joe@abc.com; Mary@abc.com; Mike@abd.com

You can gain knowledge outside your work requirement by using a local version of sql for learning, or setting up a test database on a test server. There you can...

There might be ways to loop through the data doing updates instead of large batches. Might be slower but less disruptive.

Diane Rayzer (2/16/2010)

---

Hi Everyone,

I'm wanting to do something similar in SQL 2005. From Server A (in the network) I want to connect to Server B (in it's own DMZ);...

What are you trying to accomplish ?

I recently worked on a project converting a SQlite application to SQL 2005. I didn't try connecting the 2 though. I used SQL Maestro...

See my and other responses in this similar thread:

http://www.sqlservercentral.com/Forums/Topic809627-149-1.aspx

^^^^ R a j u ^^^ (2/17/2010)

---

Database Design - What happens when you add a column in the middle of a table (dbo.Test1)...