Badge

 Nice Answer Answer score of 10 or more. This badge can be awarded multiple times.

Martin Smith earned this badge 33 times
2d ago
Why are Denali sequences supposed to perform better than identity columns?
may 2 at 16:07
Should I be alarmed by this NO JOIN PREDICATE warning?
apr 18 at 7:11
Varchar(Max) field cutting off data after 8000 characters SQL Server 2008
apr 5 at 11:38
Securely generate a UNIQUEIDENTIFIER in SQL Server
mar 17 at 10:30
Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
mar 13 at 13:54
how do I insert a default row?
feb 22 at 14:25
Why is using a table variable more than twice as fast as a #temp table in this specific case?
feb 19 at 14:39
Trigger in combination with transaction
feb 14 at 16:13
Why are non-digits LIKE [0-9]?
feb 4 at 5:13
Inclusion of ORDER BY on query that returns no rows drastically affects performance
dec 22 at 2:44
Deadlock error isn't returning the deadlock SQL
dec 5 at 18:26
Why does ALTER COLUMN to NOT NULL cause massive log file growth?
nov 14 at 0:21
Why does DELETE leave a lingering effect on performance?
nov 1 at 10:50
How can I prevent SSMS from re-writing my code when saving a view?
oct 20 at 8:37
Comparing Columns that can contain NULLS - is there a more elegant way?
oct 11 at 3:18
What does “*password------------” mean in a profile deadlock report?
sep 21 at 13:13
How do I read Query Cost, and is it always a percentage?
jul 19 at 8:16
Add a new Column and define its position in a table
jun 30 at 19:04
Sort order specified in primary key, yet sorting is executed on SELECT
jun 5 '12 at 1:24
Unexpected scans during delete operation using WHERE IN
apr 12 '12 at 0:47
What's the difference between a temp table and table variable in SQL Server?
mar 27 '12 at 14:10
Using Row_Number to find consecutive row count
mar 22 '12 at 12:58
SQL Server 2008 Change length of varchar on live prod table
mar 19 '12 at 15:57
Suddenly Slow Execution Plan for Stored Proc
mar 13 '12 at 7:53
Can you explain this execution plan?
mar 10 '12 at 14:00
(post deleted or otherwise unavailable)
feb 14 '12 at 10:04
Having a unique ID for 2 different tables
feb 4 '12 at 10:29
Create View in specified database with dynamic sql?
feb 3 '12 at 2:47
Does SQL Server have Date_Format function?
jan 17 '12 at 10:02
Determining how a schema change occurred?
jan 14 '12 at 17:42
Is NOLOCK always bad?
dec 22 '11 at 22:40
Using EXCEPT in a recursive common table expression
nov 11 '11 at 12:07
Why use both TRUNCATE and DROP?

Others with this badge