dcraday (5/24/2010)

---

But since this is a SQL forum - I am VERY grateful that 'Select MyColumn from MyTable' is the same thing as 'SElect MyColumn from MyTable' or 'Select...

Usage of the word "smart" within the technology industry is like using the word "fair" within the realm of politics. I mean, ask 100 random people to define their idea...

Case-sensitive collation for a database (ex: 'John Smith' <> 'JOHN SMITH'), case-sensitive programming languages (Main != main), and case-sensitive string comparisons within a programming language ("John Smith" != "JOHN SMITH")...

You said you granted the user account "all permissions", but make sure that view schema permission is one of them.

Metadata Visibility Configuration

http://msdn.microsoft.com/en-us/library/ms187113.aspx

VIEW DEFINITION Permission

http://msdn.microsoft.com/en-us/library/ms175808.aspx

If this doesn't make the tables visible...

Well, there is no reason to shout programming code at someone across the room or dictate it to them over the phone when we have e-mail and instant messaging.

One thing...

Basically, how did creating a temporary stored...

sihaab (5/17/2010)

---

In my experience, I never thought of temporary stored procedure at all. I have scripts stored my local project folders tones of them. I only create stored procedure, when...

Paul White NZ (5/15/2010)

---

...

The wider question is an interesting one. I remember being asked once why we can create temporary stored procedures (local or global) but not temporary functions....

David Portas (5/13/2010)

---

That's different to your original question. Take a look at the execution plan. See if your query is taking advantage of indexes on your tables and consider creating...

- You said that drive C: is 68 GB, but how much disk space was free before running the stored procedure?

- Have you used Sysinternals FileMon or Process Monitor to...

Nowadays 30,000,000 is only somewhat big.

If you join a table that large, you'll want to return only the columns you need, and insure that lat least there is an...

When working with Microsoft development tools, if you find yourself struggling or spending a great deal of time implementing some repetitive task, then you're probably just doing it wrong and...

I think that T-SQL could use something similar to HTML's #include server side include directive for inserting repetitively used blocks of code like error handling, auditing, or variable declarations.

This MSDN article describes some of the...

shannonjk (5/12/2010)

---

How would you handle best practices as far as database file structure if you merged databases to one and used multiple Schemas? For instance if I put 2 databases...