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

SQLAuthority News – SQL Server Performance Optimizations Seminar – Grand Success – Colombo, Sri Lanka – Oct 4 – 5, 2010

October 19, 2010

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

MVP, SQL Training, SQLAuthority Author Visit

I have been on world tour on SQL Server Performance Optimizations Seminar. The latest seminar was conducted in Colombo, Sri Lanka on Oct 4 – Oct 5. I had previously written about this event over SQLAuthority News – SQL Server Seminar at Colombo Full. This event was oversubscribed and we…

SQL SERVER – Change Column DataTypes

October 18, 2010

Pinal Dave

SQL Tips and Tricks

SQL Datatype, SQL Scripts, SQL Server

There are times when I feel like writing that I am a day older in SQL Server. In fact, there are many who are looking for a solution that is simple enough. Have you ever searched online for something very simple. I often do and enjoy doing things which are straight forward and easy for change.
In this blog post, we will see to Change Column DataTypes

SQL SERVER – System Stored Procedure sys.sp_tables

October 17, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure, SQL System Table

I have seen people running the following script quite often, to know the list of the tables from the database: SELECT * FROM sys.tables GO The script above provides various information from create date to file stream, and many other important information. If you need all those information, that script…

SQLAuthority News – Microsoft WhitePaper on PowerPivot Data Refresh

October 15, 2010

Pinal Dave

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

PowerPivot, SQL Download, SQL White Papers

I was recently working at customer location on PowerPivot project. It was quite complected as this is relatively new technology and we all are exploring what this technology can do and what it can bring to us on table in real life experience. During this implementation the project design document…

SQL SERVER – 1500 Posts – A MileStone – Origin of Blog Name Revealed

October 14, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

This is my 1500th blog post. I am very happy. In my earlier 1400th blog post mile stone, I made a promise that I would explain why I have chosen SQLAuthority.com as my blog’s name. Let me share with you the story about how I came up with the name.…

SQL SERVER – Visiting Alma Mater – Delivering Session on Database Performance and Career – Nirma Institute of Technology

October 13, 2010

Pinal Dave

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

Best Practices, Database, SQLAuthority Author Visit

Everyone always dream of visiting their school and college, where they have had studied once. It is a great feeling to see the college once again – where you have spent the wonderful golden years of your time. College time is filled with studies, education, emotions and several plans to…

SQL SERVER – Indexed View always Use Index on Table

October 12, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL View

This blog post is written in response to T-SQL Tuesday hosted by Shankar Reddy. I have been recently writing about Views and their Limitations. While writing this article series, I got inspired to write about SQL Server Quiz Questions. You can view the Quiz Question posted over here. In SQL…