1,479 reputation
414
bio website
location Netherlands
age 40
visits member for 3 years, 2 months
seen Apr 7 at 7:57

I'm a software developer at a telco supporting line-of-business applications. We use a variety of technologies from ASP.NET to Perl. I've come to appreciate SQL more over time, and I now spend most of my time in the database.

If you'd like to learn SQL properly, consider the awesome free SQL course from Stanford. The organization behind the course offers many other classes. I'm enjoying the Fantasy and Science Fiction course.


Mar
14
comment Update Statement takes forever to complete
Are there any Blocked processes in Activity Monitor when your query is running? (You can also use sp_WhoIsActive to check this.)
Mar
13
comment Combining 2 queries
Use four spaces to indent a query. You can indent existing text by selecting it and pressing CTRL-K.
Mar
13
suggested suggested edit on Combining 2 queries
Mar
12
comment Indexes for SQL query with WHERE condition and GROUP BY
This doesn't make sense to me. The ts_counter index is not covering (it lacks group_id), so how could a scan on that be used to resolve your query?
Feb
5
awarded  Yearling
Dec
9
comment Have non clustered index but no clustered index
All your performance of table are belong to us!
Oct
21
revised How to insert in table from remote stored procedure without creating a distributed transaction?
added 738 characters in body
Oct
21
comment How to insert in table from remote stored procedure without creating a distributed transaction?
Answer updated for SQL Server 2005.
Oct
21
revised How to insert in table from remote stored procedure without creating a distributed transaction?
added 738 characters in body
Oct
21
revised How to insert in table from remote stored procedure without creating a distributed transaction?
added 471 characters in body
Sep
6
awarded  Nice Answer
Jul
17
answered How to insert in table from remote stored procedure without creating a distributed transaction?
Jul
15
comment Is it recommended to use Identity as an alternative to primary key?
@ThomasStringer: You're right, my comment should read clustered index key where it says primary key.
Jul
15
comment Is it recommended to use Identity as an alternative to primary key?
In SQL Server, a non-clustered index contains the primary key at the leaf level. Designating a natural key as a primary key will make your indexes very large.
Jul
3
comment 3rd Normal Form violation?
Probably, but 3NF is not about partial dependencies :)
Jul
3
answered 3rd Normal Form violation?
Jul
2
awarded  Student
Jul
2
awarded  Scholar
Jul
2
accepted Default trace enabled but not active
Jul
2
comment Default trace enabled but not active
Thanks, disable and re-enable worked. I didn't use with override. The error logs did indeed show an out-of-space event.