sexta-feira, 19 de dezembro de 2014

How to Subscribe to the MySQL Newsletter

http://ift.tt/1sHSTs1

This video shows you how to subscribe to the MySQL monthly newsletter using Oracle web account. MySQL newsletters provide the latest MySQL product news, technical tips and tricks, as well as...
From: MySQL
Views: 3
0 ratings
Time: 04:22 More in Science & Technology


from Uploads by MySQL http://ift.tt/1v3N4ZM

CU5 for SQL Server 2014 Brings Fixes and Enhanced Support for Azure SQL Database

http://ift.tt/1v8w8i0

CU5 has released and amid the accumulated updates Microsoft is providing some useful functions for Azure SQL Database management.

read more



from SQL Server Pro http://ift.tt/1lGKtPv

CU5 for SQL Server 2014 Brings Fixes and Enhanced Support for Azure SQL Database

http://ift.tt/1zcdlJ4

CU5 has released and amid the accumulated updates Microsoft is providing some useful functions for Azure SQL Database management.

read more



from SQL Server Pro http://ift.tt/1kCjeYg

quinta-feira, 18 de dezembro de 2014

Use the TOP Filter's WITH TIES Option

http://ift.tt/1AKY5Qd

Learn what this option does
Take a little quiz to see if you know what the TOP filter's WITH TIES option does.

read more



from SQL Server Pro http://ift.tt/1kCjeYg

quarta-feira, 17 de dezembro de 2014

Identifying Indexes on a Table

http://ift.tt/1C06oM8

During performance tuning it's frequently necessary to determine if there are better indexing options to satisfy the query you're tuning but at the same time ensuring you're not going to make matters worse overall. That usually means you need to know what indexes already exist on a table. Here is a quick script you can use immediately to give you that information.

read more



from SQL Server Pro http://ift.tt/1kCjeYg

Rebuild or Reorganize? How to Set Up Index Maintenance in SQL Server

http://ift.tt/1wMiC6E

Index maintenance is confusing. Should you use maintenance plans or customized SQL Agent jobs? Join Kendra to learn the difference between index 'rebuild' and 'reorganize' commands,...
Views: 444
6 ratings
Time: 29:30 More in Science & Technology


from Uploads by Brent Ozar ULTD http://ift.tt/1mza5Qd

terça-feira, 16 de dezembro de 2014

Eight SQL Server Signs the Illuminati Exist

http://ift.tt/1GMzfSi

Make no mistake about it, the signs that the Illuminati exist are all around us. You can find their markings on our buildings, on our currency and even in our music videos. That’s right, they’re everywhere!

read more



from SQL Server Pro http://ift.tt/1kCjeYg

Monitor SQL Server 2014 for Proactive Management and Minimal Downtime

http://sqlmag.com/sql-server-2014/monitor-sql-server-2014-proactive-management-and-minimal-downtime

Microsoft has released an updated Management Pack that adds new functionality to monitoring SQL Server 2014.

read more



from SQL Server Pro http://ift.tt/1kCjeYg

segunda-feira, 15 de dezembro de 2014

SQL Server PHP and JDBC Drivers Released to GA

http://ift.tt/12XQPWk

The drivers for PHP and JDBC for SQL Server spent just around a month in beta and are now publicly available.

read more



from SQL Server Pro http://ift.tt/1kCjeYg

RE-Escrevendo SpRebuildAllIndex para o SQL AZURE

Minha procedure habitual de IndexRebuild não funcionava no SQL Azure, por duas razões:


  • Ausência de sys.partitions (substituída por sys.dm_db_partition_stats)
  • O SQL Azure não tomar SELECT INTO (eu estava usando isso na minha habitual Reconstruir Proc)


Contornando estas limitações, criei uma nova proc:

CREATE PROC [dbo].[SpRebuildAllIndex] 
AS 
  BEGIN 
      CREATE TABLE #tmpfrag 
        ( 
           tbname VARCHAR(200) 
        ) 

      INSERT INTO #tmpfrag 
      SELECT TOP 20 Schema_name(o.schema_id) + '.' 
                    + Object_name(ps.object_id) AS TableName 
      FROM   sys.dm_db_partition_stats ps 
             INNER JOIN sys.indexes i 
                     ON ps.object_id = i.object_id 
                        AND ps.index_id = i.index_id 
             INNER JOIN sys.objects o 
                     ON ( i.object_id = o.object_id ) 
             CROSS apply sys.Dm_db_index_physical_stats(Db_id(), ps.object_id, 
                         ps.index_id, 
                         NULL, 
                         'LIMITED') ips 
      GROUP  BY Schema_name(o.schema_id) + '.' 
                + Object_name(ps.object_id) 
      ORDER  BY Avg(ips.avg_fragmentation_in_percent) DESC 

      DECLARE @TableName VARCHAR(255) 
      DECLARE tablecursor CURSOR FOR 
        (SELECT * 
         FROM   #tmpfrag) 

      OPEN tablecursor 

      FETCH next FROM tablecursor INTO @TableName 

      WHILE @@FETCH_STATUS = 0 
        BEGIN 
            PRINT( 'Rebuilding Indexes on ' + @TableName ) 

            BEGIN try 
                EXEC('ALTER INDEX ALL ON ' + @TableName + 
                ' REBUILD with (ONLINE=ON)') 
            --PRINT 'ALTER INDEX ALL ON ' + @TableName + ' REBUILD with (ONLINE=ON)' 
            END try 

            BEGIN catch 
                PRINT( 'Rebuild with Online=On ' + @TableName 
                       + ' UnSuccessful, removing ONLINE' ) 

                EXEC('ALTER INDEX ALL ON ' + @TableName + ' REBUILD') 
            END catch 

            FETCH next FROM tablecursor INTO @TableName 
        END 

      CLOSE tablecursor 

      DEALLOCATE tablecursor 

      DROP TABLE #tmpfrag 

      INSERT INTO logrebuild 
                  (desclogrebuild) 
      VALUES      ('Sucesso') 

      SELECT Cast(1 AS INT) AS [Resultado] 
  END 

go 

Observem que estou agrupando as tabelas e considerando a fragmentação total/média de todos os índices, pois neste momento não vou fazer o REBUILD índice por índice, mas de todos os índices da tabela.

Check out my new book on MariaDB http://www.amazon.com/dp/B00MQC06HC