user avatar
user avatar
user avatar
kacalapy
  • Member for 11 years, 6 months
  • Last seen more than 7 years ago
19 votes
3 answers
8k views

How can I tell what recovery model my SQL database has?

16 votes
3 answers
7k views

Should a log table get an id field or primary key?

15 votes
3 answers
5k views

Testing stored procedure scalability

11 votes
1 answer
3k views

How does SQL Server order results when joins are used?

11 votes
8 answers
3k views

Identity Columns or UDF that explicitly generates a unique id?

11 votes
3 answers
3k views

What is the best method to add error handling in SQL 2005 stored procs?

8 votes
2 answers
6k views

How do I replace this where clause with a join?

7 votes
1 answer
380 views

Why can't I call my UDF directly? Why do I need to qualify it 3 levels deep?

7 votes
2 answers
792 views

Most efficient way to return multiple aggregates in a single stored proc?

7 votes
2 answers
4k views

How to effectively query and aggregate a normalized SQL db?

6 votes
4 answers
108k views

Get counts grouped by month and year

6 votes
2 answers
211 views

How to script database validations?

6 votes
3 answers
1k views

Sub queries or joins?

5 votes
2 answers
2k views

How to index a many to many table most effectively

5 votes
2 answers
2k views

SQL Server 2005 : How to use pivot instead of a bunch of case statements?

5 votes
1 answer
904 views

whats best practice for Log Truncation in SQL Server?

4 votes
2 answers
2k views

How can i detect whom a person reports to using a self-referencing employee table?

4 votes
2 answers
34k views

How to get a boolean value into a SELECT operation based on another table?

4 votes
2 answers
5k views

stored proc to handle XML as input param for multiple record inserts

4 votes
2 answers
2k views

update stored proc ony fields that are passed to the proc and leaving others alone

3 votes
1 answer
257 views

Why doesn't FTS match any records?

3 votes
2 answers
400 views

Should SQL full text search match the value test2 when searching for test?

3 votes
1 answer
465 views

Implementing a PIVOT query

3 votes
1 answer
304 views

What's the best paradigm or design pattern for exception handling in a mission-critical DB driven web application?

2 votes
2 answers
2k views

SQL datatype choice for flagging a read/ unread message?

2 votes
3 answers
137 views

Is having a 92MB MDF with a 58MB LDF cobo ok? How do I manage the log to keep things running well?

2 votes
2 answers
1k views

How to group a resultset by day?

2 votes
2 answers
248 views

create a FTS in sql2005 on multile fields in multiple tables?

2 votes
2 answers
3k views

how to get avg() size by day using two decimal places

1 vote
2 answers
217 views

Can this SQL be made more efficient and combined into one select?