|Nice Answer||Answer score of 10 or more. This badge can be awarded multiple times.|
gbn earned this badge 65 times
jan 2 at 17:08Retrieving row count without using Count function
sep 29 at 19:44Making a column immutable in MySQL
sep 12 at 5:48Safely deleting a SQL Server log file (.LDF)
sep 5 at 13:15The order of columns in a table
aug 24 at 5:26When to use TINYINT over INT?
jul 9 at 14:11Is database normalization dead?
jun 20 '12 at 20:46What does collation mean in database parlance?
jun 12 '12 at 6:57What is a Clustered Index?
may 24 '12 at 23:24Are there alternatives to the TOAD tool for SQL Server?
may 22 '12 at 3:38How can I tell what recovery model my SQL database has?
may 3 '12 at 17:50Why does NOT IN with a set containing NULL always return FALSE/NULL?
may 3 '12 at 13:35Would it be considered as a bad practice to have multiple nullable FKs on a table in SQL Server
apr 20 '12 at 12:34Plural vs Singular Table Name
apr 18 '12 at 7:13Performance difference for COALESCE versus ISNULL?
apr 11 '12 at 11:02Should developers be able to query production databases?
mar 6 '12 at 20:26Why can't I use NEWSEQUENTIALID() as the default value for my column?
mar 6 '12 at 14:26Poor SQL Server performance when management studio closed
feb 24 '12 at 15:34Justify NOT using (nolock) hint in every query
feb 23 '12 at 18:48How to store data in a database without tables?
feb 13 '12 at 16:50How are my SQL Server constraints being bypassed?
jan 5 '12 at 16:26Does a DBA need to know how to program in a system language besides SQL?
jan 5 '12 at 4:51How SQL Server handles concurrent requests?
jan 4 '12 at 15:45Do SQL Server stored procedures cache data results?
dec 29 '11 at 18:41check constraint does not work?
dec 27 '11 at 10:26How to the get current date without the time part
dec 6 '11 at 11:36What does `x` stand for in this query?
nov 28 '11 at 16:03Files - in the database or not?
nov 18 '11 at 20:12SQL Server load balancing
nov 18 '11 at 11:46Where can I find some guidance on index strategies?
nov 17 '11 at 17:54How to get the MAX row
nov 16 '11 at 16:18Which is better: identity columns or generated uinique id values?
nov 7 '11 at 23:23What standard should I follow when naming tables and views?
nov 4 '11 at 18:43Guarantee SQL Server Identity Columns that two consecutive values differ by constant increments?
oct 21 '11 at 14:12Passing array parameters to a stored procedure
oct 20 '11 at 18:05INT or CHAR for a Type Field
oct 13 '11 at 16:02Should you design the database before the application code is written?
oct 7 '11 at 21:23SQL Server schema intact but every record from every table is gone
oct 5 '11 at 14:00(post deleted or otherwise unavailable)
sep 29 '11 at 19:22How to use variables inside a select (SQL Server)?
sep 13 '11 at 14:53Can I determine if a stored procedure uses dynamic sql without parsing the definition?
sep 13 '11 at 0:01Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?
sep 5 '11 at 20:46Should Query Tuning be Proactive or Reactive?
sep 2 '11 at 20:39Why is there still a varchar data type?
aug 19 '11 at 4:32How often to backup the master database?
aug 11 '11 at 3:26Adding columns to production tables
aug 10 '11 at 14:46Does SQL Sentry Plan Explorer work?
jul 23 '11 at 5:08The use of NOT logic in relation to indexes
jun 9 '11 at 15:22The smallest backup possible … with SQL Server