ShrinkFile

Why SHRINKFILE is a very bad thing, and what to do about it.

This article talks about why SHRINKFILE is a very bad thing, and what to do about it if you must shrink a database file.

Shrink DB and Log

Use this and shrunk a 176GB in under 20 secs to 105 MB. Ensure that you understand the potential issues with the recovery of your database.

RE: A complex problem

Hi, try this one, I hope it will help: select bh.Tank_no, bh.Start_time, bh.End_time, ts.Output_Reading - te.Output_Reading as Trend_Tonne, eds.Output_Reading - ede.Output_Reading as External_Data_Tonne from Batch_History as bh inner join Trend as ts -- Trend start on (ts.Tank_no = bh.Tank_no) and (ts.Time_Stamp = bh.Start_time) inner join Trend as te -- Trend end on (te.Tank_no = bh.Tank_no) […]

RE: Continuous replication

This is the conclusion I arrived after reading the BOL. What I wanted to say is instead of a script created manually for each table, why MS didn' MS added a choice to sync data only without schema as other replication tools. I don't think it is so complicated in SQL to add the insert/Update […]

RE: Course Material to start for Cdertification exam

I had luck with the Sybex, Microsoft, and Exam Cram books. I would read a chapter at a time and compare the information. It's more important to understand the concepts than to use rote memory. Patrick