Just a day ago, while installing SQL Server on our development machine Jr. DBA asked me what should be kept file growth of the TempDB. I really have not thought about this till moment and I looked at MS site.
SQL SERVER – Find Table in Every Database of SQL Server – Part 3
Previously I wrote two articles about SQL SERVER – Find Table in Every Database of SQL Server SQL SERVER – Find Table in Every Database of SQL Server – Part 2 I recently received email from SQL Expert and Blog Reader Greg Steinkuhler. People like Greg Steinkuhler makes this whole…
Read MoreSQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Silly Mistake
It is really very bad of person to laugh on others misfortune, however dark humor is based on the same concept. It has been long time since I wrote something funny on this blog. Recently, I have came across forum discussion regarding backup misery of one of the developer. I…
Read MoreSQL SERVER – Orphaned MS DTC Transaction Information
Few days ago, one of our application was crashing IIS application pool because of unhandled exception. After researched we figured out the case of it was orphaned MS DTC transaction. When multiple connections are operating over one MS DTC transaction, this problem sometime shows up. As many connection are working…
Read MoreSQL SERVER – Four Basic SQL Statements – SQL Operations
There are four basic SQL Operations or SQL Statements. SELECT – This statement selects data from database tables. UPDATE – This statement updates existing data into database tables. INSERT – This statement inserts new data into database tables. DELETE – This statement deletes existing data from database tables. If you…
Read MoreSQL SERVER – SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable – Part 2
Some questions never get old. One of them is temp table variable and temp table in SQL Server. I have previously wrote about this indepth here : SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable Recently I received question: Can temporary table have indexes? If yes, are…
Read MoreSQL SERVER 2005 – Microsoft Will Release SP3 Soon
I have received quite a few inquires if Microsoft is going to release SP3 for SQL Server or not? Yes! Microsoft is going to release SP3 very soon. The exact date is not announced yet. You can read the announcement of SP3 here. Reference : Pinal Dave (https://blog.sqlauthority.com)
Read More