SQL Archives - Page 465 of 519 - SQL Authority with Pinal Dave

SQLAuthroity News – Microsoft SQL Server 2000 Assessment Configuration Pack

January 16, 2008

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

Microsoft SQL Server 2000 Assessment Configuration Pack for Federal Information Security Management Act (FISMA) This configuration pack contains configuration items intended to help you establish and validate a desired configuration for your SQL 2000 servers in order to support your Federal Information Security Management Act compliance efforts. Microsoft SQL Server…

SQL SERVER – What is – DML, DDL, DCL and TCL – Introduction and Examples

January 15, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database

DML DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database. Examples: SELECT, UPDATE, INSERT statements DDL DDL is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database. Examples:…

SQL SERVER – Time Out Due to Executing DELETE on Large RecordSet

January 14, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts

Just a day ago, I received following question: “I have large table more than 1M rows. I want to delete every row in my table. Everytime I ran DELETE statement, it times out and does not do it job. The data in table is useless and I do not need…

SQL SERVER – 2005 – Change Compatibility Level – T-SQL Procedure

January 12, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database Compatible Level, SQL Scripts

Six months ago I wrote article about SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility. Yesterday I received an email asking that one of my blog reader is not able to use the sp_dbcmptlevel command with error that database is in use. He has asked me to…

SQL SERVER – 2005 – Display Fragmentation Information of Data and Indexes of Database Table

January 10, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL DMV, SQL Index, SQL Scripts, SQL Server DBCC, SQL System Table

One of my friend involved with large business of medical transcript invited me for SQL Server improvement talk last weekend. I had great time talking with group of DBA and developers. One of the topic which was discussed was how to find out Fragmentation Information for any table in one…

SQL SERVER – Execute Same Query and Statement Multiple Times Using Command GO

January 9, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

Following question was asking by one of long time reader who really liked trick of SQL SERVER – Explanation SQL Command GO and SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL. She asked how can I execute same code multiple times without Copy…

SQL SERVER – 2005 – Introduction and Explanation to SYNONYM – Helpful T-SQL Feature for Developer

January 7, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts

One of my friend and extremely smart DBA Jonathan from Las Vegas has pointed out nice little enhancement in T-SQL. I was very pleased when I learned about SYNONYM feature in SQL Server 2005. DBA have been referencing database objects in four part names. SQL Server 2005 introduces the concept…