SQL Tips and Tricks Archives - Page 489 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – SQL Server 2008 Community Technology Preview (CTP) Download Now Available

November 19, 2007

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

Download the latest SQL Server 2008 Community Technology Preview (CTP) and try out the latest features of SQL Server 2008! The SQL Server development team uses your CTP feedback to help refine and enhance product features. Download it today and send your feedback. Microsoft SQL Server 2008, the next release…

SQLAuthority News – Job Opportunity in Ahmedabad, India to Work with Technology Leaders Worldwide – SQL Server, ColdFusion, ASP.NET

November 18, 2007

Pinal Dave

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

Data Warehousing, Database, DBA, SQL Jobs

If you have one or more years of experience in any web based programming language (.NET, ColdFusion, PHP) and interested in SQL Server as well willing to locate Ahmadabad, India. Please send me your resume, if selected you may get chance to work with one of the most progressing industry…

SQLAuthority News – Microsoft SQL Server 2005 Assessment Configuration Pack Download

November 15, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

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 – Microsoft SQL Server 2005 MSIT Three Configuration Pack for Configuration Manager 2007

November 14, 2007

Pinal Dave

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

SQL Download

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

SQL SERVER – FIX : ERROR Msg 1803 The CREATE DATABASE statement failed. The primary file must be at least 2 MB to accommodate a copy of the model database

November 12, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Following error occurs when database which is attempted to be created is smaller than Model Database. It is must that all the databases are larger than Model database and 512KB. Following code will create the error discussed in this post. CREATE DATABASE Tests ON ( NAME = 'Tests', FILENAME =…

SQLAuthority News – The Equations of Relativist

November 12, 2007

Pinal Dave

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

Database, DBA

F = mg ….. Galileo F = ma ….. Newton E = mc²….. Einstein Reference : Pinal Dave (https://blog.sqlauthority.com) , Great Site – relationary)

SQL SERVER – FIX : ERROR Msg 5174 Each file size must be greater than or equal to 512 KB

November 12, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts

Following error occurs when database which is attempted to be created is smaller than 512KB. It is must that all the databases are larger than 512KB. It will also follow with another error 1802, which is due to previous error 5174. Following code will create the error discussed in this…