gbn

Malta

Age: 42

aka Shawn

SQL Server Developer/DBA
MySQL Developer
British expat
Code monkey

top accounts reputation activity favorites subscriptions

SET NOCOUNT ON usage

sql sql-server tsql ado.net concurrency asked Sep 27 '09 at 14:52

stackoverflow.com

17 votes

How to deal with upvoted yet clearly wrong answers

feature-request answers wrong-answers asked Jul 24 '09 at 6:42

meta.stackoverflow.com

13 votes

SQL Server: How to permission schemas?

sql-server-2005 sql-server-2008 permissions schema encapsulation asked Feb 6 '10 at 4:21

stackoverflow.com

10 votes

Resolve cross-site links to question title

feature-request hyperlinks site-crossover asked Oct 4 '11 at 16:29

meta.stackoverflow.com

8 votes

Possible to make MySQL use more then one core

mysql performance innodb tuning asked Sep 12 '11 at 14:59

dba.stackexchange.com

7 votes

Mortarboard badge misnamed?

discussion badges asked Dec 8 '09 at 19:17

meta.stackoverflow.com

7 votes

SQL Server: filegroup for system tables only?

sql-server filegroups disk-structures asked Feb 20 '11 at 17:33

dba.stackexchange.com

6 votes

SQL Server error handling: exceptions and the database-client contract

sql-server-2005 tsql sql-server-2008 exception stored-procedures asked Apr 17 '09 at 19:42

stackoverflow.com

6 votes

SQL Server stored procedure return code oddity

sql-server tsql stored-procedures error-handling asked Jun 3 '10 at 10:51

stackoverflow.com

6 votes

Mono to SQL Server with Windows Auth

sql-server mono windows-authentication asked May 2 at 12:10

stackoverflow.com

Top Answers

162

“where 1=1” statement

stackoverflow.com

Count(*) vs Count(1)

stackoverflow.com

varchar vs nvarchar performance

stackoverflow.com

SQL update query using joins

stackoverflow.com

Best approach to remove time part of datetime in SQL Server

stackoverflow.com

SQL exclude a column using SELECT * [except columnA] FROM tableA?

stackoverflow.com

What is the difference between select count(*) and select count(any_non_null_column)?

dba.stackexchange.com

Nested stored procedures containing TRY CATCH ROLLBACK pattern?

stackoverflow.com

Turn off constraints temporarily

stackoverflow.com

What is the difference in a developer's years of experience with a language?

programmers.stackexchange.com

Why is naming a table's Primary Key column “Id” considered bad practice?

programmers.stackexchange.com

Why use the INCLUDE clause when creating an index?

stackoverflow.com

Imply bit with constant 1 or 0 in SQL Server

stackoverflow.com

How to execute SQL against all DBs on a Server

dba.stackexchange.com

Poor SQL Server performance when management studio closed

dba.stackexchange.com

What are the arguments for and against a network policy where the sys admin knows users passwords?

serverfault.com

Why is a UDF so much slower than a subquery?

stackoverflow.com

Using “GO” within a transaction

stackoverflow.com

Insert Update trigger how to determine if insert or update

stackoverflow.com

Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?

dba.stackexchange.com

Should you design the database before the application code is written?

dba.stackexchange.com

Does a DBA need to know how to program in a system language besides SQL?

dba.stackexchange.com

Which is better: Bookmark/Key Lookup or Index Scan

stackoverflow.com

How to get last inserted id?

stackoverflow.com

What are the arguments against or for putting application logic in the database layer?

dba.stackexchange.com

Why is there *still* a varchar data type?

dba.stackexchange.com

Does COUNT(*) always return a result?

stackoverflow.com

What's the best to check if item exist or not: Select Count(ID)OR Exist(…)?

stackoverflow.com

TSQL Pivot without aggregate function

stackoverflow.com

SQL JOIN: is there a difference between USING, ON or WHERE?

stackoverflow.com