Please refrain from posting the same question to multiple fora here. Let's leave your question here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=169129

BOL is the SQL Server online help and CREATE TRIGGER is the command you should search for to find the solution I mentioned.

You're working with SQL Server and don't...

Wow, you're not putting any peer pressure on us, do you?

Why do you intend to keep a redundant "total" column anyway? When you...

Have you already tried to search here for "interview"? 

Returns several very useful threads.

See if this also helps:

http://www.microsoft.com/windows2000/techinfo/planning/server/clustersteps.asp

You can also do a search on my site for "cluster". That is the text box in the upper right corner next to the date....

Sorry, I suspect you don't want to hear my answer. But SQL Server is no product for such sophisticated statistics like you have in mind. T-SQL is no computational language...

Why do you want to shrink the file? Such a file needs to grow again when necessary. And that is a somewhat expensive operation which leads to file fragmentation and...

When you look at the code of both procedures, you'll see two very good reasons why they are undocumented: cursors and dynamic sql

Piggy-backing on Brian. I think you need to have a faible for such kind of literature to derive fun from reading purely academical books like Date's. You also need to...

"t/a"

Do you mean N/A = not available?

do you think having a second .ldf would help

No, SQL Server treats log files (no matter how much you have) as one single virtual...

Not sure, what you're trying to accomplish here, but have a look at http://www.sommarskog.se/dynamic_sql.html

A dirty workaround might be:

USE PUBS

IF EXISTS(SELECT * FROM sysindexes WHERE [name] = 'PK_emp_id')

 Do something...

Sooner or later, I think you'll come across Date's book anyway. As Brian mentioned, no easy reading, but it pays (even just to disagree with him of NULL and missing...

No, if you use DATETIME or SMALLDATETIME you always will have both: a date *and* a time portion. You can however set this time to midnight, so that it doesn't...

At a size of 15.5 GB you're nowhere near any limit provided by SQL Server. See "Maximum capacity specifications" in BOL for such informations. And, just for fun, consider this:...