palotaiarpad (3/28/2012)

---

Hugo Kornelis (3/27/2012)

---

palotaiarpad (3/27/2012)

---

I'm a bit confused.

BOL: If a view is not created with the SCHEMABINDING clause, sp_refreshview should be run when changes are made to the objects underlying...

I had a hard time finding documentation on this the first time I ran across it, though I'm sure someone will post a relevant link from BOL. What I...

Yup, that was my "process of elimination" mental pathway, too....

I put my hands up in the air sometimes

Saying Ayyyyy-Oh

Too much I/O.

I gotta troubleshoot this query now:

Lines of code are

Full of RBAR.

With apologies to Taio Cruz....

Rich

Here's a script I've saved and used from Tibor Karaszi's website. I adapted it slightly to filter table names based on a string at the start of the table...

As Sean posted, adding DDL code is useful to get the help you're seeking. Also, he mentioned tally tables, which is my usual approach.

So, if you have a tally...

I haven't figured out the answer yet, b/c I'm still mentally stepping through the code.... still mentally stepping through the code... still mentally stepping through the code... 🙂

PMFJI: SCHEMABINDING can...

Schedules can be shared by multiple jobs, so you generally wouldn't want to disable the schedule when all you want to disable is the job.

Be sure to check both the...

I think of this having less to do with temporary objects so much as it does with schema restrictions: you can't have 2 objects with the same name in the...

I got this right b/c of a great article I've kept bookmarked, "Ten Common SQL Programming Mistakes":

http://www.simple-talk.com/content/print.aspx?article=783

Ratchev lists it as item #1, with a straightforward, lucid explanation as to why...

This was a terribly difficult question: I spent 10 minutes looking for the syntax error, catch, gotcha, trip-up, etc., only to submit the straightforward, correct answer.:-D

Rich

Jeff Moden (2/8/2012)

---

Thanks for the feedback, Elliott. I'm more confused than ever though. Paul White built a CLR for me for the "Tally Oh!" article. It required...

I knew about VARCHAR defaulting to length of 1, but I learned today about the CASE/CAST 30 byte truncation.

So.

Anyone know why MS created two different default data lengths? It...

When is a view appropriate? Here are a couple of my candidates:

1) You want to grant power users access to a boatload of data they need day-in, day-out. ...