gbn

less info
meta site favicon meta user | stack exchange network profile network profile
42,464 reputation
353105
bio website
location Malta
age 43
visits member for 2 years, 4 months
seen 3 hours ago
stats profile views 2,357

aka Shawn

  • SQL Server Developer/DBA
  • MySQL Developer
  • British expat
  • Code monkey

784 Answers

newest activity votes
47
What is the difference between select count(*) and select count(any_non_null_column)?
28
Should you design the database before the application code is written?
27
Why is there still a varchar data type?
26
What are the arguments against or for putting application logic in the database layer?
25
Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?
24
How to the get current date without the time part
22
Poor SQL Server performance when management studio closed
22
Does a DBA need to know how to program in a system language besides SQL?
22
How to execute SQL against all DBs on a Server
21
The order of columns in a table
21
Where can I find some guidance on index strategies?
17
Adding columns to production tables
17
SQL Server load balancing
16
Performance difference for COALESCE versus ISNULL?
16
INT or CHAR for a Type Field
16
What are the consequences of setting varchar(8000)?
15
Passing array parameters to a stored procedure
14
Why does NOT IN with a set containing NULL always return FALSE/NULL?
14
Plural vs Singular Table Name
14
Do SQL Server stored procedures cache data results?
14
Does SQL Sentry Plan Explorer work?
13
What is a Clustered Index?
13
Guarantee SQL Server Identity Columns that two consecutive values differ by constant increments?
13
Should developers be able to query production databases?
13
check constraint does not work?
13
Should Query Tuning be Proactive or Reactive?
13
What are the top 3 performance Issues that you encounter with your SQL Servers?
13
The use of NOT logic in relation to indexes
13
Files - in the database or not?
13
Which is better: identity columns or generated uinique id values?
1 2 3 4 5 … 27