sqldba_newbie (4/23/2012)

---

GSquared (4/23/2012)

---

I'd have to see the reason for the Union All statements (evident from the query, most likely) to be more specific, but if it's all coming from one...

Straight up, I wouldn't consider a job that required special access to my Facebook account (I don't have one) or personal life. That's just a red flag... coming from the...

Carlaabanes (4/23/2012)

---

hi, how 'bout in my case? i wanna go back to being an sql ninja in the back seat. you see i was a dot net developer for some...

selvakumar.sms (4/17/2012)

---

hi all

i am very new to sql server admin. so please suggest some very good books and sites to learn basic and advance of sql...

You can use the xp_logininfo procedure to returns information about Windows users and Windows...

You mentioned that you've been using Text Search engine in the past, so this advice assumes that at least some of your routinely searched terms are contained in text columns....

shahgols (4/16/2012)

---

Thank you very much for that information!

I have already created that user using code, and it still cannot log in...that's what I see in SQL Server logs. It's...

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