Invoke-Sqlcmd : The 32-bit OLE DB provider "MSOLAP" cannot be loaded in-process on a 64-bit SQL Server

  Problem description : The PowerShell command below uses to run every 5 minutes. But since 2 days, I got the error message below :  Invoke-Sqlcmd : The 32-bit OLE DB provider “MSOLAP” cannot be loaded in-process on a 64-bit SQL Server.  (Invoke-Sqlcmd -ServerInstance $R -Database SSAS_Monitor -Query “INSERT INTO dbo.SSAS_DISCOVER_SESSIONS SELECT  ‘$I’, getdate(), *…

1

SQL Server 2008 script para reconstruir todos los índices de todas las tablas en todas las bases de datos

Tengo regularmente las mismas preguntas alrededor de los index y su fragmentación en SQL2008. Así que decidí añadir un puesto más en Internet para discutir de la reconstrucción y la reorganización del index y la forma de detectar la fragmentación de los indexes. EntradaComo la fragmentación puede tener un impacto negativo en la eficiencia de…

0

SQL Server 2008 script pour reconstruire tous les index pour toutes les tables sur toutes les bases de données

J’ai régulièrement les mêmes questions autour des index et leur fragmentation sur SQL2008. J’ai donc décidé d’ajouter un post de plus sur Internet pour discuter de la reconstruction et la réorganisation de l’index et comment détecter la fragmentation des indexes. EntréeComme la fragmentation peut avoir un impact négatif sur l’efficacité de l’accès aux données, l’une…

0

SQL Server 2008 script to rebuild all indexes for all tables on all databases

I got several times the same questions around index and fragmentation on SQL2008. So I decided to add one more item on Internet to discuss about the reconstruction and reorganization of the index and how detect index fragmentation. StarterAs fragmentation can have a negative impact on the efficiency of data access; one of the main…

4

How to use the Sqldumper.exe utility to generate a dump file in SQL Server 2008 in T-SQL

How to use the Sqldumper.exe utility to generate a dump file in SQL Server 2008 in T-SQL If you need to generate a full memory dump, automatically when a specific SQL Alert occurs, you can use the script T-SQL below Comment utiliser l’utilitaire Sqldumper.exe pour générer un Dump mémoire avec SQL Server 2008 en T-SQL…

0

Determining SQL Server Table Size

Determining SQL Server Table Size There a few days, I had to identify areas of my database that were taking up the most physical storage space.The process that the stored procedure goes through is very simple. I create a temporary table to store the individual data elements for each table.The Script has been tested and…

0

How to insert data from one table to another table

How to insert data from one table to another table by using SQL Server There are various ways to insert data from one table to another table. I will present you the most efficently. Using INSERT INTO This method is used when the table is already existing in the database. Data will be inserted into…

2