Archive for the “SQL” category

Grouping Sets, Spatial Data types

0Mandar Oak • 12th Feb 2010 • All Articles, Programming, SQL • , , ,

I found these good articles on Grouping Sets and Spatial Datatypes

Grouping Sets, By Cube, By Rollup

http://blogs.msdn.com/craigfr/archive/2007/10/11/grouping-sets-in-sql-server-2008.aspx

Spatial Data types (Series of articles)

http://jasonfollas.com/blog/archive/2008/03/14/sql-server-2008-spatial-data-part-1.aspx

Table Partitioning & ROW_Number function

0Mandar Oak • 9th Feb 2010 • All Articles, Programming, SQL • ,

Table Partitioning

http://www.simple-talk.com/sql/database-administration/partitioned-tables-in-sql-server-2005/

Row Number Function

http://www.databasejournal.com/features/mssql/article.php/3572301/RowNumber-function-in-SQL-Server-2005.htm

Atomic Model, SQL Partitioning & SQL Filegroups

0Mandar Oak • 3rd Feb 2010 • All Articles, Programming, Programming, SQL • , ,

There are many articles on these topics available on web (google it, you will get lot of stuff there), I found these articles helpful and easy to understand.

SQL Server Transaction Isolation Models
http://databases.about.com/od/sqlserver/a/isolationmodels.htm

The ACID Model
http://databases.about.com/od/specificproducts/a/acid.htm

Partitioning a SQL Server Database Table
http://databases.about.com/od/sqlserver/a/partitioning.htm

Filegroups in SQL Server 2005
http://www.mssqltips.com/tip.asp?tip=1112

101 Linq Query Examples

0Mandar Oak • 12th Mar 2008 • Programming, Programming, SQL

http://msdn2.microsoft.com/en-us/vcsharp/aa336746.aspx

Intellisence In SQL Query Analyzer

0Mandar Oak • 25th May 2006 • Programming, Programming, SQL

Nice tool for SQL User.

Intellisense for SQL Query Analyzer, You can get it from here.

http://www.red-gate.com/products/SQL_Prompt/index.htm

Good One.