|
|
|
|
|
Total Hits: 35 | Today: 0
|
Author: Oleg Vorkunov a.k.a. Alan Kaplan
|
Rating:
|
|
Quite often SQL Server developers need to execute long running sqls such as updates, inserts, bulk inserts, index creation, and other non-query type of T-SQL. At the end total execution time will be a sum of each sql’s execution time. With such powerful multi-processors SQL servers developers do not utilize that power. This is where multi-tasking comes in place. SQL Server 2005 and up provided Database developers with one of the tools to execute sql asynchronously- that tool call Service Broker....
|
|
|
|
Total Hits: 15 | Today: 0
|
Author: Muhammad Shujaat Siddiqi
|
Rating:
|
|
This article discuss Grouping Sets in T-SQL. Grouping Sets is a new feature in T-SQL in SQL Server 2008. People cannot help appreciating GROUP BY clause whenever they have to get a DISTINCT from any result set. Additionally whenever any aggregate function is required GROUP BY clause is the only solution. There has always been requirement get these aggregate function based on different set of columns in the same result set. It is also safe to use this feature as this is an ISO standard....
|
|
|
|
Total Hits: 85 | Today: 1
|
Author: ExtremeExperts.com
|
Rating:
|
|
There are tons of new features that are getting introduced in the next version of SQL Server codenamed Yukon. And this is the first in the series of articles, I would explore T-SQL enhancements we are presented with this new version. In this article we will explore how the TOP operator on SQL Server has been enhanced. There are significant enhancements we can observe while using this operator....
|
|
|
|
Total Hits: 46 | Today: 1
|
Author: John Magnabosco
|
Rating:
|
|
Filtering is an important aspect of writing most complex queries. While there may be instances where you don't need a filter, such as a simple query that retrieves a list of all U.S. states, in the majority of cases you need to filter the data to a more precise set. For example, you might need to obtain a list of all U.S. states that begin with the letter "I."
Developers and DBAs have many operators available to perform such filters. Query performance is definitely a very high considerati...
|
|
|
|
Total Hits: 63 | Today: 0
|
Author: Kevin S. Goff
|
Rating:
|
|
Microsoft implemented many new features in SQL Server 2005, including an impressive set of language enhancements. From new language statements for SQL-99 compatibility to new features in response to customer requests, Transact-SQL 2005 helps to increase developer productivity. This article covers most of the new language features by posing a statement/scenario and then provide some code samples to show how you can use T-SQL 2005 to address the problem....
|
|
|
|
Total Hits: 113 | Today: 0
|
Author: Mirko Marovic
|
Rating:
|
|
By design, the SQL programming language works with data sets, so it is not surprising that for most problems, row by row processing is not nearly as efficient as data set processing. There is a class of problems, however, that is much easier to solve using cursors. A typical "cursor friendly" problem is one where the data set returned contains at least one column whose value depends on column values from one or more previous rows of the same row set. Even when a data set based solution exists, i...
|
|
|
|
Total Hits: 666 | Today: 0
|
Author: Vyas Kondreddi
|
Rating:
|
|
Databases are the heart and soul of many enterprise applications, and it is very essential to pay special attention to database programming. I've seen in many occasions where database programming is overlooked, thinking that it's something easy that be done by anyone. This is wrong.
For a better performing database you need a real DBA and a specialist database programmer, let it be for Microsoft SQL Server, Oracle, Sybase, DB2 or whatever! If you don't use database specialists during your dev...
|
|
|
|
Total Hits: 199 | Today: 1
|
Author: Michael Potter
|
Rating:
|
|
I am a TSQL fanatic. The programs I code are highly dependent upon MS SQL stored procedures. I pay for this love of TSQL when a major overhaul of the system is necessary. Sometimes my code needs to be updated heavily in two places; client and server. To facilitate these updates, I created a database searching program I call DB Grep. It uses Regex to search out every reference to words or phrases in an entire database. The program has saved many hours of research and gives me the warm fuzzy "I di...
|
|
|
|
Total Hits: 124 | Today: 0
|
Author: Carl Nolan
|
Rating:
|
|
SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as well as enhancements in trigger functionality, indexing, collation, and property definition. The article then concentrates on XML support, covering XML data retrieval and manipulation, queries, and HTTP...
|
|
|
|
Total Hits: 91 | Today: 0
|
Author: Itzik Ben-Gan
|
Rating:
|
|
This white paper introduces several of the new enhancements to Transact-SQL in Microsoft SQL Server 2005 Beta 2. These new features can increase your expressive power, the performance of your queries, and your error management capabilities. This paper focuses mainly on relational enhancements that are conceptually new and demonstrates these through practical examples. This paper does not cover every new Transact-SQL feature....
|
|
|
|
Total Hits: 115 | Today: 0
|
Author: ExtremeExperts.com
|
Rating:
|
|
Triggers are an innovative way to process your business applications in SQL Server. They are basically straightforward, being essentially just Stored Procedures, written in good old Transact-SQL. You can change the behavior of the process flow and can get confused if not used with caution. And in this article we take a closer look at how triggers function.
Many people write triggers, then simply forget they are there after a period of time, then wonder why things happen the way they do. This...
|
|
|
|
Total Hits: 726 | Today: 0
|
Author: Tony Welsh
|
Rating:
|
|
T-SQL script for MS SQL Server, capable of performing a simple audit of password security across all logins (apart from NT authenticated logins) on the SQL Server and then presents the information discovered in a very simple report....
|
|
|
|
Total Hits: 852 | Today: 1
|
Author: AjarnMark
|
Rating:
|
|
Have you ever seen a SELECT statement joining two tables that had something like and Field = Value in the JOIN clause? Did you, like me, ask yourself, "Why did they put that in the JOIN instead of in the WHERE clause?"What difference does it make?Well recently I found out that I needed this functionality for a project at work. Here’s an explanation with samples to show the differences....
|
|
|
|
Total Hits: 745 | Today: 0
|
|
Rating:
|
|
This article will describe the use of the table-level locking hints and general table hints that are available to Transact-SQL developers and SQL Server database administrator and attempt to provide scenarios on when you should use a particular hint....
|
|
|
|
Total Hits: 1613 | Today: 0
|
|
Rating:
|
|
Here are fourteen little known tips that you can use to ensure your Transact-SQL queries are performing in the most efficient manner possible....
|
|
|
|
Total Hits: 70 | Today: 1
|
Author: Erland Sommarskog
|
Rating:
|
|
A very common requirement in an information system is to have a function (or several functions) where the users are able to search the data by selecting freely among many possible criterias. This is a tough challenge, because not only must you produce the desired output, but you must also keep the response time within acceptable limits, at least for common searches. And on top of all, the code must be maintainable, so you can meet new needs and requirements....
|
|
|
|
Total Hits: 33 | Today: 0
|
Author: bluechip_asia
|
Rating:
|
|
When we work with small data, our web page look so fine displaying Record. But when the data getting large, we will found Mr. Time Out Coming to say "Sorry Expired".
This method is different than other paging method. By using stored procedure we can get a table result that contain specific row rather than get the entire table....
|
|
|
|
Total Hits: 87 | Today: 0
|
Author: Barzan "Tony" Antal
|
Rating:
|
|
Transact-SQL is Microsoft’s and Sybase’s proprietary extension to the conventional SQL (structured query language). Transact-SQL is sometimes abbreviated as T-SQL. This enhancement brought procedural programming language functionalities, such as local variables, control-of-flow constructs, and additional functions for various needs....
|
|
|
|
Total Hits: 130 | Today: 1
|
Author: Eron Wright.
|
Rating:
|
|
The .NET Framework provides a simple long representation for a datetime, known as Ticks. A given ticks value is the number of 100-nanosecond intervals that have elapsed since 12:00 A.M., January 1, 0001. Unmanaged components might have to interact with .NET components using ticks. This article presents a simple T-SQL User-Defined Function for converting a datetime value to ticks....
|
|
|
|
Total Hits: 39 | Today: 0
|
Author: Erland Sommarskog
|
Rating:
|
|
A very common requirement in an information system is to have a function (or several functions) where the users are able to search the data by selecting freely among many possible criterias. This is a tough challenge, because not only must you produce the desired output, but you must also keep the response time within acceptable limits, at least for common searches. And on top of all, the code must be maintainable, so you can meet new needs and requirements....
|
|
|
|
|
|
