MP,  is  this a one time import of the data in your spreadsheet? Or will it be an ongoing import that needs to be automated?

If you're not willing to use a Foreign Key Constraint then insert your data into a temp table and use a stored procedure to do your data validation. I would...

I started studying for this one but I'm thinking of switching to the 2008 track since:

1.) it expires at the end of Jan 2014

2.) most of our customers are still...

L' Eomot Inversé (10/17/2013)

---

Arrgh! I got this wrong by a careless assumption. I assumed that sp_recompile('T') would the same effect as would sp_recompile('GetIt') in this context. ...

erikd (10/16/2013)

---

Developer Edition was $60 at the MS link I posted up yonder, and it's on Amazon for $48 (lowest I can see from a Prime eligible seller). If you...

Sean Lange (10/16/2013)

---

btw, not sure what the previous poster was complaining about. SQLExpress is free and is a great tool, especially for learning when you don't have access to a...

erikd (10/16/2013)

---

Jeff Atherton (10/16/2013)

---

For starters if you want to play and learn SQL Server then why did you go with SQL Express. You might want to consider installing the full...

For starters if you want to play and learn SQL Server then why did you go with SQL Express. You might want to consider installing the full developer edition of...

I don't know of a way to do it without a backup. It would be nice. And if you could restore that deleted record what if there were triggers that...

Simon E Doubt (10/10/2013)

---

Have a look at my original blog series - http://OLAPsprint.com - all I had was a laptop, a book, 7-days, and the PASS Summit.

It was a great...

When I first started reading kindle books on my iPad I had the same feeling....

Great Article. Thanks for sharing your experience. I've been thinking about getting into BI but it sounds like I'll really need to prepare myself if I decide to make the...

Haven't heard of this one before and all I can find is a version written in...

Sean Pearce (10/4/2013)

---

SQL 2005+ no longer tracks licensing (per seat or per processor) via registry entries. SQL 2005 still reads the registry for this information, but the SQL 2005 setup...