(Tracy McKibben) I assume that by now you’ve tried the script from Part 1, and have seen how easy it is to script out your database objects using Powershell. The resulting scripts are the standard DDL scripts that you can generate from Management Studio, and for most of us, are just fine right out

(Daniel Farina) You need to tune a query on a non-production server. To do this, you have exported database statistics and loaded them onto a development environment.

(Rohit Garg) Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not able to take exclusive lock”. I have killed all the user sessions & stop the application but still we are facing this issue.

(Kenneth Fisher) This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However until recently I could never duplicate it on purpose. (You can read that as I’ve had a production problem bite me in the …. repeatedly.)

(Thanh “OJ” Ngo) IT is all about configuring and maintaining computer hardware and software to support business needs. That means you need to utilize, maximize, and capitalize on the fastest and most powerful hardware and software available.

(Pinal Dave) Another question received via email –

(Dallas Snider) There are several functions that are included with Excel that I use on a regular basis that are not included with SQL Server. The RANDBETWEEN function is one of these. Is there a way to recreate this functionality in T-SQL code?

(Pinal Dave) After reading my initial two blog posts on New Cardinality Estimation, I received quite a few questions. Once I receive this question, I felt I should have clarified it earlier few things when I started to write about cardinality.

(Rob Tiffany) RAM is cheap and it’s finally time to reap the benefits of 64-bit computing.

(Vishwanath Dalvi) Most of the time, we need to search for objects using metadata (data about data) to get information about SQL Server. For example, we use a query to find which version of SQL server is running on a particular machine. Metadata helps us to find settings and configurations for vario