Wow, as I looked through the possible answers, the correct one was the one I thought was certainly wrong. I always associate buffer pool with RAM, so I wouldn't...

Great, thank you for the explanation.

Yes, PageType = 1.

So if I'm understanding you correctly, when a table is first created the data is put into mixed extents. Once the data is big enough to...

Ok, I got time to run another test today and the results were quite different. This test used 3 "sub" queries in Access, and one of them had a...

Great question, I'd never heard of TABLESAMPLE, so I looked it up - and then still ended up getting the answer wrong :O

Now I'm just trying to think of when...

They do not have the Pass-Through button toggled, so I believe they are native Access queries.

I would have to say based on my testing that I disagree with the premise in those links. As a very simple example, I open up a linked table...

Wow, I never knew this existed. This is very helpful.

Thanks for the replies. In my current system we use this for database consistency checks that we are unable to use hard constraints on. So these emails are...

Sorry, I did forget to include the splitstring function:

CREATE function [dbo].[SplitString]

(

@str nvarchar(4000),

...

In addition to those already listed by others, I added checks for:

- Disabled Indexes (no way to tell in the GUI that I am aware of)

- Auto Create/Update statistics set...

Your responses make sense, thank you both.

Thank you for the replies.

The refdate field is equal to the crdate field in most, if not all, of the records.

Most of the records are #[eight digit hex], but there...

I've only been in the professional workspace for 5 years now, so I probably don't have the perspective that most of you do. I like the idea of a...