I hate working with Excel as a datasource. Business users love it, because it's easy to enter data and the design is flexible. However it's problematic when used in an...

Daryl Lloyd (4/16/2012)

---

...

b) use a view to union all the tables together and query that instead [drawbacks - our tables are stored in separate database instances and cannot be indexed,...

A primary key column can't contain NULL. It would be like a street with no name or a product...

TravisDBA (4/17/2012)

---

Hmmmm. I look at the 2007 Top 100 list on that site and I noticed that Microsoft (correct me if I'm wrong) is not on that list. No big...

Select permission on some extended stored procecures and system tables is required for basic connectivity, especially when users are connecting via the ODBC driver. Whatever permissions that SQL Server 2005+...

Companies tend to lavish more attention and rewards on whatever department is integral to their core business model. For example, you can have a showroom floor full of fat and...

I have a question for someone here who has experience with MySQL. I've heard that with MySQL, there are are options for multiple table storage types, one of which is...

Pete.murray (4/2/2012)

---

Thanks for the reply guys,

GilaMonster - I think you gave me the perfect direction to investigate in, I can see all the information I need to identify the...

Before killing the process that had been running for 7 hours, did you check see if it was was in a blocked state, what was blocking it, and wether it...

In the past most data orginated in a database because it was deemed important enough by users that they entered it manually (patient charts, student records, inventory, etc.).

Today, the...

Henrico Bekker (4/12/2012)

---

I've done it as well... "how do you detach a Log Shipped tempdb that is in Read...

Who wouldn't want six weeks of vacation, the option to work remotely from home every day, a personal assistant, and a $120,000 salary?

However, if applicants were to write a description...

sqldba_newbie (4/12/2012)

---

Eric M Russell (4/12/2012)

---

sqldba_newbie (4/11/2012)

---

Eric M Russell (4/10/2012)

---

Consider implementing a pass-through style query using EXEC(<sql>) AT <servername> syntax. If this query must be implemented a View, then consider replicating...

sqldba_newbie (4/11/2012)

---

Eric M Russell (4/10/2012)

---

Consider implementing a pass-through style query using EXEC(<sql>) AT <servername> syntax. If this query must be implemented a View, then consider replicating or grabbing a copy...

I would not be anywhere near as knowledgeable, not at the level I am today, were it not for participating in discussion forums like SQLServerCentral. There are other non-IT things...