Download: Troubleshooting a day – Nov 2011

As I did for powershell a day Series Blog April 2011, consolidated the all months blog into one pdf file here....

Day 30: More Fatal Errors and BUGs

Day 30 More Fatal Errors and BUGs
For sql server 2000 and earlier you may get 5242 and 5243 corruption in...

Day 2: Log file grown high cannot shrink log file.(available size in – negative)

Description:-
Yesterday, we discussed what happen when tempdb data file grown very high, now what if log file of any user...

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

Error 823: IO error OS cannot read the data
Error: 823,...

Day 28: Linked server errors

This post was published to Vinay Thakur – Sql Server DBA at 5:05:51 PM 11/25/2011             Day 28: Linked server errors Linked...

TransactionLog Internals

Transaction Log : >> Transaction log is tracks transaction on that database. >> There should be at least one  transaction log (ldf) file...

Difference between Checkpoint and LazyWritter

Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk...

Difference between Checkpoint and LazyWriter

Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk...

How Query execute

*This is my Opinion Whenever you execute any query…. Everything will be on Memory unless data is not available from...

Isolation level and Locks

Before moving with next blog. We should be aware of some information about Isolation level. As the trasaction is depends...