I'm don't know why it is doing what it is doing, but I can say that if you look at the execution plans for the simple select vs. the cursor...

An index with only 3 pages likely won't be able to be defragmented because it is on a mixed extent and there isn't a way to move the rows onto...

Jamie-2229 (4/9/2015)

---

"the type initializer for '' threw an exception" is the error that is created when the redgatemonitor database is created on the server during the sql monitor setup...

Brandie Tarvin (4/7/2015)

---

Eirikur Eiriksson (4/7/2015)

---

Jeff Moden (4/7/2015)

---

I'd put off doing anything with SQL Server 2012 until I actually needed it. I'm doing installs for upgrades now and really beginning...

Brandie Tarvin (4/6/2015)

---

Lowell (4/6/2015)

---

i've used this open source project several times:

https://ssissftp.codeplex.com/

no sense reinventing the wheel, if it's open source, you can rename it, taking care to leave credit where credit...

Brandie Tarvin (4/3/2015)

---

#HEADDESK

Don't you just love it when you go to post a question to the forums (after banking your head against a wall for several hours / days) and...

SqlSanctum (4/3/2015)

---

That's basically what I was thinking of with "biblical reasons". What you mentioned makes sense, but it always feels silly excluding fish from meat. We need to come up...

SqlSanctum (4/3/2015)

---

Fish is not considered meat, so it's allowed. For strange reasons. Some suggest it's because the Pope at the time had ties to the fishing industry, and as we...

I don't need a special day to be Fool. I can accomplish that anytime:-P

Peter Schott (3/27/2015)

---

Appreciate the pointer on T4 support, Jack. I've know about the concept for a while, but adding that to my toolkit now. It looks pretty cool, if still...

hakim.ali (3/27/2015)

---

We are a Microsoft shop, and our developers live in Visual Studio. They also do a lot of DB development. This happens in Visual Studio SSDT. We tie it...

Since I'm old school I do prefer working in SSMS, but am working to get all our databases into SSDT Database projects to get them into TFS. I'm essentially trying...

GilaMonster (3/25/2015)

---

Annoyingly so, along with the growing accusation "feminist = man...

I'm not claiming to be unbiased, I'm saying my biases aren't around ability to do the job. I don't care if what gender, race, religion, age you are if...

That was an interesting read. I can't disagree with any of it, but I can honestly say I don't think any...