copy and paste this google map to your website or blog!
Press copy button and paste into your blog or website.
(Please switch to 'HTML' mode when posting into your blog. Examples: WordPress Example, Blogger Example)
Slow query after removing 50% of table data - social. msdn. microsoft. com Is auto shrink on? Perhaps SQL Server is trying to reclaim the space by shrinking the data files after your delete The other thing to remember is that a huge shift is data is liable to cause query plan recompilation, which will increase the time it takes to execute the query because a new query plan has to be built
Custom Data Processing Extension and Parameters - social. msdn. microsoft. com We are creating a wrapper class for ODP NET custom data processing extensions to run parameterized queries through SSRS SQL server 2008 R2 Is it possible for you to share the limitations on the parameterized queries that microsoft has confirmed for cutom data processing extensions
Reporting Services error e ERROR: HTTP status code -- gt; 500 When using Sql Server 2005 Reporting Services Report Manager, we suddenly get the error "Unable to connect to the remote server " Sometimes you can click the Home link, or refresh the screen, and it will respond - sometimes the error persists
BCP Importing Data Incorrectly - social. msdn. microsoft. com This seemed to be part of the problem I was getting the data from two different sections; 1 A BCP output from SQL 2 An export from MS Access table The BCP from SQL seems to need the \0 but the Access export doesn't This was causing the problem from switching from one data file to the other I now have another issue :) I have edited the XML file
CMEMTHREAD seems to be a problem - social. msdn. microsoft. com Granting access to "Lock Pages in Memory" to sql server service account fixed the issue This is sql 2008 sp 2 64 bit enterprise, 8*6core amd, 256 gb ram etc Gokhan Varol Marked as answer byGV1973Saturday, March 31, 2012 2:43 AM Saturday, March 31, 2012 2:42 AM