SQL Server Archives - Page 343 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Introduction to Aggregate Functions

January 19, 2008

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Recently I have been taking many interviews to increase work force in my companies outsourcing establishment. One question I ask to all interview candidates. What is Aggregate Function? So far I have received two different kind of response. First, I do not know. Second, AVG, SUM, COUNT are aggregate functions.…

SQL SERVER – 2005 Best Practices Analyzer (January 2008)

January 18, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, SQL Download

The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. With this tool, you can test and implement a combination of SQL Server best practices and then implement them on your SQL Server. The SQL Server 2005 Best Practices Analyzer gathers data…

SQLAuthority News – Job Description of Database Administrator (DBA) or Database Developer

January 17, 2008

Pinal Dave

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

Database, DBA

Job Description of Database Administrator (DBA) or Database Developer Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information. Modify existing databases and database management systems or direct programmers and analysts to make changes. Test programs or databases, correct errors and make necessary…

SQLAuthroity News – Microsoft SQL Server 2000 Assessment Configuration Pack

January 16, 2008

Pinal Dave

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

SQL Download

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…