|Nice Answer||Answer score of 10 or more. This badge can be awarded multiple times.|
Aaron Bertrand earned this badge 63 times
jun 14 at 17:14Stored procedures vs. inline SQL
jun 5 at 22:32Find procedures that haven't been called in <n> days
may 17 at 21:12Installation of SQL Server RAID 10 vs RAID 5
apr 30 at 4:24How to insert in a table with only an IDENTITY column?
mar 26 at 17:17T SQL Table Valued Function to Split a Column on commas
mar 17 at 7:27Combine column from multiple rows into single row
mar 12 at 15:42Sql Server - Best Practices for Growing Database Files
feb 27 at 17:36Is a join optimized to a where clause at runtime?
feb 18 at 14:06Are there disadvantages to contained databases?
feb 13 at 21:55Restrict access for Windows administrator
feb 7 at 21:21SQL Server 2012 - Always On
feb 4 at 23:24Reducing the size of a database
jan 29 at 20:30Is it ALWAYS possible to avoid cursor?
jan 25 at 21:55Is that a good idea to use one database for 50.000+ shops?
jan 10 at 21:37How do I add minutes to a time data type?
jan 10 at 12:17How much of a view is persisted when you create an index?
nov 28 at 4:37How does SQL Server order results when joins are used?
oct 18 at 22:27Where are Statistics physically stored in SQL Server?
oct 18 at 11:52Are these two queries logically equivalent?
oct 16 at 7:57mdf,ldf file attach problem?
oct 10 at 19:32Is there a reason to update statistics manually?
aug 31 at 15:02Why should a CTE start with a semi-colon?
aug 29 at 14:36Is it possible to limit the maximum disk usage for a user
aug 8 at 19:53Why are queries parsed in such a way that disallows the use of column aliases in most clauses?
aug 7 at 17:07Composing the “ultimate database maintenance script”
jul 25 at 17:40Why does ORDER BY not belong in a View?
jul 24 at 20:27Efficient way of changing VARCHAR to NVARCHAR fields in a large table in SQL Server 2008?
jul 20 '12 at 18:16Why do wildcards in GROUP BY statements not work?
jul 12 '12 at 21:18Restore SQL Server 2012 backup to a SQL Server 2008 database?
jun 25 '12 at 6:58Why is the SELECT clause listed first?
jun 19 '12 at 16:26Running total with count?
jun 15 '12 at 23:39Disallow new UDFs that contain a cursor
jun 12 '12 at 1:02How do you kick users out of a SQL Server 2008 database?
jun 11 '12 at 20:42Why are numbers tables “invaluable”?
jun 1 '12 at 16:47What database technologies do big search engines use?
may 18 '12 at 17:30How can I force SQL Server Management Studio to update metadata?
mar 14 '12 at 19:35DDL contention on TempDB
mar 14 '12 at 19:35why we can specify table names enclosing them with 
mar 14 '12 at 19:35Adding columns to production tables
mar 14 '12 at 19:35Is nested view a good database design?
mar 14 '12 at 19:25What's the difference between functions and stored procedures?
feb 16 '12 at 15:06Is there a way to force an index to stay in memory with SQL Server 2008?
feb 13 '12 at 22:12Does SQL Server read all of a COALESCE function even if the first argument is not NULL?
sep 19 '11 at 16:55Attach SQL Server 2008 R2 on SQL Server Express 2008
aug 31 '11 at 11:19Why shouldn't we allow NULLs?