What method did you use to port the database?

Remember to use a schema comparison tool to insure things like indexes, table options, statistics, constraints, plan guides, etc. are all the...

I'd say that Chipotle Mexican Grill is good, fast, and cheap. However, as with any application, whether it be software or a restraunt, how the end user perceives "good" is...

So, [widgets] looks like an EAV (entity attribute value) table. This is similar to the common scenario where users request a query containing CustomerID, HomePhone, CellPhone, WorkPhone and all phone...

Yes, I've seen that one before, SSIS simply chooses to ignore a dtsConfig file containing a malformed tag. There was no error regarding the config file, it just reverted back...

Brandie Tarvin (5/2/2014)

---

I remoted into the app server (not web server, I keep saying that wrong) with the login in question. I logged into SSMS using windows authentication and opened...

I can confirm that 3 dimensional joins work quite well; it's the 12 or 20 dimensional joins that are...

Given the options: first, larger, smaller, or second input, I still say that 'smaller input' is closest to the correct answer.

On his MSDN blog, Craig Freedman goes into...

The DMV sys.dm_exec_query_stats accumulates performance statistics about cached query plans, which is perfect for keeping track of the expense of queries. That's easy, but now if only there were an...

GoofyGuy (4/29/2014)

---

Ed Pollack wrote:

... if your product has an uptime requirement of 99.95, then Azure is immediately out-of-the-question as it promises only 99.9%.

The difference in uptime, over the course of...

Peter E. Kierstead (4/29/2014)

---

Subtle push? More like an overt attempt to sell an ostensibly benefit for even more access and control over private data by not-always-visible entities (read what security...

djackson 22568 (4/29/2014)

---

Eric M Russell (4/29/2014)

---

Net Neutrality is a double edged sword; sure your Netflix movies...

Net Neutrality is a double edged sword; sure your Netflix movies will stream more smoothly at...

Eirikur Eiriksson (4/29/2014)

---

Set MIN and MAX memory to the desired number

😎

EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH OVERRIDE

GO

EXEC sys.sp_configure N'min server memory (MB)', N'4096000'

GO

EXEC sys.sp_configure N'max server memory...

Dalkeith (4/29/2014)

---

There are two aspects of software which make it unique in the world of Economics.

Immortality and essentially Free Duplication.

Immortality usually leads to higher prices - eg gold diamonds etc

100%...

That's odd. Maybe you're lactose intollerant. Try...