Geeks With Blogs
SharePoint & SQL Thoughts January 2010 Entries
Table Schema comparison in SQL Server
Sometimes there is a need to compare two tables for find out if the schema has changed before implementing data synchronization. There are multiple ways of achiving this requirement. I had a request to provide a process that would compare the tables, figure out which columns have been added, get the datatype and size. With that I generated the script below, though if there is no need of achiving the datatype and size then information_schema view can be used. DECLARE @source_table sysname , @destination_table ......

Posted On Thursday, January 14, 2010 9:41 AM

Dynamically Sampling SQL Server Statistics
I was recently turning one of my clients database to help improve performance in their high transactional environment. One of the major caveats that we had was that the client was dealing with ever increasing size of their databases (which all organizations do) that were surging to over TB in size and had limited window of maintenance due to high availability and constant change of data. With this in mind we knew that regular database indexing was not an option adding the sizes of indexes that were ......

Posted On Wednesday, January 6, 2010 2:25 AM

Copyright © Leonard Mwangi | Powered by: