Tags » Microsoft SQL Server

%%Physloc%%- Virtual record locator in SQL server

Physloc acts as a virtual record locator in sql server.

In SQL server Read and Write operation happens from the 8 KB page.8 KB page has 8192 bytes of free space.Out of that 96 bytes are allocated for header information and 2 bytes for row offset.Here theĀ  row offset helps us to identify where the table records are located,which is defined as Physloc. 130 more words

Blogger Questions: What should I blog about?

Over the last four years I’ve blogged almost 400 times. It’s become a refuge, a resource, a source of pride, and a pleasure. I started out trying to build an on-line resume (just in case) and over time it’s evolved like crazy. 354 more words

Microsoft SQL Server

Is the network your last performance bottleneck?

Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options but they still have their limits). 501 more words

Microsoft SQL Server

Log File is Too Big!

–by Ginger Keys

Recently I had a client who, after speaking with their software vendor, became overly fearful of their database log files growing too big and taking up all of the disk space on their server. 1,181 more words

SQL Server

Altering a column in a large table: A case study

Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to share each of them and the results of those I tried. 958 more words

Microsoft SQL Server

Default database file sizes

It’s Chris Yates (b/t) birthday! (I think he just tured 19.) And in honor of his birthday we are writing blog posts! 312 more words

Microsoft SQL Server

List Index Columns

— By Lori Brown @SQLSupahStah

I was looking for a way to get info on the columns in indexes so that I could use the data to help enhance my index defrag routine. 412 more words

SQL Server