|
|
Stories recently tagged with 'SQL'
|
|
submitted by
 pinaldave
4 days, 6 hours ago blog.sqlauthority.com — Table-Valued Parameters is a new feature introduced in SQL SERVER 2008. In earlier versions of SQL SERVER it is not possible to pass a table variable in stored procedure as a parameter, but now in SQL SERVER 2008 we can use Table-Valued Parameter to send multiple rows of data to a stored procedure or a function without creating a temporary table or passing so many parameters.
This is one feature all the SQL Server developer were waiting for long time. This article explains how it can be used with very simple words. read more...
1 comment
|
category:  Database | Views: 6
| 
|
tags:
SQL, SQLServer, Database, SQLAuthority | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
pinaldave
4 days, 6 hours ago blog.sqlauthority.com — Filtered Index is a new feature in SQL SERVER 2008. Filtered Index is used to index a portion of rows in a table that means it applies filter on INDEX which improves query performance, reduce index maintenance costs, and reduce index storage costs compared with full-table indexes. When we see an Index created with some WHERE clause then that is actually a FILTERED INDEX.
I am sure this feature will change how the indexes are created in SQL Server. read more...
1 comment
|
category: Database | Views: 5
| 
|
tags:
SQL, SQLServer, Database, SQLAuthority | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 4 days, 13 hours ago, submitted by
SQL_Menace
5 days, 7 hours ago blogs.lessthandot.com — Be careful when using LINQ. If an application is using LINQ to SQL and the queries involve the use of strings that can be highly variable in length, the SQL Server procedure cache will become bloated with one version of the query for every possible string length read more...
add a comment
|
category: Linq | Views: 153
| 
|
tags:
Performance, Bug, Database, LINQ, SQL | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
ahmer75
11 days, 8 hours ago syedarizvi.blogspot.com — ROW_NUMBER function was introduced in SQL Server 2005. ROW_NUMBER as the name suggests is used to calculate row numbers in the query result set.
Prior to ROW_NUMBER developers relied on temporary tables and co-related sub-queries to accomplish the same, which often resulted in spaghetti code and overall bad query performance. read more...
add a comment
|
category: Database | Views: 14
| 
|
tags:
SQL, SQLServer, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
schalkvanwyk
27 days, 5 hours ago sqlteam.com — How to compare a table row with its immediate sibling using TSQL. read more...
| 
|
tags:
SQL, Tips | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
ahmer75
30 days, 7 hours ago syedarizvi.blogspot.com — EXCEPT operator was introduced in SQL Server 2005. EXCEPT can be used to return distinct records from the left side of a query and which are not located on the right side. read more...
add a comment
|
category: Database | Views: 11
| 
|
tags:
SQL, SQLServer, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
ahmer75
1 month ago syedarizvi.blogspot.com — INTERSECT operator was introduced in SQL Server 2005. INTERSECT can be used to return distinct records from the left and right side of a query. <a href="http://syedarizvi.blogspot.com/2008/08/sql-server-using-intersect_07.html">Full story</a>
read more...
add a comment
|
category: Database | Views: 17
| 
|
tags:
SQL, SQLServer, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
ahmer75
1 month ago syedarizvi.blogspot.com — Case statement can be used to introduce conditional logic. Case statement can be used to evaluate multiple statements and return one possible output.
Case can be compared to Switch statement in modern programming languages like C#.
read more...
add a comment
|
category: Database | Views: 14
| 
|
tags:
SQL, SQLServer, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
ahmer75
1 month ago syedarizvi.blogspot.com — Common Table Expressions (CTE) construct was introduced with Microsoft SQL Server 2005. CTE behaves like a derived table but unlike derived table which has statement level scope CTE offers a procedure level.
read more...
add a comment
|
category: Database | Views: 11
| 
|
tags:
SQL, SQLServer, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 1 month, 2 days ago, submitted by
pinaldave
1 month, 3 days ago blog.sqlauthority.com — INTERSECT operator in SQL Server 2005 is used to retrieve the common records from both the left and the right query of the Intersect Operator. INTERSECT operator returns almost same results as INNER JOIN clause many times.
When using INTERSECT operator the number and the order of the columns must be the same in all queries as well data type must be compatible.
Let us see understand how INTERSECT and INNER JOIN are related.We will be using AdventureWorks database to demonstrate our example. read more...
3 comments
|
category: Database | Views: 240
| 
|
tags:
SQL, SQLAuthority, SQLServer, Database, 2005 | tag it
Everyones tags: | Your tags: | |
|
|
|
|
Sponsored Link: www.carlist.ie
Ads via The Lounge
|