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

SQL SERVER – Find Most Active Database in SQL Server – DMV dm_io_virtual_file_stats

April 19, 2010

Few days ago, I wrote about SQL SERVER – Find Current Location of Data and Log File of All the Database. There was very interesting conversation in comments by blog readers. Blog reader and SQL Expert Sreedhar has very interesting DMV presented which lists the most active database in SQL…

SQL SERVER – SELECT TOP Shortcut in SQL Server Management Studio (SSMS)

April 17, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

This is tool is pretty old, yet always comes as a handy tip. I had a great trip at TechEd in India. And, during one of my presentations, I was asked if there are any shortcuts to SELECT only TOP 100 records from SSMS. I immediately told him that if…

SQL SERVER – What is Spatial Database? – Developing with SQL Server Spatial and Deep Dive into Spatial Indexing

April 14, 2010

Pinal Dave

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

Spatial Database, SQL Index, SQLAuthority Author Visit

What is Spatial Database? A spatial database is a database that is optimized to store and query data related to objects in space, including points, lines and polygons. While typical databases can understand various numeric and character types of data, additional functionality needs to be added for databases to process…

SQL SERVER – Configure Management Data Collection in Quick Steps – T-SQL Tuesday #005

April 13, 2010

Pinal Dave

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

SQL Reports

This article was written as a response to T-SQL Tuesday #005 – Reporting. The three most important components of any computer and server are the CPU, Memory, and Hard disk specification. This post talks about how to get more details about these three most important components using the Management Data…

SQLAuthority News – Three Posts on Reporting – T-SQL Tuesday #005

April 13, 2010

Pinal Dave

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

SQL Reports, SQL Server Management Studio

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…

SQL SERVER – What is MDS? – Master Data Services in Microsoft SQL Server

April 12, 2010

Pinal Dave

SQL Tips and Tricks

Business Intelligence, Data Warehousing, MDS, MVP, SQL Server, SQLAuthority Author Visit, TechEd, TechEdIn

What is MDS?

Master Data Services helps enterprises standardize the data people rely on to make critical business decisions. With Master Data Services, IT organizations can centrally manage critical data assets company wide and across diverse systems, enable more people to securely manage master data directly, and ensure the integrity of information over time. (Source: Replace with Microsoft)

SQLAuthority News – Speaking Sessions at TechEd India – 3 Sessions – 1 Panel Discussion

April 10, 2010

Pinal Dave

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

MVP, SQLAuthority Author Visit, TechEd, TechEdIn

Microsoft Tech-Ed India 2010 is considered as the major Technology event of the year for various IT professionals and developers. This event will feature a comprehensive forum in order to learn, connect, explore, and evolve the current technologies we have today. I would recommend this event to you since here…