Martin Smith

less info
meta site favicon meta user | stack exchange network profile network profile
17,487 reputation
43578
bio website
location United Kingdom
age
visits member for 1 year, 7 months
seen 2 hours ago
stats profile views 1,395

Email: stackoverflowmartinsmith@gmail.com


209 Answers

newest activity votes
200
What's the difference between a temp table and table variable in SQL Server?
27
Why use both TRUNCATE and DROP?
24
Is NOLOCK always bad?
17
how do I insert a default row?
17
Determining how a schema change occurred?
16
Why does DELETE leave a lingering effect on performance?
15
Why are non-digits LIKE [0-9]?
15
Using EXCEPT in a recursive common table expression
14
How can I prevent SSMS from re-writing my code when saving a view?
14
Unexpected scans during delete operation using WHERE IN
14
SQL Server 2008 Change length of varchar on live prod table
14
Can you explain this execution plan?
13
Why does ALTER COLUMN to NOT NULL cause massive log file growth?
13
Using Row_Number to find consecutive row count
12
Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
12
Trigger in combination with transaction
12
Should I be alarmed by this NO JOIN PREDICATE warning?
12
Why is using a table variable more than twice as fast as a #temp table in this specific case?
11
Securely generate a UNIQUEIDENTIFIER in SQL Server
11
Deadlock error isn't returning the deadlock SQL
11
Add a new Column and define its position in a table
11
Create View in specified database with dynamic sql?
11
Does SQL Server have Date_Format function?
11
Suddenly Slow Execution Plan for Stored Proc
10
What does “*password------------” mean in a profile deadlock report?
10
Sort order specified in primary key, yet sorting is executed on SELECT
10
Varchar(Max) field cutting off data after 8000 characters SQL Server 2008
10
Comparing Columns that can contain NULLS - is there a more elegant way?
10
Having a unique ID for 2 different tables
10
Inclusion of ORDER BY on query that returns no rows drastically affects performance
1 2 3 4 5 … 7