I'm writing a C# program and it needs to read SQL Server data pages. Right now what I'm doing is using SQL Server's DBCC PAGE command to get this information and then parse the result. When the page number is huge, the performance is not very good. I want to know is there any .NET API that allows me to read SQL Server data pages? I searched around SQL Server's SMO documentation but didn't find anything interesting.
Are there any .NET API to read SQL Server data pages?
68 views Asked by Just a learner At
0
There are 0 answers
Related Questions in SQL-SERVER
- Dynamic query creation with Array like implementation
- 'pyodbc.Cursor' object has no attribute 'callproc', mssql with django
- Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, ${SPRING_DATASOURCE_URL}: GitHub Actions
- PHP Laravel SQLServer could not find driver
- Upsert huge amount of data by EFCore.BulkExtensions
- How to locate relevant tables or columns in a SQL Server database
- Cannot delete SQL datafile (.mdf) as its currently in use
- Writing query in CTE returning the wrong output
- Group By Sum and without Group by sum Amount is different
- plan_handle is always different for each query in SQL Server Cache
- Adding a different string to a table fails
- The specified data type in the EF modelBuilder doesn't correspond to the one that is created
- SQL71561: SqlComputedColumn: When column selected
- How to Solve Error Associated with Trusted Authority
- SQL Server Data Model and Insert Performance
Related Questions in DBCC
- Should I stop replication logreader and distribution jobs during database maintenance (reindexing, updating stats, and checkdb)?
- A database snapshot cannot be created because it failed to start. The storage usage for the managed instance cannot exceed (1048576) MBs
- DBCC - cc_bulkinvoice - A BulkInvoice's total transaction amount should be equal to the sum of all its items' amounts
- Attempt to fetch logical page (6:948264) in database 7 failed. It belongs to allocation unit 72057596882452480 not to 72057595956822016
- SSAS corrupt string store data file for one of the table columns error
- DBCC CLONEDATABASE exception 12605 : Failed to create snapshot database
- Creating table with different columns depending on condition (which is SQL version)
- If DBCC printed error messages, contact your system administrator: operand type clash on index rebuild
- Weird behavior of DBCC CHECKIDENT with RESEED in a rolled-back transaction
- Are there any .NET API to read SQL Server data pages?
- DBCC SHOWCONTIG returns 2 rows against certain tables
- DBCC CHECKDB did not return a result set in Java ( MS SQL )
- SQL Server :: FULL backup not recorded in msdb.dbo.backupset and log file unusually large
- Capture content from Messages Tab SSMS
- Sql Database giving error message while running DBCC CHECKDB()
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)