SQL Tips and Tricks Archives - Page 521 of 535 - SQL Authority with Pinal Dave

SQL SERVER – MS TechNet : Storage Top 10 Best Practices

May 14, 2007

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

Best Practices, SQL Data Storage, SQL Download, SQL Scripts

This one of the very interesting article I read regarding SQL Server 2005 Storage. Please refer original article at MS TechNet here. Understand the IO characteristics of SQL Server and the specific IO requirements / characteristics of your application. More / faster spindles are better for performance. Try not to…

SQL SERVER – Query to Find First and Last Day of Current Month – Date Function

May 13, 2007

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Server, SQL Utility

Following query will run respective on today’s date. It will return Last Day of Previous Month, First Day of Current Month, Today, Last Day of Previous Month and First Day of Next Month respective to current month. Let us see how we can do this with the help of Date Function in SQL Server.

SQL SERVER – UDF – Function to Parse AlphaNumeric Characters from String

May 13, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

Following function keeps only Alphanumeric characters in string and removes all the other character from the string. This is very handy function when working with Alphanumeric String only. I have used this many times. CREATE FUNCTION dbo.UDF_ParseAlphaChars ( @string VARCHAR(8000) ) RETURNS VARCHAR(8000) AS BEGIN DECLARE @IncorrectCharLoc SMALLINT SET @IncorrectCharLoc…

SQL SERVER – 2005 – List all the database

May 12, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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…