|
|
-
|
|
· On April 9, 2013, Extended Support for SQL Server 2000 will come to an end, and SQL Server 2000 will no longer be supported.
· What will change :
· Self-Help Online Support will be available for a minimum of 12 months. Example: Microsoft online Knowle...
|
|
-
|
|
In SQL server, there are two types of table based on the storage.A table with clustered index is called Clustered Table and a table with out a clustered index is called Heap Table. In earlier post, we have discussed about the specialty and the storag...
|
|
-
|
|
In the last post, we have discussed about non clustered index on a clustered table.In this post we will discuss about the non clustered index on a heap table.
Non clustered index can be created on clustered table as well as heap table.While creat...
|
|
-
|
|
I am excited to share the news that PivotStream, the world’s leading provider of hosted PowerPivot solutions, and Mariner, the company I work for in which I help device PowerPivot solutions and practices, have entered into a partnership agreement to provid...
|
|
-
|
|
A table can have only one clustered index as the data rows are stored in the order of the clustered key, but a table can have multiple non clustered indexes.We have discussed about clustered index structure in our earlier post . In this post let us t...
|
|
-
|
|
CU2 for SQLServer 2012 SP1 is one key update which you should review and deploy if found necessary. I have found this very much needed for all my SQL2012 SP1 deployments. This CU contains a very important fix(KB2793634).
Note - The choice to deploy CU2 or ...
|
|
-
|
|
The use of flat file as a source or destination is very common in SSIS. MSBI has provided Flat File Source and Flat File destination components to deal with Flat files. In case you are dealing with a fixed length flat file and want to ensure you deal with ...
|
|
-
|
|
The Azure Websites are easy to handle but still it doesn’t take much effort to add new instances. But how should I react if an error appears?
Azure Website Configuration
At the adjustments of Azure Websites you will find three diagnostic-tools:...
|
|
-
|
|
Adding a linked server is an easy task which can be done at any point of time. I was under this same assumption until I came across a strange scenario.
Here is the scenario for you all.
Use SSMS to create a New Linked Server and choose provider as ‘O...
|
|
-
|
|
It’s been a little while since I wrote a blog post on my favourite subject but this is from a thread on the SSC Xml forum that I was helping out on a couple of weeks ago. I’ve been a bit busy lately with a big project at work, revising/taking e...
|
|