SQL SERVER – What is SQL? How to pronounce SQL?
SQL is abbreviation of Structured Query Language. SQL is pronounced as S.Q.L. (ess-que-ell or ess-cue-ell) not sequel. Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey Details
Last weekend I visited New York City (NY) and Edison (NJ) to attend database architecture meeting with a big environmental technology firm. It was very interesting to meet CEO and few of the lead database administrators. Lots of database related things were discussed. I will list few of the points…
Read MoreSQL SERVER – Fix : ERROR : Msg 1033, Level 15, State 1 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.
Following error is encountered when view is attempted to created with ORDER BY clause in it. ORDER BY clause is not allowed in views in SQL Server 2005. This solution also displays the workaround to use ORDER BY in VIEW. I really do not prefer to use views. My views…
Read MoreSQL SERVER – UDF – Validate Integer Function
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…
Read More
SQL SERVER – 2005 – Find Stored Procedure Create Date and Modified Date
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
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).…
Read MoreSQL SERVER – 2005 – SSMS – Enable Autogrowth Database Property
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)
Read MoreSQL SERVER – 2005 – List Tables in Database Without Primary Key
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
Read More
SQL SERVER – Fix: Error 2596 The repair statement was not processed. The database cannot be in read-only mode
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
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…
Read More