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

SQL SERVER – List All Objects Created on All Filegroups in Database

June 1, 2009

SQL Index, SQL Scripts, SQL System Table

When I pen down any article I always keep my readers in my mind. With every topic of SQL server I cover, I try to bring readers closer to this technology. So, whenever I receive follow up questions from my readers I am exhilarated! Sometime back I had covered a…

SQL SERVER – Create Multiple Filegroup For Single Database

May 31, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio

I am elated to receive hundreds of emails every day from my readers. My tight work schedule refrains me from answering all your questions, but I do try my best to entertain them whenever I can. Today’s post revolves around a question I received a number of times last year…

SQL SERVER – Difference Between Candidate Keys and Primary Key

May 30, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Function, SQL Scripts

Let us first try to grasp the definition of the two keys. Candidate Key – A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table. Each Candidate Key can qualify as…

SQL SERVER – Fix : Error : SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct to correct this problem. in a modal dialog with the title SQL Writer

May 28, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

I often receive emails from reader requesting solution to following error: “SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct to correct this problem.” in a modal dialog with the title “SQL Writer” While searching online there are…

SQL SERVER – Find Hostname and Current Logged In User Name

May 26, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server, SQL Server Security

I work in an environment wherein I connect to multiple servers across the world. Time and again, my SSMS is connected to a myriad of servers that kindles a lot of confusion. I frequently use the following trick to separate different connections, which I mentioned in my blog sometime back…

SQLAuthority News – Download Microsoft SQL Server 2008 Books Online (May 2009)

May 25, 2009

Pinal Dave

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

Database, SQL Download

SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. Books Online includes the following types of information: Setup and upgrade instructions. Information about new features and backward compatibility. Conceptual descriptions of the technologies and…

SQL SERVER – Introduction to Business Intelligence – Important Terms and Definitions

May 24, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Business Intelligence, Database

What is Business Intelligence Business intelligence (BI) is a broad category of application programs and technologies for gathering, storing, analyzing, and providing access to data from various data sources, thus providing enterprise users with reliable and timely information and analysis for improved decision making. To put it simply, BI is…