Actually, the solution is not so ugly.

Simply log all your development changes into a script and when you get a new version from vendor, simply reapply the script, fixing eventual...

I'm not sure about what your question is. 7gb database is relatively small, so you can set it to autogrow 10-20%:

ALTER DATABASE [mydb] MODIFY FILE ( NAME = N'Mydb', FILEGROWTH...

People, give it a rest. Why do 20 or so people repeat what's been said in first few posts?

What if site owners decide not to post qod at all? Heck,...

In UDF you have even less reasons to use cursor as you can't call store procedure. Most of times it can be rewritten to use custom aggregate:

DECLARE @StaffList varchar(1024)

SELECT @StaffList...

Points don't matter. QoD is supposed to fun way of learning something new (you're wrong) or prove your knowledge (you're right and awarded with points).

Questions like this spoil the fun....

JessJenn (4/4/2008)

---

Hey guys,

My company is undertaking a database optimization project. Optimization the schema, the code, etc. I would like to ask, if you guys could help out, the following:

1. What...

The question asks for join_date, not dob, so first answer is incorrect.

datename(m,) returns full name of month, which gives correct result for few languages, but not all, so it's also...

Since you mention temp tables #temp (local to connection), you should also mention global temp tables ##temp (accessible by all connections).

Also, how to check it the temp table exists.

Best practice...

I never had a crash. Might be that a backup file is bad or some event handlers (autostart jobs) that reference the other instance, so if other instance is not...

I'd use partitioning on a huge table, where there is a time or other criteria on which a big part of data is rarely used/modified as it speeds up a...

You should rephrase your question.

I really don't know nor are willing to guess what are you asking for.

What does "OP" stand for? Ops, original poster :blush:

Considering the level of the question, I wouldn't think so either. However, when dealing with customers or assisting fellows developers on their...

ramadesai108 (3/29/2008)

---

All,

I don't think you understand how bound true db grid works. It displays data from the select query and tries to update the database using...

Depends. Google does a lot more than phrase matching and ranking.

See also CONTAINS predicate and ISABOUT term.

Do not scrosspost. Answered elsewhere.