SQL Data Storage « SQL Server Journey with SQL Authority

Archive for the ‘SQL Data Storage’ Category

SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device . Operating system error 5(Access is denied.)

Posted in Technology, SQL Server, SQL, SQL Query, SQL Error Messages, SQL Tips and Tricks, SQL Authority, Pinal Dave, T SQL, SQL Scripts, SQL Backup and Restore, SQL Data Storage, SQLServer, PostADay on April 13, 2011 | 11 Comments »

Recently I formatted my computer and installed fresh SQL Server in it. I installed AdventureWorks database in my database. Once done I wanted to run few test scripts on my database. Just like every DBA, I decided to take backup of my database – this way I can restore it back to attain original database [...]

Read Full Post »

SQL SERVER – 32 Bit – 64 Bit – HTML5 – Database Backup Restore

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Data Storage, SQL Humor, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on March 27, 2011 | 9 Comments »

During TechEd India I was attending HTML5 session along with regular Database sessions. Couple of attendees were discussing database there and I find the incidence very interesting. Note: Please take the whole discussion keeping humor as primary. There is no incident to disrespect anybody. Attendee1: I wonder if this HTML5 works on 64-bit machine – [...]

Read Full Post »

SQL SERVER – Computed Column – PERSISTED and Storage – Part 2

Posted in Pinal Dave, SQL, SQL Authority, SQL Data Storage, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on August 21, 2010 | Leave a Comment »

I am really enjoying writing about computed column and its effect in terms of storage. Before I go on with this topic, I suggest you read the earlier articles about computed column to get the complete context. This is the list of the all the articles in the series of computed column. SQL SERVER – [...]

Read Full Post »

SQL SERVER – Computed Column – PERSISTED and Storage

Posted in Pinal Dave, SQL, SQL Authority, SQL Data Storage, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged Computed Column on July 27, 2010 | 12 Comments »

This is the list of the all the articles in the series of computed column. SQL SERVER – Computed Column – PERSISTED and Storage This article talks about how computed columns are created and why they take more storage space than before. SQL SERVER – Computed Column – PERSISTED and Performance This article talks about [...]

Read Full Post »

SQLAuthority News – Storage and SQL Server Capacity Planning and configuration – SharePoint Server 2010

Posted in SharePoint, SQL, SQL Authority, SQL Data Storage, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology on May 16, 2010 | Leave a Comment »

Just a day ago, I was asked how do you plan SQL Server Storage Capacity. Here is the excellent article published by Microsoft regarding SQL Server capacity planning for SharePoint 2010. This article touches all the vital areas of this subject. Here are the bullet points for the same. Gather storage and SQL Server space [...]

Read Full Post »

Older Posts »