Viewing 15 posts - 226 through 240 (of 248 total)
perwi (5/15/2014)
Does it work with SSMS 2008 R2?
Why not upgrade to SSMS 2012? It's free!
http://www.microsoft.com/en-us/download/details.aspx?id=35579
Be still, and know that I am God - Psalm 46:10
May 15, 2014 at 7:49 am
I earned a degree in math and very slowly grew my career into being the DBA I am today. I started out programming Excel using VBA, then moved into...
Be still, and know that I am God - Psalm 46:10
May 13, 2014 at 6:58 am
Good question, I hadn't heard of WITH TIES before. Thanks!
Be still, and know that I am God - Psalm 46:10
May 9, 2014 at 6:58 am
Man, I felt so good that I knew that quote was from "Speed"!
Oh, but I also picked bit and thus got the question wrong.
Be still, and know that I am God - Psalm 46:10
May 6, 2014 at 6:46 am
I'm sure I'm in the minority with my perspective. I love SQL Server - learning how it works, why it does what it does, how to make it hum,...
Be still, and know that I am God - Psalm 46:10
May 2, 2014 at 6:58 am
My biggest worry about using the cloud is 5 - 10 years down the road, when 75% of SQL Servers are in Azure, MS can start jacking up the price....
Be still, and know that I am God - Psalm 46:10
April 29, 2014 at 9:25 am
I think I understand what you mean. I was thinking of the problems more as those chess puzzles where you see the board in a certain position and it's...
Be still, and know that I am God - Psalm 46:10
April 23, 2014 at 1:15 pm
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....
Be still, and know that I am God - Psalm 46:10
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...
Be still, and know that I am God - Psalm 46:10
April 17, 2014 at 7:35 am
Great, thank you for the explanation.
Be still, and know that I am God - Psalm 46:10
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...
Be still, and know that I am God - Psalm 46:10
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...
Be still, and know that I am God - Psalm 46:10
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...
Be still, and know that I am God - Psalm 46:10
April 3, 2014 at 6:54 am
They do not have the Pass-Through button toggled, so I believe they are native Access queries.
Be still, and know that I am God - Psalm 46:10
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...
Be still, and know that I am God - Psalm 46:10
March 27, 2014 at 2:05 pm
Viewing 15 posts - 226 through 240 (of 248 total)