jcrawf02 (6/10/2013)

---

Grant Fritchey (6/10/2013)

---

After visiting TechEd, I'm more and more convinced, the damn is going to break and we'll see tons of people using Azure, or, Microsoft is going to...

Oh, those of us who just finished our 2012 certifications are looking forward to this.

Failover clusters are a good idea, but don't let your SAN be a single point of failure. Years ago, I worked at a place which actually had invested in a...

L' Eomot Inversé (6/8/2013)

---

mtillman-921105 (6/8/2013)

---

I found that I can buy Chimay's Red Cap beer at my local liquor store! It's terrific, but pricey. The bottle even had a...

Brian Carlson (6/6/2013)

---

The views option would work if we could prevent them from joining views. There might be a way to prevent that but I'm not sure how. I read...

I was about to...

Brian Carlson (6/5/2013)

---

Agreed about the problems with allowing non-technical users access. One of the requirements to get login permissions will be passing a SQL Query exam though. Of course, user's...

You can use REPLACE() function to strip character sequences from a varchar column like so:

select replace( col1, '@DAR', '' );

You can also use the LIKE operator to return (or check)...

From my experience, it's a waste of time to allow non-technical users to run ad-hoc queries against a database. What will typically happen is that they'll run a bunch of...

The page space used by deleted rows isn't even freed up until the clustered index is rebuilt, so it's still the same size of data you're scanning. If your table...

Yes, the first SQL Saturday took place in Cambridge in May 1813, where a young Charles Babbage demonstrated a...

I was at SQL Saturday here in Atlanta a couple weekends back, and it was great. Steve Busby gave a presentation on SQL Server Parallel Data Warehouse, which I found...

Having worked in the healthcare IT industry for several years, I can see how data is revolutioning how things are done. I've contributed to a lot of cool projects that...

Abu Dina (5/21/2013)

---

We have a tall table that contains 2.6 billion rows

Table structure:

The application which uses this table has been running slow for the last couple of days and it...

Your comment is referring to the maximum 2,147,483,647...