Home Dashboard Directory Help
Refine Search Results
Status
Votes
Total Votes (at least)
Workarounds
Total Workarounds (at least)
Validations
Total Validations (at least)
Comments
Total Comments (at least)
Time
Created in the last (days)
Updated in the last (days)
Product Search Results
Sort By:
You searched for: items submitted by LondonDBA1 for this product (signing in could show even more results)
Showing 1 - 4 of 4 Previous 1 Next

5
0
Sign in
to vote
From Connection: SQL Server
sys.dm_os_memory_clerks for type = MEMORYCLERK_SQLQUERYEXEC and sys.dm_os_memory_objects for type = MEMOBJ_COLUMNBATCH show ever increasing values when columnstore tables are integrity checked. For ex…
Created on 1/16/2015 (updated 8 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 1090203  | 
Closed
17
0
Sign in
to vote
From Connection: SQL Server
Set the model database to SIMPLE recovery. Create a new database and, as expected, its recovery model will show up as SIMPLE. Now backup the database. Then backup the transaction log. This last action…
Created on 9/28/2012 (updated 75 weeks ago) | 5 validations | 1 workaround | 6 comments | feedback id: 765315  | 
Closed
as Fixed Help for as Fixed
1
1
Sign in
to vote
From Connection: SQL Server
I'm using the trick of updating a column to itself to block concurrent access to a row. I'm not using any of the versioning isolation levels (ie no SI or RCSI). This is for the out-of-the-box read com…
Created on 4/28/2012 (updated 27 weeks ago) | 0 validations | 0 workarounds | 4 comments | feedback id: 739700  | 
Closed
as By Design Help for as By Design
1
0
Sign in
to vote
From Connection: SQL Server
The documenation for example C for FIRST_VALUE and the result set don't make sense. The DifferenceToPreviousQuarter column is actually showing the difference compared to the first quarter for the very…
Created on 11/24/2011 (updated 177 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 708188  | 
Closed
as Fixed Help for as Fixed
Showing 1 - 4 of 4 Previous 1 Next