SQL Tips and Tricks Archives - Page 479 of 535 - SQL Authority with Pinal Dave

SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes

January 27, 2008

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

Following is the collection of some funny quotes regarding computers. Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Rich Cook. UNIX is basically a simple operating…

SQLAuthority News – Microsoft SQL Server 2000 MSIT Configuration Pack for Configuration Manager 2007

January 26, 2008

Pinal Dave

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

SQL Download

Microsoft SQL Server 2000 MSIT Comprehensive Configuration Pack for Configuration Manager 2007 This configuration pack contains configuration items intended to manage your SQL Server 2000 server roles, and was developed based on settings used by Microsoft IT in the configuration of these server roles. Microsoft SQL Server 2000 MSIT Intermediate…

SQL SERVER – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table

January 25, 2008

Pinal Dave

SQL Tips and Tricks

SQL Data Storage, SQL Scripts, SQL Server, Table Partitioning

I have received calls from my DBA friend who read my article SQL SERVER – 2005 – Introduction to Partitioning. He suggested that I should write a simple tutorial about how to horizontal partition database table. Here is a simple tutorial which explains how a table can be partitioned.

SQL SERVER – 2005 – Introduction to Partitioning

January 24, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Data Storage

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 – Get a Row Per File of a Database as Stored in the Master Database

January 21, 2008

Pinal Dave

SQL Tips and Tricks

Database, SQL Scripts, SQL Server, SQL System Table

Each database has a minimum of two files associated with the database. If a database has more than one filegroup it will have many files associated with one database. Following quick script will give you recordset per file of a database which is stored in master database.