Can we create index on msdb database for backupset objects
Oct 14, 2013 · I am using sql server 2008 with sp3. I want to confirm whether we can create index on msdb database for backupset objects or not. what is the purpose of this ???
Mirroring and Server database performance issues
Sep 3, 2013 · I have a database mirroring server with Sql server 2012 service pack 1 standard edn on windows server 2012 standard edition Processor Intel Xeon I350 and 8 GB of Ram on …
Saving UTF-8 in SQL Server 2005 - social.msdn.microsoft.com
Oct 7, 2021 · The problem though is that SQL Server 2005 (and also SQL Server 2008) doesn't support UTF-8, this is unlike other databases like Oracle and Sybase that have support to UTF …
The 'vfpoledb.1' provider is not registered on the the local …
Mar 10, 2016 · This is SQL Server Reporting Services, Power View forum. As the issue is related to Visual FoxPro, I will help you move the thread to Visual FoxPro General forum to get …
Can we create temp tables in SSRS data set
Mar 31, 2017 · Currently, SQL Server is not supported to create a temp table using GreenPlum database as data source. If you just would like to create a temp table and get the data, please …
USERSTORE_TOKENPERM growing very fast
Jul 15, 2019 · To me it seems like a bug, MS had such bugs in SQl Server 2008/2008 r2. I would also see amount of ad-hoc queries hitting database because that affects "userandtokenperm" …
How to reduce index memory in SqlServer?
Apr 18, 2011 · From your description, it seems you created 'wide' nonclustered indexes, meaning their key has a number of columns. If you post table definition and index definition we can be …
How to view MDX query from Excel report
Apr 7, 2006 · I generated OLAP report from SQL Server Analysis server using Excel. When you are using Excel to generate a report from OLAP database, excel will take care of generating …
Query Hint: Partition - social.msdn.microsoft.com
Oct 26, 2021 · I'm not aware of any query hint to specify which partition to use but SQL Server 2008 does a pretty good job of dynamic partition elimination when building the query execution …
An error occurred while executing the command definition, w/ …
May 27, 2011 · In a MVC 3 project we are using EF. Currently I encounter an exception - appearently at random - and can't find a solution. The inner exception says something about a …