Ha! There's a few databases I'd like to...

I'm actually more amused that 5 works and 6...

Eric M Russell (3/20/2015)

Yes, I do that sometimes, but the catch is that it has to be a 'persisted' computed column. Adding these persisted columns to an existing large table...

Iwas Bornready (3/24/2015)

---

What I often see is this. A programmer goes in to fix a problem, finds the source of the problem and fixes it. Done. But wait, what about...

Eric M Russell (3/20/2015)

---

One thing that SQL Server could use is function based indexes, so we can index on something like CAST(SALESDATE AS DATE) or even PRODUCTDESC LIKE '%ASSEMBLY%' (True...

The most common mistake I've seen in SQL Server development is really only partially the developers fault. Many places I've been to (even some software houses) hire developers who...

This reminds me of a manager I had many years ago who had "rules of thumb" for just about everything. One day we were having a discussion and something...

Steve Jones - SSC Editor (1/22/2015)

---

Chris Harshman (1/22/2015)

---

... IT people typically don't know or don't completely understand the business processes or even the goals of business people. While...

Reading this editorial, I couldn't stop thinking about the "Office Space" scene where the business analyst is yelling at the Bobs about his people skills. I didn't read the...

In general I think this was a good article, but I think the line

Where we fail in communicating is in a lack of understanding of the business’ goals and...

in SSIS 2008 we use FMTONLY in the ADO.Net Source task's SQL command text:

SET FMTONLY OFF;

EXEC SomeProcedureNameHere;

does this method still work in SSIS 2012/2014? Microsoft says it will be...

zahid.nawaz (11/12/2014)

---

Hallo Everyone

I have a small database of CMS system which does not have any primary key, relations or cluster indexes. few none cluster indexes has been created from vendor....

php_guy (10/29/2014)

---

Have a view that I need to add a column to which checks the value of another table's column which is an int value. If that value is null...

I believe the problem here is in this call:

EXEC msdb.dbo.sp_send_dbmail

@profile_name='db_mail',

@recipients='ananda.murugesan@xyz.com',

@subject='Alert!-Verify Instance',

@query='select * from #results'

The query in the msdb.dbo.sp_send_dbmail will be in a different scope than the rest of your...

When this database gets restored from production, all the permissions as they are in production will be restored with it. As a DBA what I typically do to handle...