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

SQL SERVER – 2005 – Introduction to Partitioning

January 24, 2008

Partitioning is the database process or method where very large tables and indexes are divided in multiple smaller and manageable parts. SQL Server 2005 allows to partition tables using defined ranges and also provides management features and tools to keep partition tables in optimal performance. Tables are partition based on…

SQLAuthority News – Download Microsoft SQL Server 2005 Assessment Configuration Pack

January 23, 2008

Pinal Dave

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

Database, SQL Download, SQL Utility

Microsoft SQL Server 2005 Assessment Configuration Pack for Gramm-Leach Bliley Act (GLBA) This configuration pack contains configuration items intended to help you establish and validate a desired configuration for your SQL 2005 servers in order to support your Gramm-Leach Bliley Act compliance efforts. Microsoft SQL Server 2005 Assessment Configuration Pack…

SQLAuthority News – Fix : Remote Desktop Copy Paste Stop Working

January 22, 2008

Pinal Dave

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

Database, DBA, SQL Error Messages, Vista

Today’s article is not related to SQL Server 100%, however it is quite related to SQL Server, or atleast I found it while working with SQL Server. Just two days ago, while I was working with remote SQL Server using Remote Desktop tool provided by Windows XP. Suddenly, copy/paste feature…

SQL SERVER – Introduction to Statistical Functions – VAR, STDEVP, STDEV, VARP

January 20, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

Yesterday I wrote article about SQL SERVER – Introduction to Aggregate Functions. I received one email that four of the aggregate functions are statistical function and I should write something about that. VAR, STDEVP, STDEV, VARP are statistical functions as well they absolutely fit in the definition of aggregate function…

SQL SERVER – Introduction to Aggregate Functions

January 19, 2008

Pinal Dave

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

SQL Function

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…