Can you please exaplin me the architecture / building blocks for SQL Server 2005 (Like Files / Pages / File Groups / Table Spaces / Schemas etc) to know how SQL Server was built ? This will help me a lot to understand the basics of SQL Server to know how it is working...just curious.
this is a really good explaination for Files and File Groups....http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=42&rl=1
The SQL Server database page size is 8 KB. Each page contains
While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted? Many believe this is the case.
Let us try to examine for ourselves with an example.
To get started, use the following script, wh…
Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question.
*Log into your Experts Exchange account
*Find the question you want to Request Attention for
*Go to the e…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…