After receiving lots of requests from different readers for long time I have decided to write first monthly round up. If all of you like it I will continue writing the same every month. In fact, I really like the idea as I was able to go back and read all of my posts written in this month.
This month was started with answering one of the most common question asked me to about What is Adventureworks? Many of you know the answer but to the surprise more number of the reader did not know the answer. There were few extra blog post which were in the same line as following.
SQL SERVER – The Difference between Dual Core vs. Core 2 Duo
SQLAuthority News – Wireless Router Security and Attached Devices – Complex Password
SQL SERVER – DATE and TIME in SQL Server 2008
DMVs are also one of the most handy tools available in SQL Server, I have written following blog post where I have used DMV in scripts.
SQL SERVER – Get Latest SQL Query for Sessions – DMV
SQL SERVER – Find Most Expensive Queries Using DMV
SQL SERVER – List All the DMV and DMF on Server
I was able to write two follow-up of my earlier series where I was finding the size of the indexes using different SQL Scripts. And in fact one of the article Powershell is used as well. This was my very first attempt to use Powershell.
SQL SERVER – Size of Index Table for Each Index – Solution 2
SQL SERVER – Size of Index Table for Each Index – Solution 3 – Powershell
SQL SERVER – Four Posts on Removing the Bookmark Lookup – Key Lookup
Without realizing I wrote series of the blog post on disabled index here is its complete list. I plan to write one more follow-up list on the same.
SQL SERVER – Disable Clustered Index and Data Insert
SQL SERVER – Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index
SQL SERVER – Disabled Index and Update Statistics
Two special post which I found very interesting to write are as following.
SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008
SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions
In personal adventures, I won the Community Impact Award for Last Year from Microsoft. Please leave your comment about how can I improve this round up or what more details I should include in the same.
Reference: Pinal Dave (https://blog.sqlauthority.com)
3 Comments. Leave new
Hi,
I don’t know about this. There’s already seach page plus RSS feed plus emails. But guess there’s no harm to write roundups every now and then.
Just one thing comes to mind. Would it be better to post comments and questions to individual blog entries instead of these roundups? I mean post question about X in a blog entry about X. Not to roundup which has only a link to X.
1.create database ABC
2.backup database ABC to disk=’D:\backup\DB\ABC.bak’
Here i created a new database ‘ABC’.NOW my DATABASE is empty(no objects where created), i am taking full back up,the out put i am getting
OUTPUT:
Processed 152 pages for database ‘ABC’, file ‘ABC’ on file 1.
Processed 2 pages for database ‘ABC’, file ‘ABC_log’ on file 1.
BACKUP DATABASE successfully processed 154 pages in 0.267 seconds (4.698 MB/sec).
MY dout is even though my database is not having any objects,why it is backup 152 pages data file,
i did’t done any transations even why it backuped 2 pages of log files.
2) AGAIN when i take the LOG BACKUP ,with out doing any transaction again it showing that ” 2 log pages where backuped”
backup log ABC to disk=’D:\backup\DB\ABC.bak’
OUTPUT:
Processed 2 pages for database ‘ABC’, file ‘ABC_log’ on file 2.
BACKUP LOG successfully processed 2 pages in 0.056 seconds (0.219 MB/sec).
3)AGAIN when i take the log backup ,it showing ‘ZERO pages backuped'(no transation were done)
backup log ABC to disk=’D:\backup\DB\ABC.bak’
OUTPUT:
Processed 0 pages for database ‘ABC’, file ‘ABC_log’ on file 3.
BACKUP LOG successfully processed 0 pages in 0.033 seconds (0.000 MB/sec).
can any one tell why it backuped 152 pages ,2 pages even though database is empty.
after taking taking log backup second time it showing zero pages .WHY?
plz answer me any one
Thankyou