Thursday, 19 July 2018
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
Category
SQL Server TSQL Code Samples
SQL Server TSQL Code Samples

Jump to:

Articles
26/02/2005 12:44:38 PM Author: greglow
Security Summit 2005 SQL Server 2005 Presentations
Greg Low's 3 security summit session powerpoints are available.
25/05/2005 5:54:35 PM Author: greglow
SQL Server Podcast now available
A new SQL Server Podcast (downloadable audio show) is now available at www.sqldownunder.com. 1st episode features Kalen Delaney. Enjoy!
18/07/2005 5:43:11 PM Author: greglow
Two more podcasts available
Two more SQLDownUnder podcasts are now available from www.sqldownunder.com. Show 2 features Hilary Cotter on replication and show 3 features Kent Tegels on SQLXML.
15/08/2005 10:36:28 AM Author: greglow
SQL Down Under Podcasts - Niels Berglund - Service Broker & Bob Beauchemin - CLR Integration
SQL Down Under Podcast #5 with Niels Berglund discussing SQL Server 2005 Service Broker and #5 with Bob Beauchemin discussing CLR Integration in SQL Server 2005 are now available for download from www.sqldownunder.com.
8/09/2005 3:42:39 PM Author: greglow
SQL Down Under Podcast #6 with Itzik Ben-Gan on T-SQL
SQL Down Under Podcast #6 with Itzik Ben-Gan discusses solving problems using T-SQL and upcoming enhancements to T-SQL in SQL Server 2005 is now available for download from www.sqldownunder.com.
17/10/2005 4:45:50 PM Author: wallismark
SQL Coding Standards
There is a distinct advantage in following a community wide set of common coding standards. This article presents suggested standards as taken directly from the UK user group site (i.e. people smarter than me have put together their suggestions)
25/11/2005 4:36:18 PM Author: greglow
3 more podcasts available including Jim Gray
3 more podcasts (Roger Wolter on SQL Express, Adam Machanic on stored procedures as API's and legend Jim Gray on the future of SQL Server) can be downloaded from www.sqldownunder.com now.
18/01/2006 11:20:15 AM Author: greglow
SDU Podcast #11: Tom Moreau
SQL Down Under podcast #11 featuring SQL Server MVP Dr Tom Moreau is now available for download from www.sqldownunder.com.
3/02/2006 3:39:09 PM Author: greglow
SQL Down Under Podcast #12 - Louis Davidson
SQL Down Under Podcast #12 featuring guest SQL Server MVP Louis Davidson is now available for download from www.sqldownunder.com.
1/04/2006 12:02:27 AM Author: greglow
SQL Down Under Show 13 - Bill Graziano
SQL Down Under show 13 with guest SQL Server MVP Bill Graziano is now available for download from www.sqldownunder.com.
6/05/2006 8:40:48 PM Author: yeehaa2
Canberra IT Survey
Check out http://canberra-it-survey.blogspot.com/ for a great survey on IT contracting in Canberra!
7/05/2006 1:00:42 PM Author: greglow
SQL Down Under show 15 - Kim Tripp - SQL Indexing
SQL Down Under show 15 with guest RD & MVP Kim Tripp is now available for download from www.sqldownunder.com.
8/06/2006 5:13:34 PM Author: greglow
SQL Down Under Show 17 - Gert Drapers - DataDude
SQL Down Under show 17 with guest Microsoft Architect and Development Manager Gert Drapers discussing the upcoming Visual Studio Team Edition for Database Professionals is now available for download from www.sqldownunder.com.
28/08/2006 11:48:26 PM Author: greglow
SQL Down Under Show 18 with guest Don Vilen
SQL Down Under Show 18 with guest Don Vilen is now available for download from www.sqldownunder.com.
21/09/2006 11:42:20 PM Author: casperleon
T-SQL Coding Standard
A proposal for a simple T-SQL Coding Standard
12/01/2007 1:24:19 PM Author: greglow
SQL Down Under shows 19 & 20 - Peter Myers and Richard Waymire
SDU podcast 20 with guest Richard Waymire is now available for download from www.sqldownunder.com. Show 19 with local guest Peter Myers is also available.
17/02/2007 5:00:51 PM Author: greglow
SQL Down Under Show 21
SQL Down Under show 21 with guest Joe Celko is now available for download from www.sqldownunder.com
25/04/2007 3:34:24 PM Author: greglow
SQL Down Under show 22 with guest Kevin Kline
SDU Show 22 with guest SQL Server MVP and PASS President Kevin Kline is now available for download from www.sqldownunder.com.
19/10/2007 11:03:56 AM Author: greglow
SQL Down Under show 24 - Paul Randal
SQL Down Under show 24 with guest Paul Randal is now available for download from www.sqldownunder.com. In it, Paul discusses DBCC CHECKDB for 2005 and improvements in 2008 for database mirroring and partitioned tables.
5/01/2008 11:29:12 AM Author: greglow
SQL Down Under shows 25 and 26 (Matthew Roche and Chris Randall)
SQL Down Under shows 25 (Matthew Roche and SSIS) and 26 (Chris Randall and SQL Certification) are available for download from www.sqldownunder.com.
11/01/2008 5:11:42 PM Author: greglow
SDU Show 27 - SQL Legend David Campbell
SQL Down Under show 27 with SQL Server product group legend David Campbell discussing the process of building SQL Server 2008 (and what he’s most looking forward to in it) is now available from www.sqldownunder.com.
18/01/2008 2:30:52 AM Author: greglow
SDU show 28 - Ed Lehman - SQL community
SQL Down Under show 28 with guest Ed Lehman discussing the SQL community including the MVP program, the Connect feedback site, the Newsgroups, the Forums and CodePlex is now available for download from www.sqldownunder.com.
24/01/2008 2:12:50 PM Author: greglow
SQL Down Under show 29 - Richard Tkachuk - Analysis Services and SQL CAT team
SQL Down Under show 29 with SQL CAT team member Richard Tkachuk discussing the CAT team, working with Analysis Services and what's coming for Analysis Services in 2008 is now available for download from www.sqldownunder.com.
5/02/2008 8:06:16 AM Author: greglow
SQL Down Under show 30 - Pablo Castro
SQL Down Under show 30 with Pablo Castro discussing LINQ, Entity Framework and ADO.NET Data Services for the DBA and database developer is available for download from www.sqldownunder.com.
23/02/2008 5:31:27 PM Author: greglow
SQL Down Under show 32 - Dr Michael Rys - SQL Server and XML
SQL Down Under show 32 with SQL Server product group member Dr Michael Rys is now available for download from www.sqldownunder.com. In this show, Michael discusses why XML matters in SQL Server, provides an overview and tips on the support provided in earlier versions and discusses the changes upcoming in SQL Server 2008.
29/02/2008 3:36:21 PM Author: greglow
SDU Show 33 - Allen White - Automating SQL admin with SMO and Powershell
SQL Down Under show 33 with SQL Server MVP Allen White discussing the automating of administration using SMO and Powershell is available for download from www.sqldownunder.com.
14/03/2008 10:09:46 AM Author: greglow
SQL Down Under show 35 - Roger Doherty - SQL 2k8 for Database Developers
SQL Down Under show 35 with guest SQL Server DPE Evangelist Roger Doherty is now available for download from www.sqldownunder.com.

In the show, Roger discusses what developers are looking forward to in SQL Server 2008.
19/07/2008 3:05:14 PM Author: greglow
Recent SQL Down Under Shows - Lubor Kollar, Chris Webb, Andy Leonard
SQL Down Under shows 36, 37, 38 with guests Lubor Kollar, Chris Webb and Andy Leonard are available for download from www.sqldownunder.com.
25/07/2016 7:46:34 PM Author: blairsteve44
Get the Best-Quality Recognition Lapel Pins to Appreciate the Efforts of Employees
Employee Recognition Lapel Pins is a renowned company that manufactures and distributes employee recognition pins. They also make custom lapel pins with endless customization possibilities.

31/07/2016 12:10:19 AM Author: blairsteve44
Izzz: Offering a Wide Collection of Bed and Quilt Cover Sets
Izzz: Offering a Wide Collection of Bed and Quilt Cover Sets
15/10/2016 11:56:52 PM Author: blairsteve44
Avail the Best-in-Class Eye Health Care Services in Boise
Boise Mountain Eyecare is one of the most trusted and reputable clinics that are dedicated in providing effective and affordable eyecare solutions.
11/11/2016 9:14:12 PM Author: blairsteve44
Find out How to Deal with Infidel Partners like a Champ
Jacqueline Thibodeau is a betrayal trauma GTA expert who treats partners of sexually addicted people. She is more than qualified to deal with your problems.
22/11/2016 8:58:48 PM Author: blairsteve44
Visit the Best Dental Office in Texas for a Confident Smile
At Radiant Smiles you will find the latest technology and equipment to help you achieve and maintain your oral health. Whether you want basic dental cleanings, braces, or cosmetic restoration, you can surely rely on their professionals.
23/12/2016 11:52:45 PM Author: blairsteve44
Install Solar Systems to Reduce your Energy Cost
Clean NRG is a leading company that provides a range of solar equipment including solar panels Perth, inverters and battery storage devices to reduce the energy consumption at your living as well as work space.
23/12/2016 11:54:09 PM Author: blairsteve44
Install Solar Systems to Reduce your Energy Cost
Clean NRG is a leading company that provides a range of solar equipment including solar panels Perth, inverters and battery storage devices to reduce the energy consumption at your living as well as work space.
19/01/2017 12:23:18 AM Author: blairsteve44
Avail Services of Auto Glass Repair Claresholm and Secure Your Windshield
The workability and visible transmittance properties makes it reliable for various types of purposes. There are various types of glasses such as float glass, toughened glass, laminated glass, tinted glass and many more which get installed at your homes and workplaces.
10/02/2017 9:58:23 PM Author: liyojosef987
Looking Forward to Learn Back Pain Exercises? Get Optimum Solution Here!
Performance Care RX is one such provider that offers different bullet proof programs and with the help of trainers and coaches makes you learn knee pain exercises, back, shoulder and hip exercises as well.
18/02/2017 11:43:57 PM Author: blairsteve44
Choose the Best Air Conditioning Installation & Repairing Services in Lethbridge
There are many service providers available for installation and repairing of air conditioners and, Charlton & Hill is one of the most reliable air conditioning companies which offer installation and maintenance services for your air conditioner and heating system at reasonable cost.
21/03/2017 4:27:00 PM Author: blairsteve44
Purchase Trendy Clothes at Wholesale Prices from Renowned Online Store
My Lovely Dresser is one such exemplary online store that offers variety of out-fits for both men and women at wholesale rates.
19/06/2017 9:04:53 PM Author: liyojosef987
Avail Premium Quality IT Support Services to Resolve Networking Issues
Supreme Systems is a fast growing IT company West Midlands offering an extensive range of IT support services such as work place recovery, infrastructure upgrades and disaster recovery and resolve all types of IT issues in your business firm.
20/06/2017 2:50:47 PM Author: liyojosef987
How Encouraging Christian Cards are useful for all Occasions
Trinity Cards is a reputed online store providing quality Christian greeting cards with motivational quotes and sayings. These cards are of superior quality and are provided to you in pocket friendly prices. They also provide free shipping and amazing offers.
20/06/2017 10:22:54 PM Author: liyojosef987
How Buses are the Most Convenient Way to Enjoy Traveling in Bolivia
Tickets Bolivia is a travel company that utilizes innovative technology and its wide network of travel operators to offer its clients with the safest and best means of travel via train and bus Cusco Puno.
10/03/2018 6:11:25 PM Author: liyojosef987
ICON Yachts || Ton Van Dam on Its Way to Make ICON Yachts Industry Leader Again
Ton Van Dam is a gem of investor and he can easily judge the fate of the commodity or the company.
10/03/2018 9:49:18 PM Author: liyojosef987
Fully Restore your Vision Naturally
Endmyopia.org is a website dedicated to improving the vision of people suffering from myopia.
10/03/2018 10:47:24 PM Author: blairsteve44
Own Stunning Properties with Beach Views and Sunshine in Costa del Sol
ABC Property experts are a firm that helps you find your dream home in Estepona property.
30/03/2018 4:12:13 PM Author: blairsteve44
Take Conscious Decisions and Be Successful in a Foreign Country!
Empower Immigrants is a website that is focused towards empowering the vulnerable immigrants in a new country.
30/03/2018 5:21:56 PM Author: blairsteve44
Immigrants Should Use Their Culture Instead of Getting Used By It
Empower Immigrants is the leading website that publish blogs written by Frank Silletti based on immigrant issues like “Cultural Differences Immigrants Face” and more.
2/04/2018 4:20:01 PM Author: blairsteve44
Find Elegant Accommodation While Touring Croatia!
Croatia Luxury Rent is the leading agency that offers elegant villas Istria on rent to tourists.
4/04/2018 4:02:10 PM Author: liyojosef987
Sett inn 100 for 600 – ComeOn!
They offer amazing bonuses like deposit 100 get 600 (sett inn 100 få 600) and many more bonuses for players.
9/04/2018 8:05:08 PM Author: liyojosef987
Isaac Mildenberg: Business Tycoon and Person of Generosity
Isaac Mildenberg is a person of generosity. He works with many charities and foundation to bring the best out of mankind.
16/04/2018 4:09:22 PM Author: liyojosef987
How Teachers can Use Character Building Lesson Plans for Child Development
LoveKidsAcademy.com is the best and reliable source from where you can find highly effective lesson plans for teachers.
18/04/2018 5:19:42 PM Author: liyojosef987
Professionals for Top-notch Car Maintenance Services – Precise Transmission
Precise Transmission is the one-stop destination for all those who want to avail top-of-the-line Car Transmission Repair Service.
18/04/2018 10:00:44 PM Author: liyojosef987
Buy Sneakers Online and Get On Top Of Your Fashion Game
Find My Sneaker is a renowned online seller of shoes and sneakers.
25/04/2018 3:28:55 PM Author: liyojosef987
Enjoy the Benefits of Showering using High quality of Showering Accessories!
Shower Stream is a trusted online store that offers an exclusive range of shower products.
26/04/2018 6:55:58 PM Author: liyojosef987
Get the Best Consultancy for Renewable and Electronic Designs
MEEE is one such top of the line source to avail the best possible services.
28/04/2018 10:22:38 PM Author: blairsteve44
Need a Personal Touch from Experts During Construction Of Your Home
For over 28 years, Dusselier and Marks Homes also called as D&M Homes, Inc. has been building homes for their clients in the Kansas City area.
16/05/2018 11:54:44 PM Author: liyojosef987
Why You Need To Read About the Travel Destination before Visiting It
Gogga.net is one-stop solution for people who want to read about the destination before visiting them.
22/05/2018 9:50:57 PM Author: liyojosef987
Challenge Yourself with the Infrared Light Therapy for Weight Loss
NUSHAPE provides redlight wraps for weight loss which is one of the most effective and portable devices available these days for weight loss.
23/05/2018 7:46:30 PM Author: blairsteve44
Splendid Fine Art Reproduction Paintings for Your Walls
Galerie Dada is the place where one can get exceptional reproduction artworks such as Van Gogh reproduction paintings. They make sure that these artworks are made by qualified and practiced fine art graduates and professionals.
4/06/2018 7:06:04 PM Author: liyojosef987
Loren Israel || Write Hit Songs by Holding a Helping Hand of Loren Israel
Loren Israel is hard-working, passionate and honest with shaping all the music newbie’s talents.
4/06/2018 8:23:44 PM Author: liyojosef987
Loren Israel || Explore the New Success Levels in Music Industry with Loren Israel
Loren Israel is hard-working, passionate and honest with shaping all the music newbie’s talents.
6/06/2018 7:14:27 PM Author: blairsteve44
How Motivational Blogs of an Immigrant can Help You
Empower Immigrants is a platform solely created for assisting and empowering immigrants in the situation of their transition to some new country from their own native place.
6/06/2018 7:44:17 PM Author: blairsteve44
Overcome Loneliness during Immigration and Start Reading Real Life Experiences
Empower Immigrants is a platform solely created for assisting and empowering immigrants in the situation of their transition to some new country from their own native place.
6/06/2018 7:52:29 PM Author: blairsteve44
Effortlessly End the Feeling of Being Lost in the New Country
Empower Immigrants is a platform solely created for assisting and empowering immigrants in the situation of their transition to some new country from their own native place.
7/06/2018 2:54:04 PM Author: blairsteve44
Discover the New Way of Experiencing Raw Piece of Land
Citiskopes is the platform that also helps in empowering the small enterprises in their business promotion by generating traffic for their business which will become extensively accessible by the users and visitors.
7/06/2018 3:46:28 PM Author: liyojosef987
Purchase Quality Fresh Seafood from a Credible Online Store
Freskoo is a leading online store that delivers fresh seafood at wonderful prices. You can buy fish online (comprar pescado online) on Freskoo and they will deliver it at your doorstep in just 24-48 hours.
7/06/2018 6:45:48 PM Author: liyojosef987
Choose Aluminium Extrusion LEDs for Adorning Your Home
Freskoo is a leading online store that delivers fresh seafood at wonderful prices. You can buy fish online (comprar pescado online) on Freskoo and they will deliver it at your doorstep in just 24-48 hours.
9/06/2018 9:30:02 PM Author: liyojosef987
Situations When You Need a Sexual Defense Lawyer
Henry Law Offices, LLC is one of the criminal law firms that constitute the best lawyers that can help you out with criminal defense cases efficiently.
11/06/2018 5:01:40 PM Author: liyojosef987
Hire the Team of Professionals for Video Marketing Services
Comelite Design Studio is the leading and eminent name of Video Production Kuwait in the realm of video marketing and video content marketing.
11/06/2018 9:22:31 PM Author: blairsteve44
Enhance Your Look by Purchasing Trendy Clothes and Accessories Online
Four Sisters Boutique is the place where you can find cute women's boutique clothes at an affordable price. They also bring trendy arrivals every week so that their customers don’t have to wait for too long.
12/06/2018 2:46:00 PM Author: liyojosef987
Rely On the Scientifically Proven Way of Achieving Pain Relief
Dr. Samantha Boyd is a well recognized chiropractor near me, and an acupuncturist who uses various therapies for providing holistic health and wellness to her patients.
12/06/2018 4:14:25 PM Author: liyojosef987
Hire Mobility Equipment for Elderly during Holidays
Spot On Holiday Hire always strives to providing tailored service which is required by you during your holidays. Manual Wheelchair Hire is one of their excellent services.
12/06/2018 5:18:48 PM Author: liyojosef987
Get the Dirty Carpets, Rugs and Upholstery Cleaned Quickly
Sparky Carpet Cleaning is a leading rug cleaning Long Beach service provider that refreshes, dirty and smelling carpets, rugs and Upholstery Cleaning Atlanta etc. across Baton Rouge, Atlanta, and Long Beach.
12/06/2018 8:29:49 PM Author: liyojosef987
Reflective Essay???
EssayPhD??????????????????????????,?????????????????,??????????
12/06/2018 10:20:05 PM Author: blairsteve44
Embellish Your Home with Hardwood Flooring
Elite Hardwood Flooring Company provides excellence to their value customers by taking care of their hardwood flooring and giving the finest service of hardwood floor installation San Mateo.
13/06/2018 10:45:21 PM Author: liyojosef987
Lennylemons Reviews || Lennylemons Reviews || Visit Lenny Lemons Today for Purchasing the Delightful Clothes for Baby
Lenny Lemons is one of the most eminent online shopping stores who provide adorable clothes and cute accessories for infants and toddlers.
15/06/2018 2:15:13 PM Author: liyojosef987
Lenny Lemons || Lenny Lemons || Lenny Lemons: The Perfect Destination to Buy Trendy Baby Clothing
Lenny Lemons is one of the most eminent online shopping stores who provide adorable clothes and cute accessories for infants and toddlers.
21/06/2018 9:53:13 PM Author: liyojosef987
Innovative Learning for Kids during School Breaks
KNB Learning is all about challenging kids to think and learn in a fun-filled viable environment. Their summer camp Oakville Ontario will help kids to enjoy and learn lots of productive and beneficial subjects and activities.
23/06/2018 4:03:39 PM Author: liyojosef987
Adapt the Natural Healing Methods for Getting Well Completely
Master Jie who is an energy healer Melbourne got enlightenment in 2010, and since then he is helping people with holistic health approaches. He is a member of International Energetic healing association and believes in improving person’s health in natural way.
26/06/2018 11:32:33 PM Author: liyojosef987
Avail the Best SEO Services to Create a Buzz for your Company
Orion7 is the leading SEO Dallas service that offers quality assured service that helps to enhance the growth of your firm or product.
28/06/2018 5:30:53 PM Author: liyojosef987
Hire the Most Acclaimed 3D/2D Animation Service Provider for Commercial Use
Double Impact Studio comprises of the team of industry expert dedicated to providing stunning graphics and video to their clients. Their 2D animated explainer video is just outstanding.
28/06/2018 8:36:57 PM Author: liyojosef987
Why Certificate of Conformity Is Necessary For Your Vehicle
COC Certificat is the fastest growing online business portal which allows you to order European certificate of conformity anytime.
29/06/2018 8:13:22 PM Author: liyojosef987
How Xanax Helps You to Overcome Common Health Issues
Nextdayxanax.net is the fastest growing online medical store which ensures Xanax next day delivery without any hassle and provides the medicine at economical prices.
30/06/2018 3:21:58 PM Author: liyojosef987
Steve Kinne || Steve Kinne || Steve Kinne || End All Your Real Estate Complexities with Steve Kinne’s Flawless Assistance
Steve Kinne is a full-time realtor, who has till date made more than $45 million in real estate transactions, which shows that he is an experienced person who is committed to fulfilling your dream goals.
30/06/2018 7:10:02 PM Author: blairsteve44
Listen to Healing Sounds to Attain Positive Vibes
HealTone is a US based global company focusing exclusively on creating flawless, effective and unique Chakra Sound Healing for the users from different corners of the world.
30/06/2018 9:38:31 PM Author: blairsteve44
Embrace yourself with Effective Sound Therapy to Attain Affirmative Results
Sound Pharmacy is the leading sound healing therapy provider that can cure multiple diseases naturally without even approaching a physician and consuming any medicine. In case you are looking for natural remedies for migraines then Sound Pharmacy is the perfect platform for you.
2/07/2018 9:05:40 PM Author: blairsteve44
Discover the World of Robotics with Robotex International 2018
Robotex International is the flagship event hosted in Tallinn, Estonia each year. The event encompasses the biggest Robotics Competition 2018 in the world and the most epic frontier tech conference.
6/07/2018 6:49:41 PM Author: blairsteve44
How Immigration can Affect Your Kid’s Heart and Life
Empower Immigrants aims for empowering all other current and potential immigrants by sharing free immigration advice online.
6/07/2018 7:22:11 PM Author: blairsteve44
Get through loneliness in New Country by Reading Inspirational Blogs
Empower Immigrants aims for empowering all other current and potential immigrants by sharing free immigration advice online.