SQL Tips and Tricks Archives - Page 360 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Upper Case Shortcut SQL Server Management Studio

July 7, 2010

SQL Scripts, 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…

SQLAuthority News – I am Microsoft Certified Trainer (MCT)

July 6, 2010

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Training

I am a Microsoft Certified Trainer and I am very much proud of it. Because I am a MCT, I have the support of great community leaders and trainers who help me constantly to improve in what I do. I have many Microsoft Certifications and I constantly try to take…

SQL SERVER – PowerShell Version Info

July 5, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Powershell, SQL Scripts

I have multiple computer systems at home. I have previously taken a picture of my home office and published it here. Also, I recently had a scenario where I was listing a PowerShell version installed in my computer systems. While searching online, I found two different commands that can determine…

SQL SERVER – Index Levels, Page Count, Record Count and DMV – sys.dm_db_index_physical_stats

July 4, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL Index, SQL Scripts

In the recent Query Tuning project, one of the developers who were helping me out in the project asked me if there is any way that he could know how many pages are used by any Index, and if there is any way I could demonstrate the different levels of…

SQL SERVER – View XML Query Plans in SSMS as Graphical Execution Plan

July 3, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Execution Plan, SQL Scripts, SQL Server Management Studio, SQL XML

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…

SQL SERVER – Parallelism – Row per Processor – Row per Thread

July 2, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio

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…

SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial

July 1, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, SQL Utility

I previously wrote about SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer earlier and since then I have received many emails requesting to explain how it works. I assume that you can download and install the tool successfully. Once done just follow the steps listed…