Unit Testing

External Article

Unit Testing Myths and Practices

  • Article

We all understand the value of Unit Testing, but how come so few organisations maintain unit tests for their in-house applications? We can no longer pretend that unit testing is a universal panacea for ensuring less-buggy applications. Instead, we should be prepared to actively justify the use of unit tests, and be more savvy about where in the development cycle the unit test resources should be most effectively used.


3,133 reads

Technical Article

RE: Top N across groupings

  • Reply

What if there's a tie for revenue ?If there's a tie, the sub-query will return you top 2 rows, but if you join that based solely on Revenue, you can & will get more than 2 rows per state in the resultset. 


Technical Article

RE: Partitioning Tables

  • Reply

Hi,Partitioning view is really a good option. but while implementing in our scenario we are facing some problems such as we cannot create index on the partitioned views as it gives some error saying that "underlying tables have some constraints" and even we had the triggers on the table which we have decided to split […]



What do we want to achieve by encrypting our data?


On the face of it, this is a very obvious question with a very...

Daily Coping 5 Dec 2022


Today’s coping tip is to look for new reasons to be hopeful, even in...

Speaking at SQLSaturday MN 2022


Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...

Read the latest Blogs


Pivot not working, pivot without aggregate functions.

By sbhagyalakshmi95

Hi Team,   Can you please help me to get data pivot data. my...

10 years as Sql server dba but still fears of Interview and lack of Confidence

By anoop.mig29

I dont know whether i may asking question at right or worng place but...

T-SQL Code Review - Where Field DOES NOT contain

By carlton 84646

Hello community, Quick question to get your opinion on simply T-SQL code. I want...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers