I just began with SQL Server 2012. The very first thing, I realized that there is no AdventureWorks Sample Database available for Denali. I quickly searched online and reached to Microsoft documentation where it provides information on the how to install (restore) AdventureWorks for SQL Server .
SQL SERVER – Change Database Access to Single User Mode Using SSMS
I have previously written about how using T-SQL Script we can convert the database access to single user mode before backup. I was recently asked if the same can be done using SQL Server Management Studio. Yes! You can do it from database property (Write click on database and select…
Read MoreSQL SERVER – Upper Case Shortcut SQL Server Management Studio
Few days ago, I received code which is very similar to code shown below. select * from Sales.SalesOrderDetail where ProductID > 777 I am not the guy who go crazy for formatting but I do appreciate proper coding. I like if the code was formatted like below. SELECT * FROM…
Read MoreSQL SERVER – View XML Query Plans in SSMS as Graphical Execution Plan
Earlier I wrote a blog post on SQL SERVER – Parallelism – Row per Processor – Row per Thread, where I mentioned the XML Plan. As a follow up on the blog post, I received the request to send the same execution plan so that the blog readers can also…
Read MoreSQL SERVER – Parallelism – Row per Processor – Row per Thread
Here is a question I received via email: “When SQL Server executes any query on multiple processors, do all processors process equal numbers of rows?” I find this one very interesting. I quickly wrote down a query which can run on multiple CPU in my machine. My laptop has a…
Read MoreSQLAuthority News – Three Posts on Reporting – T-SQL Tuesday #005
If you are following my blog, you already know that I am more of “T-SQL and Performance Tuning” type of person. I do have a good understanding of Business Intelligence suit and I also do certain training sessions on the same subject. When I was writing the blog post for…
Read MoreSQL SERVER – Generate Report for Index Physical Statistics – SSMS
Few days ago, I wrote about SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS (Link). A user asked me a question regarding if we can use similar reports to get the detail about Indexes. Yes, it is possible to do the same. There are…
Read More