User kacalapy - Database Administrators Stack Exchange

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

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

8

votes

3

answers

506

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 6,863

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 236

6

votes

2

answers

192

views

How to script database validations?

sql-server sql

mar 5 at 8:01 Chris Travers 5,406

1

6

votes

2

answers

286

views

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

database-design primary-key logs

oct 9 at 16:32 Jon Seigel 6,863

3

6

votes

3

answers

800

views

Testing stored procedure scalability

sql-server performance performance-testing testing scalability

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

1

6

votes

2

answers

978

views

How to effectively query and aggregate a normalized SQL db?

sql-server-2005 query

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

6

votes

2

answers

486

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,659

5

votes

3

answers

894

views

Sub queries or joins?

sql-server sql-server-2005

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

1

5

votes

6

answers

886

views

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

sql-server-2005

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

5

votes

1

answer

300

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,659

4

votes

1

answer

144

views

How does SQL Server order results when joins are used?

sql-server sql order-by

nov 28 at 6:31 Paul White 7,865

1

4

votes

1

answer

641

views

whats best practice for Log Truncation in SQL Server?

sql-server-2005 logs

feb 28 '11 at 16:27 gbn 42k

1

4

votes

2

answers

647

views

How do I replace this where clause with a join?

sql-server-2005

feb 14 '11 at 19:08 gbn 42k

3

votes

2

answers

703

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 41.2k

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 42k

3

votes

2

answers

823

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 1,963

1

2

votes

3

answers

376

views

Get counts grouped by month and year

sql-server sql-server-2008 sql

feb 4 at 9:52 brykneval 115

1

2

votes

2

answers

280

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,200

2

votes

2

answers

325

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,743

2

votes

1

answer

219

views

Why doesn't FTS match any records?

sql-server-2005 full-text-search

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

2

votes

2

answers

467

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

495

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

156

views

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

sql-server sql

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

1

vote

2

answers

214

views

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

sql-server sql

nov 28 at 17:39 Aaron Bertrand 35.3k

1

vote

2

answers

509

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,200

1

vote

2

answers

225

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

248

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,167

1

vote

2

answers

485

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

122

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,659

kacalapy

34 Questions