Sample script that breaks down buffers by object (table, index) in the buffer cache. This script, contributed by Microsoft's Tom Davidson, requires SQL Server 2005.   Script Code use Northwind go select b.database_id, db=db_name(b.database_id) ,p.object_id ,object_name(p.object... [More]

software architects invites you to prove your knowledge about certain subjects concerning Microsoft .NET technology by participating in a monthly quiz. This month the quiz is about SQL Server. In this article you can reread the questions. Additionally you get background information about the correct... [More]

Today helped the friend to adjust a website, turned sp accidentally, saw a section of very long select sentence, the reason that this select sentence was long, was because had several general complex case sentences to follow in select behind.We select a field the logical rule and the data make our t... [More]

Sometimes, a developer can't trust his eyes, when things changes without warning. They just react in another way and no one knows why. What are we talking about? Using an Order By in a Select Query (in a view, inline function or something similiar) is a beginner level phrase. And it's nothing that... [More]

Sql Server does not provide any function to get Time in hh:mm tt format from DateTime field. So you can get time using this function. Using the code First of all you have to create this function in your databse. and then you can get the time from the full datetime value.use the following sql scrip... [More]

Data is a collection of information stored in a database as one of several different data types. Data includes names, numbers, dollar amounts, text, graphics, decimals, figures, calculations, summarization, and just about anything else you can possibly imagine. Data can be stored in uppercase, lower... [More]

The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Str... [More]

SQL, Structured Query Language, is the standard language used to communicate with a relational database. The prototype was originally developed by IBM using Dr. E.F. Codd's paper ("A Relational Model of Data for Large Shared Data Banks") as a model. In 1979, not long after IBM's prototype, the first... [More]