tsqlparsergdr.codeplex.com
TSQL Parser based on Database Edition GDR - Home
Project Hosting for Open Source Software. TSQL Parser based on Database Edition GDR. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Change History (all pages). This TSQL Parser is based on Microsoft Database Edition GDR, this implementation helps in finding tables and columns used in MS SQL statements. This project contains Two solutions,. XParser and sample, xParser is my attempt at browsing DOM and Sample is how to use the DOM results.
tsqlprincess.wordpress.com
Humor Me a T-SQL Princess | DBAs really do have a sense of humor
Humor Me a T-SQL Princess. DBAs really do have a sense of humor. My Name is Rebecca. Yes, We Still Run SQL Server 2000. October 24, 2014 by tsqlprincess. Recently, I tweeted about having to restore fourteen databases in SQL Server 2000. I wasn’t surprised to receive some good natured ribbing about still having databases in SQL Server 2000, and I’m okay with that…. For the most part. Yes, I know and agree that it is not good (. Major understatement of the year/decade. That I know of, at least. Of these in...
tsqlq2.blogspot.com
THU VIEN TRUONG SI QUAN LUC QUAN 2
THU VIEN TRUONG SI QUAN LUC QUAN 2. Thứ Năm, ngày 26 tháng 8 năm 2010. GIOI THIEU DANH LAM THANG CANH CUA TINH BINH PHUOC. Thích thú những thảm cỏ xanh Bàu Lạch (Bình Phước). Giữa bạt ngàn rừng nguyên sinh, rừng thưa, rừng tái sinh rậm rạp, bỗng xuất hiện những trảng cỏ kết nối nhau thành một thảo nguyên rộng chừng 500ha. Cỏ ở đây đa phần là cỏ chỉ, hoặc cỏ kim, hoặc cỏ stylo, mọc cao không quá 10cm. Những trảng cỏ mướt xanh như tấm thảm thoai thoải mênh mông làm mát mắt du khách. Núi Bà Rá - Bình Phước.
tsqlscripts.com
TSQLScripts.com: Home
Skip to the main content area of this page. Transact SQL scripts written by. DBAs and Developers for. If you would like to submit a script to our site click here. Get Performance Tips Directly From SQL Server. This script was written by Ian Stirk. You can read the full article here: http:/ www.sqlservercentral.com/articles/Performance Tuning/66729/. Identifying Queries Running Slower Than Normal. Drop and Recreate Foreign Keys. Generate Database Role Permissions. This script will generate a list of all u...
tsqlsource.wordpress.com
T-SQL at your fingertips | Sharing the lessons I've learned through my experiences as a Database Administrator
T-SQL at your fingertips. Sharing the lessons I've learned through my experiences as a Database Administrator. Using Cursors to efficiently delete large amounts of data from a table. May 20, 2011. Looping through a data set using Dynamic SQL or Cursor. May 20, 2011. 2 Set Based Cursor. Create table #temp2 ( name nvarchar(max) ) declare @ID int - Deletes one row at a time DECLARE TestCursor cursor Forward Only STATIC FOR Select dbid from sysdatabases OPEN TestCursor FETCH NEXT FROM TestCursor into @ID WHI...
tsqlsplit.codeplex.com
T-SQL Split Field by Delimiter - Home
Project Hosting for Open Source Software. T-SQL Split Field by Delimiter. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Change History (all pages). T-SQL hasnt split function to split a text by delimiter, this function return a string which can be used in select statement to split a varchar column by a delimiter to multiple columns. This function should be used with Dynamic T-SQL. Last edited Feb 21, 2012 at 1:33 AM.
tsqlt.org
tSQLt - Database Unit Testing for SQL Server
TSQLt - Database Unit Testing for SQL Server. Database Unit Testing for SQL Server. Welcome to tSQLt – The Database Unit Testing Framework for SQL Server. On this website you will find the information necessary for installing and using tSQLt. Also, you can click on the Articles link on the menu above for more information on database quality. TSQLt is a database unit testing framework for Microsoft SQL Server. tSQLt is compatible with SQL Server 2005 (service pack 2 required) and above on all editions.
tsqlthoughts.blogspot.com
Data Think
Wednesday, February 08, 2012. 5 years later. and I still hate oracle. Posted by mdritchie @ 1:01 PM. Tuesday, June 19, 2007. I have spent most of the past 7 years developing applications driven by SQL Server database and considered myself an expert at database development. Unfortunately, it is hard to be an database programming expert when one knows little about the #1 database on the market. Posted by mdritchie @ 7:18 PM. Saturday, September 09, 2006. Extending the Visual Studio Typed Dataset. Sorry for...
tsqltidy.blogspot.com
T-SQL Tidy Blog
News and Updates for T-SQL Tidy. An On-line Transact-SQL parser and formatter. Tuesday, 4 November 2014. New Podcast on Technology and SQL Server - Sounds of SQL. I've been planning on doing a technology / SQL Server podcast for a while. There are some really goods ones on tech I listen to like; .NET Rocks. And of course Scott Hanselman's podcasts. And of course the 'fancy'. Ratchet and the Geek. Which is my favourite right now ). The interviews will be going up on Sounds of SQL. Links to this post.
tsqltricks.wordpress.com
T-SQL AND SQL SERVER TRICKS | My adventures in the wonderful world of Database development. Enjoy!
T-SQL AND SQL SERVER TRICKS. Finding prime numbers with a Transact-SQL function. December 17, 2008 at 9:27 pm Posted in TSQL Functions. One of my first intensive experiences in coding (back in my Sinclair ZX81. Days), was to write a piece of code which would determine if a number was a prime or not. Since my ZX81 was a very slow 8-bit machine, I had to code something that would work fast (and, of course, in FAST mode -read the Wiki, you’ll understand). Or it, included. 8212; Create date: 12/14/2008.