john.bush (8/6/2012)

---

Hi Craig,

I checked everything you mentioned and have got positive results. I seem to have left the RPC and RPC Out at defaults (False). What does RPC stand...

Which is why you got a simplified answer.

I have tried using...

john.bush (8/6/2012)

---

Good Afternoon, I am relatively new to SQL Server 2008 and I am attempting to create a query. What I need is to access data from a SQL...

A question. Are you trying to store the file, or the information IN the file for full-text indexing?

If you're just trying to store the file, you want VARBINARY(MAX). ...

miapjp (8/6/2012)

---

Hey GSquared (or anyone who knows the answer) - I have a question about the last line in your response. Do you mean I could get the wrong...

I'd be willing to assist on QotD validations, but my free time has constrained signficantly lately so I certainly couldn't guarantee timeliness (ie: under two weeks)

You'll want to run sp_updateview after you're done changing the underlying schema. If the view(s) are schemabound you'll have to drop and recreate them after you've made your modifications.

bsclyde (8/2/2012)

---

We don't need a SQL god or any other type of omnipotent, super mutant, cyborg, uber-DBA. We'd take one, but we don't need one.:-D We also don't...

I stayed away from this thread for a bit because it hits a few demons in my career. I've also had a few blessings.

One of my managers once told...

Nope.

The best you can do is grab an estimated execution plan and that'll attempt to determine it off statistics, but really... nope.

You COULD do a SELECT COUNT(*) AS cnt FROM...

polkadot (8/2/2012)

---

How would you build rCTE when the column against which recursion is done is a SMALLDATETIME column and not SMALLINT?

Do I need to first order the dates...

I'll second (third?) the delimited string splitter technique and use an inline table function for a single parameter set.

XML is an excellent alternative in 2k5 for when you have pairs...

I've personally never ran into anything that can convert Access DAO.SQL to T-SQL effectively. There's just enough differences and assumptions in the two that they don't play nice directly...

Michael Valentine Jones (8/2/2012)

---

I had a query that was comparing hundreds of columns to see if they were different, and it was taking forever to run until I switched it...

I can't see the item in discussion, unfortunately, because that site is blocked by websense.

However, if I can toot my own horn and following along with the discussion and your...