kacalapy

less info

network profile

669 reputation

212

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

summary answers questions tags badges favorites bounties reputation activity

34 Questions

votes activity newest

8	How can I tell what recovery model my SQL database has?
7	What is the best method to add error handling in SQL 2005 stored procs?
6	How to script database validations?
6	Should a log table get an id field or primary key?
6	Testing stored procedure scalability

view more

669 Reputation

+5	how to get avg() size by day using two decimal places
+5	How does SQL Server order results when joins are used?
+5	Get counts grouped by month and year
+5	How do I replace this where clause with a join?

view more

4 Answers

votes activity newest

2	What is the best way to filter or otherwise manipulate the results returned by a stored procedure?
2	What is a Clustered Index?
2	SQL Server 2005 : How to use pivot instead of a bunch of case statements?
2	Optimize this SQL query for performance

23 Tags

6 sql-server × 13	2 syntax × 3
4 sql × 9	2 clustered-index
2 sql-server-2005 × 25	2 interview-question
2 stored-procedures × 5	0 logs × 3
2 pivot × 4	0 database-design × 3

view more

13 Accounts

	Photography	3,246 rep	2067
	Stack Overflow	1,659 rep	41958
	Database Administrators	669 rep	212
	Home Improvement	439 rep	311
	Programmers	260 rep	17

10 Badges

recent class name

Popular Question × 4	Supporter
Yearling × 2	Scholar
Critic	Editor
Promoter	Student
Commentator	Teacher

0 Active bounties

active offered earned

This user has no active bounties

20 Votes Cast

all time			by type
19	up		0	question
1	down		20	answer

Technology			Life / Arts	Culture / Recreation	Science	Other
Stack Overflow Server Fault Super User Web Applications Ask Ubuntu Webmasters Game Development TeX - LaTeX	Programmers Unix & Linux Ask Different (Apple) WordPress Answers Geographic Information Systems Electrical Engineering Android Enthusiasts IT Security	Database Administrators Drupal Answers SharePoint User Experience Mathematica more (14)	Photography Science Fiction & Fantasy Seasoned Advice (cooking) Home Improvement more (13)	English Language & Usage Skeptics Mi Yodeya (Judaism) Travel Christianity Arqade (gaming) Bicycles Role-playing Games more (21)	Mathematics Cross Validated (stats) Theoretical Computer Science Physics more (7)	Stack Apps Meta Stack Overflow Area 51 Stack Overflow Careers

site design / logo © 2013 stack exchange inc; user contributions licensed under cc-wiki with attribution required

rev 2013.6.18.748

Database Administrators Stack Exchange works best with JavaScript enabled