User kacalapy - Database Administrators Stack Exchange

bio	website	stackoverflow.com
	location	New York, NY
	age	36
visits	member for	2 years, 4 months
	seen	Feb 19 at 16:24
stats	profile views	34

	669 reputation	bio	website	stackoverflow.com	visits	member for	2 years, 4 months
212 badges		location	New York, NY		seen	Feb 19 at 16:24

8

votes

3

answers

515

views

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

sql-server sql-server-2005

may 22 '12 at 2:16 Jon Seigel 7,353

4

7

votes

3

answers

2

kviews

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

mar 1 '12 at 21:25 Phil Helmer 246

6

votes

2

answers

195

views

How to script database validations?

sql-server sql

mar 5 at 8:01 Chris Travers 5,616

1

6

votes

2

answers

320

views

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

database-design primary-key logs

oct 9 at 16:32 Jon Seigel 7,353

3

6

votes

3

answers

829

views

Testing stored procedure scalability

sql-server performance performance-testing testing scalability

oct 2 '11 at 18:25 Mark Storey-Smith 19.4k

1

6

votes

2

answers

1

kviews

How to effectively query and aggregate a normalized SQL db?

sql-server-2005 query

may 14 '11 at 4:02 jcolebrand♦ 3,847

6

votes

2

answers

496

views

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

sql-server-2005 stored-procedures aggregate

may 14 '11 at 4:01 jcolebrand♦ 3,847

5

votes

1

answer

150

views

How does SQL Server order results when joins are used?

sql-server sql order-by

nov 28 at 6:31 Paul White 8,415

5

votes

3

answers

900

views

Sub queries or joins?

sql-server sql-server-2005

dec 3 '11 at 0:00 DBA-K 11

1

5

votes

6

answers

911

views

Which is better: identity columns or generated uinique id values?

sql-server-2005

mar 10 '11 at 4:01 jcolebrand♦ 3,847

5

votes

1

answer

303

views

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

sql-server-2005 syntax

feb 14 '11 at 22:42 jcolebrand♦ 3,847

1

4

votes

1

answer

650

views

whats best practice for Log Truncation in SQL Server?

sql-server-2005 logs

feb 28 '11 at 16:27 gbn 43.4k

1

4

votes

2

answers

671

views

How do I replace this where clause with a join?

sql-server-2005

feb 14 '11 at 19:08 gbn 43.4k

3

votes

2

answers

720

views

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

sql-server-2005 syntax pivot

aug 16 '11 at 5:41 RolandoMySQLDBA 42.9k

1

3

votes

2

answers

2

kviews

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

sql-server-2005 xml

may 29 '11 at 8:14 gbn 43.4k

3

votes

2

answers

846

views

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

sql-server-2005 cte

feb 10 '11 at 14:09 Matt M 2,078

1

2

votes

3

answers

520

views

Get counts grouped by month and year

sql-server sql-server-2008 sql

feb 4 at 9:52 brykneval 115

2

votes

2

answers

229

views

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

sql-server sql

nov 28 at 17:39 Aaron Bertrand♦ 38k

1

2

votes

2

answers

285

views

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

sql sql-server-2005 stored-procedures

jun 7 '11 at 8:58 Andrew Bickerton 1,220

2

votes

2

answers

330

views

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

sql-server-2005 full-text-search

may 14 '11 at 17:59 bernd_k 3,813

2

votes

1

answer

220

views

Why doesn't FTS match any records?

sql-server-2005 full-text-search

may 13 '11 at 6:46 Coder Hawk 2,170

2

votes

2

answers

480

views

SQL datatype choice for flagging a read/ unread message?

sql-server performance database-design

apr 21 '11 at 10:19 ndefontenay 434

2

votes

2

answers

497

views

How to index a many to many table most effectively

sql-server-2005

mar 10 '11 at 19:04 Jeff 820

1

vote

2

answers

157

views

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

sql-server sql

nov 30 at 4:53 孔夫子 2,415

1

vote

2

answers

547

views

why does my pivot give me an error?

sql-server-2005 pivot

jan 4 '12 at 4:29 Community♦ 1

1

vote

2

answers

1

kviews

how to get a boolean value into a select based on another table?

sql-server-2005

may 18 '11 at 13:18 Andrew Bickerton 1,220

1

vote

2

answers

228

views

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

full-text-search

may 10 '11 at 4:51 RThomas 1,488

1

vote

1

answer

251

views

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

sql-server-2005 database-design stored-procedures

apr 20 '11 at 16:29 Gaius 7,241

1

vote

2

answers

499

views

How to group a resultset by day?

sql-server-2005 query

mar 3 '11 at 20:25 John DaCosta 370

1

vote

3

answers

123

views

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

sql-server-2005 logs

mar 1 '11 at 23:36 jcolebrand♦ 3,847

kacalapy

34 Questions