Quarrel.Net | Online Flash Games | Browser Games | MySpace Layouts | Daily PSP Movie
RSS Directory
RSS Feeds Directory Bookmark | Simple mode | Advanced mode

Weblogs [Personal] (1861) Weblogs [Tech] (699) Business (2080) Technology (1544)
News (601) Miscellaneous (379) LifeStyle (930) Shopping (329)
Regionals (709) Companies (1830) Recreation (1568) Political (49)
Other Languages (133) Pets & Animals (52) Romance & Relationships (60) Celebrities (98)
Total feeds: 12922

Add Your Feed

SQLTeam.com

[ Put this feed on your website - Click Here ]

Description: SQLTeam.com is for SQL Server developers and DBA's and features original articles, forums, tips and tricks.
Format: RSS 2.0
Feed URL: http://www.sqlteam.com/rss.asp
 
Latest Headlines

SQLTeam.com

Using xp_ReadErrorLog in SQL Server 2005
Mon, 12 May 2008 00:00:00 GMT

I would like to share some interesting parameters I found for the undocumented extended stored procedure xp_ReadErrorLog. In doing some testing with this extended stored procedure I found four very interesting parameters. Adding to some of the articles already on the web that discuss undocumented stored procedures, in this article I will explain my testing, use and some examples of the procedure.
ApexSQL Giving Away 25 Copies of Enforce
Wed, 07 May 2008 00:00:00 GMT

ApexSQL is launching a new product called Enforce.  As part of their launch they are giving away twenty-five copies to our members for participating in the forums.  Read on for the details and to find out if you've already won.
Joining to the Next Sequential Row
Wed, 02 Apr 2008 00:00:00 GMT

One of the more obscure requirements that a developer may find themselves facing is the need to compare a row with its immediate sibling. One such case is when a list of values needs to be processed to produce a moving average or to smooth a sequence of statistical numbers where their order is important.  For example, values lying along a time line. The solution is actually quite simple, but not immediately obvious.
Using the TIME data type in SQL Server 2008
Thu, 06 Mar 2008 00:00:00 GMT

SQL Server 2008 introduces a TIME data type which allows us to store the time without the date.
Implementing Table Inheritance in SQL Server
Wed, 20 Feb 2008 00:00:00 GMT

When designing a database, we sometimes come across situations where there are multiple types of entities that we are modeling, but we'd like them to all have certain attributes or relations in common. Using "sub-type" tables is a simple way to implement table inheritance in SQL Server.
Writing Outer Joins in T-SQL
Mon, 11 Feb 2008 00:00:00 GMT

Occasionally someone will ask for my help with a query and say that both a right outer join and a left outer join was tried, and still the expected results were not achieved. That made me realize that some developers do not completely understand outer joins and that an article explaining how to use them might help.
Integrating Profiler and PerfMon Log Files
Wed, 06 Feb 2008 00:00:00 GMT

Troubleshooting SQL Server requires the use of both PerfMon (Performance/System Monitor) and SQL Trace files created by SQL Profiler or directly by SQL Server trace. Analysis of the gathered data is much easier if you can correlate your trace file with the PerfMon counters. In this article I'll show how to create a PerfMon counters log file and SQL Profiler Trace file, how to read them both and how to correlate the two files in SQL Profiler.
Which is Faster: SAN or Directly-Attached Storage?
Mon, 21 Jan 2008 00:00:00 GMT

Or should I place my database files on SAN or directly-attached storage? This is a frequently asked question. It comes up repeatedly in public newsgroups, email discussion lists, and private meetings with customers who are concerned with database performance.
Using Included Columns in SQL Server 2005
Mon, 14 Jan 2008 00:00:00 GMT

One of the new features found in SQL Server 2005 is the ability to add additional columns, called Included Columns, to a non-clustered index. This article will explain the advantages of using included columns and what impact they will have on your database.
See Kalen Delaney's SQL Server Seminar in Kansas City
Wed, 09 Jan 2008 00:00:00 GMT

We've arranged for Kalen Delaney to present Controlling and Reusing Query Plans in Kansas City on March 26th, 2008. This full-day seminar will cover techniques available for determining if, when and how you should override the optimizer's choice of query plans. It will also cover how to determine if your plans are being reused, how you can determine if reuse is desirable for your queries, and how you can control query caching behavior. You can get early-bird pricing through February 10th. Please see our corporate site for more information.


Webmasters - Another button for your collection RSS Directory


FeedBoy.com © 2005-2007
Hosted By NeonHQ

Partners
Quarrel.Network | Browser Games | Online War Games | Mafia Game | Online Flash Games
Singapore Outsource | Backpacking Travel | Legal Glossary | Mobile Ringtones | Internet Marketing
PT Cruiser | Car Videos | Honda Car Forum

Turnkey Scripts | Photoshop Tutorials | RSS Protocol | Linux Web Hosting
Zoekmachine Optimalisatie | DirArchive Web Directory | Sidney Cosby | Free Teen Webcam Chat | Free Video Chat
Orlistat | International City | Alli | Groovy Java Games