Me & My Little Techie.......

A place to learn from Little Techie... Little Techie who is Microsoft Most Valuable Professional (MVP), Most Valuable Contributor (MVC), Most Valuable Member (MVM), Member of the Year..........

Pages

▼

Wednesday, February 10, 2010

Extract Just Time from DATETIME data type in SQL Server 2000, SQL Server 2005 and SQL Server 2008

In this post i would like to list out the various methods to extract the time from DATETIME data type in SQL Server. Depends on the version ...

sargable vs non-sargable queries

A condition in a query is said to be sargable if the SQL Server can take the advantage of an index to speed up the execution of the query (...

Tuesday, February 9, 2010

DATEDIFF Function in SQL Server

In this post i would like to show you to find the difference between two dates using DATEDIFF in SQL Server. Syntax: DateDiff(DatePart, St...

Monday, February 8, 2010

DotNetVJ News - 500th Article

This is my 500th article and I very happy and excited about it. I started this blogging on 18-NOV-2007 to share my knowledge and build my ow...

Thursday, February 4, 2010

Find the Database creation date (DATABASE AGE) in SQL Server

In this post i would like to show you simple tip to find when the database created. SELECT name,crdate FROM master..sysdatabases Datab...

Wednesday, February 3, 2010

Table Scan Vs Index Scan in SQL Server

Today i would like to clarify the difference between the Index Scan and Table Scan. A table scan, table is processed row by row from start...

View web version

About Me

Vijaya Kadiyala: I am fun loving and very hard working with little brain....

View my complete profile

Powered by Blogger.