Stack Exchange

Joe Stefanelli

New Lenox, IL

linkedin.com/in/joestefanelli

Age: 45

I am a SQL Server developer/administrator. I've been working with SQL Server since 1999, starting with version 7.0 and every version since. Prior to that, I worked with Informix in an HP-UX environment.

Microsoft Certified

  • MCITP - Database Developer 2008
  • MCITP - Database Administrator 2008
  • MCSD

profile for Joe Stefanelli on Stack Exchange, a network of free, community-driven Q&A sites

top accounts reputation activity favorites subscriptions
Top Questions
No questions with score of 5 or more
Top Answers
59
Nested select statement in SQL Server
stackoverflow.com

50
What is the (craziest, stupidest, silliest) thing a client/boss asked you to do?
programmers.stackexchange.com

49
Need to list all triggers in SQL Server database with table name and table's schema
stackoverflow.com

37
What is the significance of 1/1/1753 in SQL Server?
stackoverflow.com

20
Can I create a named default constraint in an add column statement in SQL Server?
stackoverflow.com

20
SQL Server list of insert identities
stackoverflow.com

19
SQL Stored Procedure set variables using SELECT
stackoverflow.com

19
The ALTER TABLE statement conflicted with the FOREIGN KEY constrain
stackoverflow.com

18
MySql insert the results of a select
stackoverflow.com

17
How do you get SQL to recognize WHERE column = NULL?
stackoverflow.com

15
How to pass in parameters to a SQL Server script called with sqlcmd?
dba.stackexchange.com

14
Conditional NOT NULL case SQL
stackoverflow.com

14
how can i create a tagging system using php and mysql?
stackoverflow.com

14
SQL: Select dynamic column name based on variable
stackoverflow.com

14
SQL Server 2005 'between' operator behavior - bug or feature?
stackoverflow.com

14
Equivalent of MSSQL IDENTITY Column in MySQL
stackoverflow.com

14
How could multiple people work on one website?
programmers.stackexchange.com

13
How to add a new schema to sql server 2008?
stackoverflow.com

13
Cannot create index on view 'View_Table_Name' because the view is not schema bound
stackoverflow.com

12
How to use table variable in a dynamic sql statement?
stackoverflow.com

12
Can SQL Server automatically read from more than one table if data spans more than one table without modifying the query?
stackoverflow.com

12
GROUP_CONCAT comma separator - MySQL
stackoverflow.com

11
SQL update query syntax with inner join
stackoverflow.com

11
To CTE or not to CTE
stackoverflow.com

11
Differences between xp_instance_RegRead and xp_RegRead
stackoverflow.com

11
matching one character in mysql in place of %
stackoverflow.com

11
SQL 2008 SQL Server Agents Jobs, how to populate email for Notifications
stackoverflow.com

11
Selectively delete mostly duplicate records from MySQL
stackoverflow.com

10
SQL Server 2008: how do I grant privileges to a username?
stackoverflow.com

10
sql server 2008: setting default location for mdf/ldf
stackoverflow.com

1 2 3 4 5 … 10