meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | 38 | |
| visits | member for | 1 year, 9 months |
| seen | 10 hours ago | |
| stats | profile views | 24 |
MSSQL DBA and FirebirdSQL Database Developer
|
May 7 |
comment |
pros/cons of different ways to store whether a record is one of two options? Good catch! I never thought of that hypothesis on the question, but it's really the right answer since all the bases are covered up. |
|
Feb 21 |
answered | Manually set log file size after shrink SQL Server 2008 R2 |
|
Feb 21 |
comment |
Manually set log file size after shrink SQL Server 2008 R2 @AaronBertrand - I agree with you in this. Log backup is nice for those who want almost 0 lost data. In this case, appear that some never changed the default recovery mode of model database........ |
|
Nov 30 |
comment |
We are running database maintenace with indexing the system, indexing fails due to locking? @Laurence: maybe they does not have Enterprise Edition? |
|
Oct 31 |
revised |
Query performance of a NULL vs an empty ('') varchar in SQL Server 2012 suggestions to solve the problem added |
|
Oct 31 |
answered | Query performance of a NULL vs an empty ('') varchar in SQL Server 2012 |
|
Oct 30 |
comment |
Query performance of a NULL vs an empty ('') varchar in SQL Server 2012 What is the distribution of values on that varchar column? Is empty string is, for example, a third of the total values on the column? More? Less? We need more information... |
|
Oct 23 |
comment |
What can speed up a SQL count query? @JonSeigel - My $0,05: Normal clustered indexes on normal table created offline applies an Sch-M lock on table. On a view, of course it's not needed but this means an alteration on the Create Index operation to create an special case for indexed view - which was done for SQL2012. IMHO, of course. |
|
Oct 23 |
awarded | Benefactor |
|
Oct 23 |
awarded | Scholar |
|
Oct 23 |
accepted | How to troubleshoot orm queries interfering with other applications |
|
Oct 23 |
comment |
How to troubleshoot orm queries interfering with other applications Seems the most aligned to the question, although the others got interesting info too. This one brough an way to enhance traceability using an MSSQL feature. |
|
Oct 18 |
comment |
How to troubleshoot orm queries interfering with other applications Seems you got the nearest so far. Have you tested if that bytes appear on "Binary data" of sql server profiler? |
|
Oct 17 |
comment |
How to troubleshoot orm queries interfering with other applications @dezso: see edit. |
|
Oct 17 |
revised |
How to troubleshoot orm queries interfering with other applications clarifying objectives |
|
Oct 16 |
comment |
How to troubleshoot orm queries interfering with other applications Seems you didn't got it. I don't want the SQL query that caused the problem. Profiler already gave me that (or those). What I looking for is the process to find the LINQ query(or queries) that are creating the problem (there's no SQL in the application) from a post-morten log (like Profiler). |
|
Oct 16 |
awarded | Promoter |
|
Oct 15 |
comment |
How to troubleshoot orm queries interfering with other applications Interesting... No one even risked an answer... |
|
Oct 9 |
comment |
Schema blocking in READ_COMMITTED_SNAPSHOT @AlexKuznetsov: you think the OP have an unindexed FK on a big table causing table scans? |
|
Oct 9 |
revised |
Schema blocking in READ_COMMITTED_SNAPSHOT clarifying reference |
