Kausar Mehmood (4/13/2012)

---

I know that this depends on DB Design. We are already in development phase and I know we can use UNION statements for combining results from different queries,...

Thank you. I knew I was overlooking something.

You don't need Full Text Indexing necessarily to do a search. If your indexes and statistics are good enough, then you can search billions of records without a problem.

The problem...

opc.three (4/12/2012)

---

tt-615680 (4/12/2012)

---

Brandie Tarvin (4/12/2012)

---

Why does the replacement user need similar privledges? You're just shooting yourself in the foot.

Remember, least permissions needed to do the job (figuratively and literally) should...

That's because they're using the same schedule (you can have jobs use an existing schedule, or each job have their own brand new schedule). Delete the schedule from job 3...

You misunderstand what he said. If you want to put the code in a web page and post the URL of the...

Um, that's what I've been telling you. If you want to data mine, you need data (not information). There's a difference.

can...

Forgot about the variable option. I retract the "the only way" part of my earlier post.

What you do then is to create two report variables, one for EXP and one for IMP. Then have the variables subtract from each other.

FYI: It's been a while since...

SQL won't let you do that. The only way to guarantee order is to have two different UPDATE statements, or to fix your current one to pass in the hard...

How is full text searching a limitation if you are allowed to use it?

So I'm using Display Estimated Execution Plan for the first time in SQL 2008 and fun, fun, it displays "missing indexes" across the top.

Then I find an index suggestion where...

Per Books Online (Top clause):

Specifies that only the first set of rows will be returned from the query result. The set of rows can be either a number or a...

Sounds like a homework question to me. Have you Googled your questions yet? Or read SQL Server Books Online?

Look up Common Table Expressions and Google spforeachTable (First link is here: http://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm). See if that helps.