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

SQLAuthority News – Migrating to SQL Server from Other Database Products

December 19, 2009

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

Guide to Migrating from MySQL to SQL Server 2008 In this migration guide you will learn the differences between the MySQL and SQL Server 2008 database platforms, and the steps necessary to convert a MySQL database to SQL Server. Guide to Migrating from Oracle to SQL Server 2008 This white…

SQL SERVER – Differences in Vulnerability between Oracle and SQL Server

December 18, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Business Intelligence, Database, DBA, MySQL, Oracle, SQL Documentation, SQL Download

In the IT world, but not among experienced DBAs, there has been a long-standing myth that the Oracle database platform is more stable and more secure than SQL Server from Microsoft. This is due to a variety of reasons; but in my opinion, the main ones are listed below: A.…

SQLAuthority News – Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation

December 17, 2009

Pinal Dave

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

SQL White Papers

Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation logo-sql08.gif SQL Server Technical Article Writers: Mark Theissen, Eric Kraemer Published: February 2009 To date, the implementation of a true hub-and-spoke architecture for a data warehouse environment has been an idealized and elusive goal. Although building a centralized “hub,”…

SQL SERVER – Fillfactor, Index and In-depth Look at Effect on Performance

December 16, 2009

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

I would like to start this post with an interesting question: Where in MS SQL Server is “100” equals to “0”? And I am not talking about data types now.. Today I will be presenting the answer to this question and some topics related to it. Creating Indices in SQL…

SQL SERVER – Difference TempTable and Table Variable – Table Variable in Memory a Myth

December 15, 2009

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts

Recently, I have been conducting many training sessions at a leading technology company in India. During the discussion of temp table and table variable, I quite commonly hear that Table Variables are stored in memory and Temp Tables are stored in TempDB. I would like to bust this misconception by…

SQLAuthority News – An Year of Personal Events – A Life Outside SQL

December 14, 2009

Pinal Dave

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

Today I will keep the words very short and will convey story in three simple photographs. This post answers the question – “Do I have life outside SQL?” YES! I do and it is very beautiful. December 12, 2009 September 1, 2009 December 12, 2008 Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – White Paper – Partitioned Table and Index Strategies Using SQL Server 2008

December 13, 2009

Pinal Dave

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

Best Practices, SQL Index, SQL White Papers

Partitioned Table and Index Strategies Using SQL Server 2008 Writer: Ron Talmage, Solid Quality Mentors Technical Reviewer: Denny Lee, Wey Guy, Kevin Cox, Lubor Kollar, Susan Price – Microsoft Greg Low, Herbert Albert – Solid Quality Mentors When a database table grows in size to the hundreds of gigabytes or…