27,122 reputation
660112
bio website
location United Kingdom
age
visits member for 2 years, 10 months
seen 12 hours ago

Email: stackoverflowmartinsmith@gmail.com


17h
comment What happens during “big” inserts on a table with a clustered composite key?
RE: Will SQL "move" the existing rows to maintain the clustering. No. It will get fragmented and you would need to reorganize/rebuild the index to regain it. Demo of that here
1d
comment Change rowguidcol property to a different column
@wBob - Of course! That makes sense. Unfortunately my hasty DV is locked in unless this answer is edited. But it could do with editing anyway to acknowledge the existence of ALTER TABLE MyTable ALTER COLUMN Col1 DROP ROWGUIDCOL; ALTER TABLE MyTable ALTER COLUMN Col2 ADD ROWGUIDCOL;
1d
comment Change rowguidcol property to a different column
This isn't the case. The ROWGUIDCOL can be removed from/added to columns.
Jul
25
answered Get complete value of varchar(max) field - SQL Server 2005
Jul
24
comment How do I place leading zeros for numbers less than 10 without affecting those 10+?
@user44339 SQL Server doesn't have any such function.
Jul
23
answered Why is my select statement so slow?
Jul
23
comment Why is my select statement so slow?
What does SET STATISTICS IO ON;SET STATISTICS TIME ON; then running the query and waiting for it to finish show?
Jul
23
comment Why is my select statement so slow?
Whilst the query is running can you look in sys.dm_os_waiting_tasks to see if it is blocked?
Jul
22
awarded  Enlightened
Jul
22
awarded  Nice Answer
Jul
21
comment Finding last time table was updated?
@SeanPerkins - See edited version
Jul
21
revised Finding last time table was updated?
added 105 characters in body
Jul
16
comment Is it possible for SQL Server to miss rows on a select * where PK = “value” query
@BrentOzar Craig Freedman has a similar demo for read committed here but don't think you could get a PK to return null with this type of issue.
Jul
13
comment Adding warning with sp_add_alert doesn't work with “Greater Than” and SQL Server 2014
I don't have 2014 installed at the moment. Does msdb.sys.sp_helptext 'dbo.sp_verify_performance_condition' shed any light on it? The relevant section in 2012 looks like this i.stack.imgur.com/W0rX6.png
Jul
13
comment Get the first and last names of all employee who entered the project at the same time as at least one other employee
Please provide the definition of the tables involved. It is not possible to answer this question at the moment unless we guess the existence of an EmployeeID column (and the name of it) in both tables.
Jul
11
comment Why a select from the tables, joined by a CASE statement, could be 7x slower?
What are your table definitions and execution plans? You mention indexes but your sample DDL doesn't contain any.
Jul
11
awarded  Announcer
Jul
8
comment How to update ID=null values in table to incremental counter values?
@ErikHart - Er. What? It doesn't look like (or perform anything like) a cursor...
Jul
2
awarded  Curious
Jul
1
awarded  Nice Question