gbn

Switzerland

aka Shawn

DBA + SQL Developer + sysadmin
"Database Monkey"
Grumpy old man and British Economic Migrant

top accounts reputation activity subscriptions

SET NOCOUNT ON usage

sql sql-server tsql ado.net concurrency asked Sep 27, 2009 at 14:52

stackoverflow.com

142 votes

Possible to make MySQL use more than one core?

mysql performance innodb mysql-5.5 tuning asked Sep 12, 2011 at 14:59

dba.stackexchange.com

39 votes

How to deal with upvoted yet clearly wrong answers

feature-request answers wrong-answers asked Jul 24, 2009 at 6:42

meta.stackexchange.com

25 votes

SQL Server: How to permission schemas?

sql-server-2005 sql-server-2008 permissions schema encapsulation asked Feb 6, 2010 at 4:21

stackoverflow.com

12 votes

Exclude certain characters using RegEx

javascript regex asked Jul 14, 2009 at 20:15

stackoverflow.com

12 votes

SQL Server: filegroup for system tables only?

sql-server filegroups disk-structures asked Feb 20, 2011 at 17:33

dba.stackexchange.com

10 votes

Mono to SQL Server with Windows Auth

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

stackoverflow.com

9 votes

NULL parameters in scalar UDFs on MSSQL

sql-server short-circuiting user-defined-functions asked Feb 16, 2009 at 14:49

stackoverflow.com

8 votes

SQL Server stored procedure return code oddity

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

stackoverflow.com

8 votes

.net using IBM MQ without full MQ client install

.net websphere-mq ibm-mq asked Mar 24, 2011 at 13:30

stackoverflow.com

Top Answers

3672

Finding duplicate values in a SQL table

stackoverflow.com

1444

SQL update query using joins

stackoverflow.com

1044

How to turn IDENTITY_INSERT on and off using SQL Server 2008?

stackoverflow.com

957

Get top 1 row of each group

stackoverflow.com

681

Count(*) vs Count(1) - SQL Server

stackoverflow.com

631

SQL Server - Return value after INSERT

stackoverflow.com

630

Best approach to remove time part of datetime in SQL Server

stackoverflow.com

465

Why use the INCLUDE clause when creating an index?

stackoverflow.com

348

Insert multiple rows WITHOUT repeating the "INSERT INTO ..." part of the statement?

stackoverflow.com

346

How do I escape a percentage sign in T-SQL?

stackoverflow.com

339

"where 1=1" statement

stackoverflow.com

322

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

stackoverflow.com

302

How to connect an existing SQL Server login to an existing SQL Server database user of same name

stackoverflow.com

286

Fastest way to count exact number of rows in a very large table?

stackoverflow.com

270

How to get last inserted id?

stackoverflow.com

261

Imply bit with constant 1 or 0 in SQL Server

stackoverflow.com

255

sql ORDER BY multiple values in specific order?

stackoverflow.com

243

how to increment integer Columns value by 1 in SQL

stackoverflow.com

241

SQL Server insert if not exists best practice

stackoverflow.com

239

Turn off constraints temporarily (MS SQL)

stackoverflow.com

236

What are the main performance differences between varchar and nvarchar SQL Server data types?

stackoverflow.com

222

Count number of records returned by group by

stackoverflow.com

218

Is there a way to list open transactions on SQL Server 2000 database?

stackoverflow.com

209

count(*) vs count(column-name) - which is more correct?

stackoverflow.com

202

How to store phone numbers on MySQL databases?

stackoverflow.com

198

Insert Update trigger how to determine if insert or update

stackoverflow.com

197

How to insert default values in SQL table?

stackoverflow.com

181

How to select only the first rows for each unique value of a column?

stackoverflow.com

154

Count based on condition in SQL Server

stackoverflow.com

144

Inserting rows into a table with one IDENTITY column only

stackoverflow.com