Stack Exchange

gbn

Malta

Age: 43

aka Shawn

  • SQL Server Developer/DBA
  • MySQL Developer
  • British expat
  • Code monkey
top accounts reputation activity favorites subscriptions
Top Questions
Top Answers
201
“where 1=1” statement
stackoverflow.com

170
SQL update query using joins
stackoverflow.com

151
Count(*) vs Count(1)
stackoverflow.com

135
varchar vs nvarchar performance
stackoverflow.com

129
Best approach to remove time part of datetime in SQL Server
stackoverflow.com

111
Finding duplicate values in a SQL table
stackoverflow.com

71
SQL exclude a column using SELECT * [except columnA] FROM tableA?
stackoverflow.com

60
Turn off constraints temporarily
stackoverflow.com

52
Nested stored procedures containing TRY CATCH ROLLBACK pattern?
stackoverflow.com

47
How to get last inserted id?
stackoverflow.com

46
What is the difference between select count(*) and select count(any_non_null_column)?
dba.stackexchange.com

43
Why use the INCLUDE clause when creating an index?
stackoverflow.com

42
How do I insert multiple rows WITHOUT repeating the “INSERT INTO dbo.Blah” part of the statement?
stackoverflow.com

40
Imply bit with constant 1 or 0 in SQL Server
stackoverflow.com

38
Insert Update trigger how to determine if insert or update
stackoverflow.com

33
Get top 1 row of each group
stackoverflow.com

29
Using “GO” within a transaction
stackoverflow.com

28
SQL Server insert if not exists best practice
stackoverflow.com

28
Should you design the database before the application code is written?
dba.stackexchange.com

27
Fastest way to count exact number of rows in a very large table?
stackoverflow.com

27
Why is naming a table's Primary Key column “Id” considered bad practice?
programmers.stackexchange.com

26
TSQL Pivot without aggregate function
stackoverflow.com

26
Incorrect syntax near the keyword 'with'…previous statement must be terminated with a semicolon
stackoverflow.com

26
Using NOLOCK Hint in EF4?
stackoverflow.com

26
What are the arguments against or for putting application logic in the database layer?
dba.stackexchange.com

26
Why is there still a varchar data type?
dba.stackexchange.com

26
What is the difference in a developer's years of experience with a language?
programmers.stackexchange.com

25
Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?
dba.stackexchange.com

24
Which is better: Bookmark/Key Lookup or Index Scan
stackoverflow.com

24
Inserting rows into a table with one IDENTITY column only
stackoverflow.com

1 2 3 4 5 … 10