26,060 reputation
656103
bio website
location United Kingdom
age
visits member for 2 years, 6 months
seen Apr 3 at 19:03

Email: stackoverflowmartinsmith@gmail.com


Feb
6
comment User defined table type with a check constraint
The CONSTRAINT CHK_AccountName is wrong. Table types can't have named constraints. Even removing it gives Invalid column name 'dbo'. though. I presume this isn't allowed.
Feb
6
comment User defined table type with a check constraint
This is only required for constraints that access multiple columns. Constraints that just reference a single column can be placed inline next to the column. Your rewrite still gives the same error Incorrect syntax near the keyword 'CONSTRAINT'.
Feb
5
revised What is the Difference between IN and Not IN performance wise?
edited tags
Feb
4
comment Maintaining Referential Integrity with a Filestream enabled database
Wouldn't the approach in this question work for you?
Feb
3
comment Skipping some data from Indexing in SQL Server
What is the table definition? What queries are you performing that use that index? E.g. Equality queries? like?
Feb
2
comment Error trying to open database
@JonSeigel - Bit different. This is a hidden instance to discourage people from connecting to it directly. Connecting to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query might work. Some details here
Jan
31
comment In READ COMMITTED isolation, is it possible to read the old value after the update?
Why don't you ask a question about the actual issue you are seeing? It would be useful to know what queries the other process is running and the update statement.
Jan
31
revised In READ COMMITTED isolation, is it possible to read the old value after the update?
added 449 characters in body
Jan
31
revised In READ COMMITTED isolation, is it possible to read the old value after the update?
added 826 characters in body
Jan
31
comment Numeric data type with variable significant digits
Why not just store it all as numeric(x,5) then have another column that indicates the original scale?
Jan
31
revised Numeric data type with variable significant digits
added 16 characters in body
Jan
31
answered In READ COMMITTED isolation, is it possible to read the old value after the update?
Jan
31
comment Does RAM taken up Shared Memory connection counts against Max Server Memory?
Network buffers consume memory as well!
Jan
30
comment Why are queries causing spill to tempdb?
The alert in the execution plan is new in 2012. Have you checked it wasn't spilling all along on the old server? Were you monitoring for this?
Jan
29
comment How can I most closely monitor this table in production to find why rows are disappearing?
@Kin - But to be clear that article doesn't indicate that fn_dblog exhibits the same problem. (just making the point explicitly as the names are very similar and could cause confusion)
Jan
29
comment How can I most closely monitor this table in production to find why rows are disappearing?
@Marian - That only applies to Profiler not server side tracing. When Profiler does it the data gets sent to the client then back again to the server to insert!
Jan
29
comment How can I most closely monitor this table in production to find why rows are disappearing?
@DenisT - It can give some details. example code here
Jan
29
comment Using unique non clustered index with unique clustered index
@mustaccio - True. I can think of a couple of situations where you might want this but there is no overlapping candidate key actually. A much narrower NCI on the same column as the CI might be justified in some cases. Also supertype/subtype pattern needs a redundant unique constraint for the FK.
Jan
29
comment Using unique non clustered index with unique clustered index
@mustaccio - Two unique indexes means two candidate keys.
Jan
29
comment Using unique non clustered index with unique clustered index
If you have overlapping candidate keys the table is not in BCNF.