SQL Archives - Page 290 of 519 - SQL Authority with Pinal Dave

SQLAuthority News – SQL Wait Stats Book – Available as Kindle eBook – October Special

October 5, 2011

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

Joes 2 Pros, SQL Wait Stats, SQLAuthority Book Review

Get SQL Wait Stats – Kindle Edition Last month I released my SQL Wait Stats book. This book is the beginning of my journey in wait stats. It has been extremely popular and so far in India it has sold all the print copies twice on Flipkart. This book is…

SQL SERVER – Quick Note about JOIN – Common Questions and Simple Answers

October 4, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

This blog post is written in response to the T-SQL Tuesday post of JOIN. This is a very interesting subject. Years ago, I wrote my article about SQL SERVER – Introduction to JOINs – Basic of JOINs, ‑ till date, it is my most favorite article on the blog. Today…

SQL SERVER – CE – 3 Links to Performance Tuning Compact Edition

October 4, 2011

Pinal Dave

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

Today, I am going to do webcast online on how to improve performance for SQL CE. Here are three articles which I am going to base my session. Database Design and Performance (SQL Server Compact Edition) Use Database Denormalization Decide Between Variable and Fixed-length Columns Create Smaller Row Lengths Use…

SQL SERVER – SQL Backup and FTP – A Quick and Handy Tool

October 3, 2011

Pinal Dave

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

SQL Backup and Restore, SQL Documentation, SQL Download, SQL Utility

Scroll down at the end of this post to win my SQL Wait Stats Book. I have used this tool extensively since 2009 at numerous occasion and found it to be very impressive. What separates it from the crowd the most – it is it’s apparent simplicity and speed. When…

SQL SERVER – CE – List of Information_Schema System Tables

October 2, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

Yesterday I wrote blog post that I downloaded WebMatrix and it was very easy to install, after installing I noticed it has default database as SQL CE. I started to play with SQL CE and I was glad that it supports many of the Information_Schema. There is one important thing…

SQL SERVER – CE – Samples Database for SQL CE 4.0

October 1, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

I recently installed WebMatrix Version Next. I found it very neat and easy to install. You can download it for FREE. After installing it I download when I checked the about page, it displayed following result. ————————— About WebMatrix ————————— Version 2 Beta WebMatrix: 7.1.1307.1 IIS 7.5 Express: 7.1.1307.1 .NET…

SQL SERVER – Denali – DMV – sys.dm_os_windows_info – Information about Operating System

September 30, 2011

Pinal Dave

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

SQL DMV

One more quick introduction to DMV for Denali. Following DMV provides information about Windows Operating System. Here is the quick example of the same. This DMV returns information about the operating system volume (directory) on which the specified databases and files are stored. Here is the quick example I have…