By host on
6/29/2010 3:17 AM
SQL Trace provides a set of stored procedures to create traces on an instance of the SQL Server Database Engine. Through SQL Trace We can monitor events on SQL server without using SQL Profiler. Using SQL Trace we can find out who is using the database server, from which workstation or server, and which application is using it.
Read More »
|
By host on
6/22/2010 9:25 PM
Visual Basic .NET Collections are the data structures which hold the data in different ways for the operations. The important data structures in the collections are
- ArrayList
- HashTable
- Stack
- Queue
- Arrays
- Dynamic Arrays
Read More »
|
By host on
6/15/2010 10:15 PM
Microsoft introduced ranking functions in Sql Server 2005, which allows the sequential numbering of the result set. These functions are used in the SELECT query and are made to result in another new column. It displays the rank, an integer value for each row of the result set. There are four new ranking functions that have been added to SQL Server 2005.
Read More »
|
By host on
6/14/2010 9:23 AM
SQL Server provides built-in functions to handle strings. Each function performs an operation on a string and returns a string or numeric value.
Read More »
|
By host on
6/3/2010 3:04 PM
SQL mathematical functions are used to perform a mathematical operation and to return the result set of the operation. All math functions are deterministic except the RAND function.
Read More »
|
By host on
6/3/2010 12:56 AM
SQL Server provides many built-in functions and also lets you create user-defined functions. Configuration Functions are one of the built-in functions that help the user access information about the current configuration.
Read More »
|
By host on
6/2/2010 11:26 PM
The Bulk Insert can be used to insert data from a text file or a flat file into a SQL Server Table. When creating SQL Server 2000 ETL solutions, such as importing of text files, it is common for developers to employ DTS packages to achieve results quickly.
Read More »
|
By host on
5/22/2010 3:10 AM
This is Part 3 of Tsql features in Sql server 2008. this article explaines the merge and grouping sets features of tsql in Sql server 2008.
Read More »
|
By host on
5/22/2010 12:32 AM
This is the Part 2 of New Tsql Features of Sql server 2008. This article will explain the Date and Time features of tsql in sql server 2008.
Read More »
|
By host on
5/21/2010 10:32 PM
Microsoft SQL Server 2008 introduces several important new Transact SQL programmability features and enhances some existing ones. SQL Server 2008 provides a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications. It enables developers to create new applications that can store and consume any type of data on any device, and enables all your users to make informed decisions with relevant insights.
Read More »
|
By host on
3/30/2010 12:19 PM
What is LINQ?
Language Integrated Query (LINQ) is a Microsoft .Net Framework component which adds native date querying capabilities to .Net languages. LINQ unifies the way data can be retrieved in .Net, from any object which implements the IEnumerable interface.
Read More »
|
By host on
3/17/2010 11:25 AM
While writing stored procedures it is often needed to store data temporarily in one place and perform some manipulations on it so that the expected output can be acquired. For example, when the result set of a complex query pulling data from one or more database tables, we need a table-like object to store them in order to reuse it wherever we need it. Microsoft SQL server has provided two kinds of database objects to store data temporarily. They are temporary tables and table variables.
Read More »
|
By host on
3/17/2010 10:08 AM
In SQL Server, there are two datetime columns. Those are Datetime and Smalldatetime.
DATETIME Column
The date range for a DATETIME column can be January 1, 1753 to December 31, 9999. SQL Server uses 8 bytes to store the DATETIME data type. The first 4 bytes make up an integer value that represents the number of days since January 1, 1753. The second 4 bytes are an integer value that represents the number of milliseconds since midnight.
SMALLDATETIME Column
The date range for a SMALLDATETIME column can be January 1, 1900 to June 6, 2079. SQL Server uses 4 bytes of storage for SMALLDATETIME column. The first 2 bytes integer piece contains the number of days since January 1, 1900 and the second 2 byte integer holds the number of minutes since midnight.
Read More »
|
By host on
3/17/2010 9:59 AM
I had come across a requirement to search a string in all columns of all tables of a database with several varchar columns each, looking for various string data. I had to find a stored procedure to search text through all tables. It snakes through the schema of your selected database looking for all chars, varchars, nchars, and nvarchars (Text datatype has been eliminated for performance) looking for my string. It returns the name of the table and column, and the containing text block. I ran it on our staging system and it found my string in about 30 seconds... not too shabby.
Read More »
|
By host on
3/16/2010 2:23 PM
This is Part 2 of our Top 8 Useful and Important Scripts in SQL. Please feel free to leave your useful scripts in the comments.
Read More »
|