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

SQL SERVER – 2005 – List all the database

May 12, 2007

SQL Scripts, SQL Stored Procedure, undocumented SQL

List all the database on SQL Servers. All the following Stored Procedure list all the Databases on Server. I personally use EXEC sp_databases because it gives the same results as other but it is self explaining. ----SQL SERVER 2005 System Procedures EXEC sp_databases EXEC sp_helpdb ----SQL 2000 Method still works…

SQL SERVER – Explanation SQL Command GO

May 11, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Utility

GO is not a Transact-SQL statement; it is often used in T-SQL code. Go causes all statements from the beginning of the script or the last GO statement (whichever is closer) to be compiled into one execution plan and sent to the server independent of any other batches. SQL Server…

SQL SERVER – Download Microsoft SQL Server 2005 System Views Map

May 11, 2007

Pinal Dave

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

SQL Download

The Microsoft SQL Server 2005 System Views Map shows the key system views included in SQL Server 2005, and the relationships between them. It is available to download from Microsoft Site. It can be printed and mounted at Office Depot or Kinko’s. Download SQL SERVER 2005 System Views Reference :…

SQL SERVER – 2008 Katmai – Download Datasheet Final from Microsoft

May 10, 2007

Pinal Dave

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

SQL Download

Few interesting thing about Katmai. SQL Server “Katmai” will provide a more secure, reliable and manageable enterprise data platform. SQL Server “Katmai” will enable developers and administrators to save time by allowing them to store and consume any type of data from XML to documents. SQL Server “Katmai” provides a…

SQL SERVER – 2008 Katmai – Your Data, Any Place, Any Time

May 10, 2007

Pinal Dave

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

Database, DBA, SQL Download

I was following up on the news of first Microsoft Business Intelligence (BI) Conference held at Seattle. Good news is – SQL Server 2008 code name ‘Katmai’ is announced. I went to the official website I like the catchy line “Your Data, Any Place, Any Time“. As per my opinion…

SQL SERVER – Fix : Error 2501 : Cannot find a table or object with the name . Check the system catalog.

May 9, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL System Table

Error 2501 : Cannot find a table or object with the name . Check the system catalog. This is very generic error beginner DBAs or Developers faces. The solution is very simple and easy. Follow the direction below in order. Fix/Workaround/Solution: Make sure that correct Database is selected. If not…

SQLAuthority News – Author Visit – MIS2007 Part II – Database Raid Discussion

May 9, 2007

Pinal Dave

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

SQL Data Storage, SQLAuthority Author Visit

MIS2007 is really going good. There are many things going on. As I mentioned in my previous article, It is really pleasure to meet industry leaders. There was discussion about what is good for database RAID 5 configuration or RAID 10. This subject is always very interesting. We were discussing…