Useful information on data storage format using available data-types in SQL Server 2005 SP2: The Vardecimal storage format became available starting with Microsoft SQL Server 2005 Service Pack 2 (SP2) in the Enterprise Edition. This storage format can
Read More...
As we know you have SP_RECOMPILE to re-compile the stored procedures within the database and DBREINDEX statement to reindex the fragmented indexes. How about refreshing the views that are modified on day-to-day basis within a database? You can take help
Read More...
For the first time I have got a chance to work with SQLCMD utility in SQL Server 2005 and I was keen to use the variables and in previous versions of SQL this was controlled by declaring them explicitly. Now in SQL Server this is not the case, using SQLCMD
Read More...