I disagree that fragmentation would not be removed. As long as the table is big, the fragmentation will be reduced. I have a bunch of crappy third party...

batgirl (5/16/2014)

---

As is often the case, I am now thoroughly confused.

I am pretty sure that I need a vacation, or at least a long weekend.

I assumed that "NOT"...

Why not upgrade to SSMS 2012? It's free!

http://www.microsoft.com/en-us/download/details.aspx?id=35579

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...

Good question, I hadn't heard of WITH TIES before. Thanks!

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.

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,...

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....

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...

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....

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...