Research on Recompilation and Rebuilding of Batch Execution Plain SQL Server 2012

Ai Wu Li

doi:10.4028/www.scientific.net/AMR.756-759.2055

Paper Titles

CloudDICOM: A Large-Scale Online Storage and Sharing System for DICOM Images
p.2037

Data Analysis and Suggestions of Supply and Marketing Cooperatives Industry in the Agricultural and Sideline Products Deep Management
p.2042

The Building of User Model of Personalized Learning Teaching System Based on Data Mining
p.2047

Concrete Shrinkage and Creep Effect Prediction Model and the Influence Factors Analysis
p.2051

Research on Recompilation and Rebuilding of Batch Execution Plain SQL Server 2012
p.2055

Identification of Pesticide Residues of Lettuce Leaves Based on LVQ Neural Network
p.2059

Synset Construction - Extending from Concepts Association of HNC to Lexical Semantic Web
p.2064

On Preservation of the Endangered Languages in Information Era: A Case Study of Tujia Language
p.2068

A Speech Signal Logarithmic Spectrum Amplitude Envelope Algorithm Analysis
p.2072

HomeAdvanced Materials ResearchAdvanced Materials Research Vols. 756-759Research on Recompilation and Rebuilding of Batch...

Research on Recompilation and Rebuilding of Batch Execution Plain SQL Server 2012

Abstract:

SQL Server supported execution of multiple SQL statements at a time, these statements as a whole is called a batch. The features of batch execution plan is different from that of single statement execution plan. This paper discussed the recompilation and the rebuilding of batch execution plan. By detailed experiments, it shown the differences between plan recompilation and rebuilding and the main events resulting in the plan recompilation and rebuilding.

You might also be interested in these eBooks

View Preview

Info:

Periodical:

Advanced Materials Research (Volumes 756-759)

Pages:

2055-2058

DOI:

https://doi.org/10.4028/www.scientific.net/AMR.756-759.2055

Citation:

Cite this paper

Online since:

September 2013

Authors:

Ai Wu Li

Keywords:

Batch Execution Plan Rebuilding, Batch Execution Plan Recompilation, SQL Server 2012

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

References

[1] MacLennan J, Tang Z H, Crivat B. Data mining with Microsoft SQL server 2008[M]. Wiley, (2011).

Google Scholar

[2] Kazemitabar S J, Demiryurek U, Ali M, et al. Geospatial stream query processing using Microsoft SQL Server StreamInsight[J]. Proceedings of the VLDB Endowment, 2010, 3(1-2): 1537-1540.

DOI: 10.14778/1920841.1921032

Google Scholar

[3] Larson P Å, Clinciu C, Hanson E N, et al. SQL server column store indexes[C]/Proceedings of the 2011 international conference on Management of data. ACM, 2011: 1177-1184.

DOI: 10.1145/1989323.1989448

Google Scholar

[4] Bernstein P A, Cseri I, Dani N, et al. Adapting microsoft SQL server for cloud covmputing[C]/Data Engineering (ICDE), 2011 IEEE 27th International Conference on. IEEE, 2011: 1255-1263.

DOI: 10.1109/icde.2011.5767935

Google Scholar

[5] Kagalwala R A, Thompson J P. Database schema for structured query language (SQL) server: U.S. Patent 7, 653, 652[P]. 2010-1-26.

Google Scholar

[6] Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Adam Machanic, Microsoft SQL Server 2008 Internals, 2009. 3.

Google Scholar

[7] Zhang Z, Wang G, Yang L, et al. Application of SQL Server in data mining[C]/Control and Decision Conference (CCDC), 2010 Chinese. IEEE, 2010: 521-524.

DOI: 10.1109/ccdc.2010.5498995

Google Scholar