11,367 reputation
21848
bio website jonseigel.com
location London, Canada
age 30
visits member for 2 years, 8 months
seen 2 hours ago

SQL Server database developer and DBA.

In my spare time, I enjoy juggling, playing guitar, and working out.

VoluntaryDBA: Blog | YouTube Channel | Twitter | Facebook

Business/consulting inquiries: jon@jonseigel.com, @JonSeigel


3h
comment Optimistic Paging and separate query for COUNT?
Okay, is the data mostly static, or is it changing frequently?
3h
comment Restoring differential backup creates DEFUNCT log file?
Could you please show us the statements you're using to do the backups and restores?
3h
comment Optimistic Paging and separate query for COUNT?
How many rows are in the Products table, and how frequently is the data in that table changing?
5h
comment Index is not used with same Query on two Servers
Index usage stats are reset when the server is restarted, and includes all activity on the server. It's possible there was some other usage of these indexes besides the query you ran. Soooo many variables here...
5h
reviewed Approve suggested edit on Get first login-Hit on huge table
6h
comment Can comments in stored procedures cause problems
It may not be related to this problem, but I'm going to throw in this link to one of my blog posts because IMO block comments should be used as a standard practice anyway. voluntarydba.com/post/2012/09/18/…
16h
comment Copy+Pasting currency value from SSMS 2012 to excel does not complete or calculate new value
Try Paste Special as values in Excel.
1d
comment Get first login-Hit on huge table
Do you need to do this once, or repeatedly? If the latter, at what interval? Even by constructing an efficient SQL statement against the table, this is not going to scale if you need the information very frequently.
1d
comment Clustered composite key high fragmentation and fill factor
How many rows do you expect will be in the table over time? For a really small table, fragmentation is irrelevant.
1d
reviewed Approve suggested edit on Programatically copying data from table from offline database to online database
1d
comment Programatically copying data from table from offline database to online database
There are lots of ways to do this. Can you tell us more about what you're doing with the database? For example, do you need to read the secondary while the first is still read/write? Do you need to be able to write to the secondary as well? Are there any data transformations necessary between them?
Apr
12
revised Reference assembly in sqlproj not being deployed to server
edited tags
Apr
12
answered Reference assembly in sqlproj not being deployed to server
Apr
11
comment Reference assembly in sqlproj not being deployed to server
Hmmm... ours is set to False, and Model Aware is set to True, and we get a CREATE ASSEMBLY in the output. Maybe try those settings and see what happens?
Apr
11
comment SMS Suggesting covering all columns in an index?
Depending on the workload, it may be beneficial to change the clustered index to be on a key that leads with the foreign key column.
Apr
11
comment Multi-victim deadlock in SQL Server
Okay, great! You're welcome.
Apr
10
comment Multi-victim deadlock in SQL Server
Hmmm... I'm not sure if the deadlock monitor will kill more than one process at a time, because it would have to re-evaulate the lock hierarchy after every kill. There may be a second deadlock detection and kill of the process on the left; check to see if that one was captured in a separate report (note that it may be several seconds after this one).
Apr
9
comment Multi-victim deadlock in SQL Server
The graph in the image has one victim. We would need to see the XML behind the graph to analyze the situation.
Apr
9
revised Multi-victim deadlock in SQL Server
Embed image
Apr
8
comment When is transaction removed from sys.dm_tran_active_transactions?
Do you have transactions doing a lot of work, and getting interrupted in the middle?