Viewing 15 posts - 196 through 210 (of 210 total)
I agree heartily with this editorial. I have been a DBA for 1.5 years, and would love a way to test my knowledge and see where I need improvement....
April 23, 2014 at 12:52 pm
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...
April 17, 2014 at 7:35 am
Great, thank you for the explanation.
April 10, 2014 at 9:10 am
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...
April 10, 2014 at 8:52 am
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...
April 3, 2014 at 10:37 am
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...
April 3, 2014 at 6:54 am
They do not have the Pass-Through button toggled, so I believe they are native Access queries.
March 27, 2014 at 2:24 pm
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...
March 27, 2014 at 2:05 pm
Wow, I never knew this existed. This is very helpful.
March 13, 2014 at 6:47 am
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...
February 25, 2014 at 7:35 am
Sorry, I did forget to include the splitstring function:
CREATE function [dbo].[SplitString]
(
@STR nvarchar(4000),
...
February 25, 2014 at 7:29 am
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...
January 27, 2014 at 7:32 am
Your responses make sense, thank you both.
August 7, 2013 at 7:44 am
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...
August 2, 2013 at 6:46 am
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...
June 14, 2013 at 9:17 am
Viewing 15 posts - 196 through 210 (of 210 total)