We've recently started using package configurations in our Development/Test/Production environment since developers cannot access test and production.

We used the process outlined by Ray Barley http://www.mssqltips.com/tip.asp?tip=1405 that uses an Environment variable...

I'm curious as to how the performance impact and usability of the trigger pattern is in comparison to the StartDate and EndDate column pattern where the most recent row has...

Hi Bradley,

How big is the table? Are there indexes on these two columns? I wonder if they can obstruct the lock acquisition during the alter table.

Maybe if you don't need...

I see there have been a few views; does anyone have some words of wisdom on this design conundrum?

Well, the first question is are you willing to get SSIS? You mentioned using SQL Server Express, well SSIS is available starting at the Standard version (Basic Transforms). ...

Thanks for the suggestion, although I don't quite see that working. That allows me to add index with Online=On, but has no effect on the computed column. I...

Harold Buckner (12/11/2008)

---

Great article Brian. I've been working with Kerberos Authenication for a while and I had to scour the internet looking for something that explained it like this.

One...

Check out the SQL Server 2005 Performance Dashboard Reports

http://www.microsoft.com/downloads/details.aspx?FamilyID=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

Those should easily answer most of your questions. After that it's time to really start digging, but these reports are my...

Thanks Barry, I'll have to do some performance testing and see how goes if I ever need to apply this across multiple columns.

Thank you all for your input. I did implement it as a CASE statement originally (see below). I am looking for a non case statement solution to handle...

Thanks for the article.

I have question about the Effective Max %. Assume we have no workload in PoolA, PoolB, and PoolC. Can the Default pool get 100% reources...

This seems to be the proper audience for the following scenario so here it goes...

We have multiple databases that each have multiple reports for the client delivered in an Excel...

Awesome question, I've actually used the Window functions in the past and the Group By almost got me!

Right, hince why I was saying no SQL injection cause it'd fail the convert big long string to int!

Anyways good thought provoking question!

Stored procedures have to be properly parameterized too. I've seen garbage like this way too many times:

string sql = "EXEC my_stored_proc " + param1;

Which still leaves you wide open...