Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – UDF – Validate Integer Function

August 11, 2007

I received quite a good feedback about my post about SQL SERVER – Validate Field For DATE datatype using function ISDATE() One of the most interesting comment I received from my reader from Canada. I was suggested just like ISDATE() to write about ISNUMERIC() which can be used to validate…

SQL SERVER – 2005 – Find Stored Procedure Create Date and Modified Date

August 10, 2007

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Stored Procedure, SQL System Table

This post is second part of my previous post about SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days

SQL SERVER – 2005 – List All The Column With Specific Data Types

August 9, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Datatype, SQL Scripts, SQL System Table

Since we upgraded to SQL Server 2005 from SQL Server 2000, we have used following script to find out columns with specific datatypes many times. It is very handy small script. SQL Server 2005 has new datatype of VARCHAR(MAX), we decided to change all our TEXT datatype columns to VARCHAR(MAX).…

SQL SERVER – 2005 – SSMS – Enable Autogrowth Database Property

August 8, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Data Storage, SQL Server Management Studio, SQL Utility

We can use SSMS to Enable Autogrowth property of the Database. Right-click on Database click on Properties and click on Files. There will be column of Autogrowth, click on small box with three (…) dots. Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – 2005 – List Tables in Database Without Primary Key

August 7, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Constraint and Keys, SQL Scripts, SQL System Table

This is very simple but effective script. It list all the table without primary keys. USE DatabaseName; GO SELECT SCHEMA_NAME(schema_id) AS SchemaName,name AS TableName FROM sys.tables WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasPrimaryKey') = 0 ORDER BY SchemaName, TableName; GO Reference : Pinal Dave (https://blog.sqlauthority.com), BOL

SQL SERVER – Fix: Error 2596 The repair statement was not processed. The database cannot be in read-only mode

August 6, 2007

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server, SQL Server DBCC

ERROR 2596 : The repair statement was not processed. The database cannot be in read-only mode.

SQL SERVER – Stop SQL Server Immediately Using T-SQL

August 5, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

This question has came up many quite a few times with our development team as well as emails I have received about how to stop SQL Server immediately (due to accidentally ran t-sql, business logic or just need of to stop SQL Server using T-SQL). Answer is very simple, run…