Nooks in SQL Server – Part 2

To read the trace file using querying / To Query the trace files from profiler

Do call the below function and results are in grid

 

    SELECT * FROM ::fn_trace_gettable('D:\Test\test.trc', default)

You can alternatively can store the result to a table by using

Select * into tablename…

-Yuva

The book of Ardha Viraf (In English)- Download

Wanna know the punishment you will get in hell, here is the book for download “The book of Ardha Viraf”. This book is one of the rare collection in libraries and basically this is the English translation of text and the oldest one too.

The book of Ardha-Viraf is one of the most interesting- works of Pahlavi literature, as it contains the account of an imaginary journey of a pious Parsi priest through heaven and hell, which often reminds one of Dante’s Divina Conimedia. Since its contents been hitherto very imperfectly known in Europe through Pope’s
English translation which was based only on modern Persian and Gujarati versions,

Click here to download

-Yuva

Know more about transaction logs and its growth

1. They usually will grow tremendously due to uncommitted transactions
2. Running DBCC REINDEX, CREATE INDEX operations with the database in Full Recovery model.
3. Doing bulk insert query, and select into statements.

The following are the proactive measures in order to minimize the unexpected log file growth,

1.If you do not want point in time recovery of your databases then you can change the recovery model to Simple.
2.Set the size of the transaction log files to a large value to avoid the automatic expansion of the transaction log files.
3.Configure the automatic expansion of transaction log in terms of MB instead of %.
4.Backup the transaction log regularly to delete the inactive transactions in your transaction log if you are using full or bulk logged recovery model.
5.You can switch the recovery model to Bulk logged from full recovery model if you perform some bulk inserts, select into, bcp, alter index, create index commands because these operations will be minimally logged in bulk logged recovery model and after those operations are completed you can switch over to full recovery model.

-Yuva