Thanks for the instructive question, Steve!

Schemas will be my undoing lol.

-- webrunner

Thanks for this instructive question. I've seen rebuild and reorg statements all the time yet got it wrong.

-- webrunner

Ah, I see. Thanks again, Steve!

-- webrunner

Thanks to everyone for the continued feedback. As I understand it, the need for these tables is that the application creates the lookup tables as needed due to possible new...

Thanks, Steve, great question!

I have a noob question in response to this QotD: Why is it that dbo is a schema and a db user, but there is no login...

Thanks, Scott, those are excellent points. I am considering them as we speak. In this case, the tables all seem to be quite similar (i.e., the app uses a common...

Thanks, Scott, Lynn!

I am going to try Lynn's suggestion first.

Lynn, just to make sure I understand correctly - granting permission to execute the stored procedure means I can just have...

Thanks for the thought-provoking commentary. The proposal sounds like the nuclear launch two-man rule. So to that extent it seems like overkill for databases, but in some situations it may...

• This reply was modified 5 years, 10 months ago by webrunner.

Thanks for the instructive question - even though I got it wrong (mistakenly thought choice 4 was true).

-- webrunner

I have never done any development on Access, but I have sure been called to consult for a lot of Access applications. On many occasions, I have had the...

• This reply was modified 5 years, 10 months ago by webrunner.

1. What Lowell said.
2. See also these links for explanations of SQL auditing options. But the bottom line (again, as Lowell said), you need to plan, install, and start that...

Just commenting to second what everyone else has said. I also got started in actual database work using Access. (Apart from the career-change courses I subsequently took in Oracle.) Access...

• This reply was modified 5 years, 10 months ago by webrunner.
• This reply was modified 5 years, 10 months ago by webrunner.

Thank you, Jo. I hadn't thought about looking at both sides - the server and the client. I will review the providers on both and will check for the latest...

Bump, thx

Thanks for this instructive and very well presented article!

It really drives home the importance of being very careful when using the TOP statement in T-SQL. I had no idea so...