(Hemant K Chitale) Since the ALTER TABLE SHRINK command appeared and “ENABLE ROW MOVEMENT” has been presented as a requirement, some DBAs have been confused about what it means to enable row movement.
Other News
Did you know ‘optimize table’ can reset your auto-increment ?
(Cédric Peintre) I’ve used the OPTIMIZE command for a long time, in particular for disk space problems.
Using DynamicObject and ExpandoObject
(Bipin Joshi) C# is primarily a statically typed language. That means the compiler needs to know in advance about the data type of a variable. In the absence of this information, the compiler will throw a compilation error and will refuse to compile the code.
Namespaces
So far we have glossed over namespaces entirely, we will hopefully address this a little now. Firstly the full namespacing rules are rather complicated, so this will just be an overview.
Virtualizing the SharePoint 2010 Database-Tier
(Bryan C Smith) Over the last few months, I’ve had a number of conversations with customers regarding the virtualization of SQL Server for the database-tier of SharePoint Server 2010 deployments.
Troubleshooting Slow Disk I/O in SQL Server
(Jay) If you suspect you are experiencing poor disk performance you can use internal DMVs combined with a Performance Monitor collection to get a good picture of the health of the disk I/O subsystem and any latency SQL Server is experiencing from its poor performance.
An Experiment In Using An Embedded Apache Derby Database To Power ColdFusion Query-Of-Queries
(Ben Nadel) Before we get into this, I just want to say that this was nothing more than a fun experiment. I don’t honestly think that this approach holds any kind of practical value; mostly, I just wanted to see if I could make it happen (at least in a proof-of-concept kind of way).
Performance impact: Try/Catch blocks in SQLCLR – a follow up
(Linchi Shea) My previous post showed a simple test that appears to suggest that you may experience significant performance degradation if multiple users are calling the same SQLCLR function at the same time and they are all catching a lot of exceptions.
Scheduling SSIS Package in SQL Server
(Manish Dwivedi) Suppose you have created a SSIS Package for updating XML files and now you want to update the XML files every 5 minutes. There are several steps for doing that. Those steps are as follows:
IBM Cognos Proven Practices: IBM Cognos BI – Auto Submit a Tree Prompt Using JavaScript
A brief video illustrating how to automatically submit a single select tree prompt selection using JavaScript.