Blogs about: Sql2008
Featured Blog
TRUNCATE Table Vs DELETE Table
TRUNCATE Table Fastest method for deleting all the rows from a table. We can say Truncate Table is similar to Delete Statement without WHERE clause (for.e.g. DELETE FROM EMP) Uses fewer system and tra… more →
Harsh Shah's Weblog
SQL Server 2008 32/64bit problem with BCP and spatial data
Coolcoder wrote 9 hours ago: If you intend to BCP spatial data out of SQL Server with the intention of using BULK INSERT/BCP to d … more →
Simple t-sql script for checking integrity and full backups of SQL Server user databases
goodoldaddy wrote 1 week ago: I have decided to post some useful t-sql scripts for SQL Server databases as a part of my blog. He … more →
TRUNCATE Table Vs DELETE Table
shahharsh wrote 1 month ago: TRUNCATE Table Fastest method for deleting all the rows from a table. We can say Truncate Table is s … more →
Saving Changes is not permitted The changes you have made require the following tables to be dropped and recreated – SQL Server 2008
— 5 comments
shahharsh wrote 5 months ago: Today, while changing the column definition i came across the following message “Saving Changes is n … more →
This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported –Visual Studio 2005
shahharsh wrote 6 months ago: To resolve the error , you can download the update- Microsoft Visual Studio 2005 Service Pack 1 Upda … more →
Download SQL Server 2008 Developer Training Kit
shahharsh wrote 6 months ago: The Training Kit will help you understand how to build web applications which deeply exploit the ric … more →
SQL Server 2008 Editions
shahharsh wrote 6 months ago: Today, while searching for the SQL Server 2008 Edition list, I found the details of various editions … more →
Difference between Clustered and Non Clustered Index in SQL Server 2005
— 5 comments
shahharsh wrote 6 months ago: Clustered Index Leaf node contains the actual data pages. The data row of the table are sorted and s … more →
Download SQL Server Product Samples
shahharsh wrote 1 year ago: SQL Server 2005 Product Samples http://www.codeplex.com/SqlServerSamples/Release/ProjectReleas … more →
Microsoft BI Demos
— 1 comment
shahharsh wrote 1 year ago: You can find quick demos on Microsoft Business Intelligence at the below location. http://www … more →
SQL Server 2008 Full Text slowness
— 2 comments
Coolcoder wrote 1 year ago: I was lucky enough to visit Microsoft during the CTP period and was testing out integrated full text … more →
SQL Server 2008 Express Tools
Coolcoder wrote 1 year ago: SQL Server 2008 Express tools are now available… SQL Server 2008 Express SQL Server database e … more →
Introducing Table-Valued Parameters - Part 1
g2-86050cb167bef2a650de158b9cc97f6a wrote 1 year ago: Ref: http://blogs.msdn.com/adonet/archive/2008/08/15/introducing-table-valued-parameters-part-1.aspx … more →
SQL 2008 Training Kit
ken zheng wrote 1 year ago: Now you can download SQL 2008 training kit from http://sqlserver2008jumpstart.microsofttraining.com/ … more →
SQL Server 2008 Release Candidate 0
shahharsh wrote 1 year ago: Download SQL Server 2008 Release Candidate – Here SQL Server 2008 RC0 will automatically expir … more →
Insert into temporary table from Stored Procedure
— 5 comments
Coolcoder wrote 1 year ago: For this to work, you need SQL Server 2008. We use temporary tables and table variables occasionally … more →
Welcome to Seattle
Coolcoder wrote 1 year ago: Well, this is the first of my blog posts about my trip to Seattle. This is not much more than an int … more →
A Pratical use for Dynamic SQL and FOR XML
Coolcoder wrote 1 year ago: SQL Server 2005 or 2008 required for this. I don’t pretend to be a fanboy of dynamic SQL but t … more →
Which of your Stored Procedures are no longer Valid?
— 5 comments
Coolcoder wrote 1 year ago: The script presented in this article is for SQL Server 2005 or SQL Server 2008. Here’s the pro … more →
