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...

http://tsqlthoughts.blogspot.com/

OVERVIEW OF tsqlthoughts.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

16

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR TSQLTHOUGHTS.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

August

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Sunday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.2 out of 5 with 5 reviews

5 star

0

4 star

3

3 star

1

2 star

0

1 star

1

Hey there! Start your review of tsqlthoughts.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.1 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT TSQLTHOUGHTS.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

16

SSL

EXTERNAL LINKS

0

SITE IP

173.194.121.12

LOAD TIME

0.092 sec

SCORE

6.2

PAGE TITLE

Data Think | tsqlthoughts.blogspot.com Reviews

<META> DESCRIPTION

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...

<META> KEYWORDS

1 data think

2 thoughts about databases

3 0 comments

4 a new beginning

5 3 undo change

6 4 redo change

7 interesting performance problem

8 id int identity

9 firstname varchar 50

10 middlename varchar 50

CONTENT

Page content here

KEYWORDS ON PAGE

data think,thoughts about databases,0 comments,a new beginning,3 undo change,4 redo change,interesting performance problem,id int identity,firstname varchar 50,middlename varchar 50,lastname varchar 50,isvalid bit,net data access,dynamic sql,begin,name

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Data Think | tsqlthoughts.blogspot.com Reviews

https://tsqlthoughts.blogspot.com

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...

INTERNAL PAGES

tsqlthoughts.blogspot.com

1

Data Think

http://tsqlthoughts.blogspot.com/2007/06/new-beginning-i-have-spent-most-of-past.html

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. View my complete profile. Extending the Visual Studio Typed Dataset Sorry f. Interesting Performance Problem Part II In my las. Interesting Performance Problem: I recently had an.

2

Data Think: April 2006

http://tsqlthoughts.blogspot.com/2006_04_01_archive.html

Thursday, April 20, 2006. Temporary Tables vs. Table Variables. Here is an interesting behavior with SQL Server. A lot of developers use table variables and temporary tables interchangeably without understanding that they are different entities, each with slightly different behaviors. Here is one of the more interesting differences. If you have a transaction that affects a temporary table, and roll it back, the temporary table is restored to it's original state. For example. INSERT INTO @TableVar SELECT 1.

3

Data Think: February 2012

http://tsqlthoughts.blogspot.com/2012_02_01_archive.html

Wednesday, February 08, 2012. 5 years later. and I still hate oracle. Posted by mdritchie @ 1:01 PM. View my complete profile. 5 years later. and I still hate oracle. I have spent most of the past 7 . Extending the Visual Studio Typed Dataset Sorry f. Interesting Performance Problem Part II In my las. Interesting Performance Problem: I recently had an. Net Data Access If you are going to be using SQL . Optional items in a Where clause Here is a common. Temporary Tables vs. Table Variables Here is an i.

4

Data Think

http://tsqlthoughts.blogspot.com/2006/04/temporary-tables-vs.html

Thursday, April 20, 2006. Temporary Tables vs. Table Variables. Here is an interesting behavior with SQL Server. A lot of developers use table variables and temporary tables interchangeably without understanding that they are different entities, each with slightly different behaviors. Here is one of the more interesting differences. If you have a transaction that affects a temporary table, and roll it back, the temporary table is restored to it's original state. For example. INSERT INTO @TableVar SELECT 1.

5

Data Think: June 2006

http://tsqlthoughts.blogspot.com/2006_06_01_archive.html

Monday, June 05, 2006. Interesting Performance Problem Part II. In my last post I discussed a problem with a slow running query. In this post I will explain why. The answer to the problem can be seen if you look at the execution plan for the query. To do this from query analyzer choose the query - Show Execution Plan from the top menu. Alternatively execute 'set showplan Text ON'. This will cause the output to display the execution plan not the results. Once this is done you will see the following:.

UPGRADE TO PREMIUM TO VIEW 11 MORE

TOTAL PAGES IN THIS WEBSITE

16

OTHER SITES

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.

tsqltutor.com

tsqltutor.com - This website is for sale! - tsqltutor Resources and Information.

The owner of tsqltutor.com. Is offering it for sale for an asking price of 2000 USD! This page provided to the domain owner free. By Sedo's Domain Parking. Disclaimer: Domain owner and Sedo maintain no relationship with third party advertisers. Reference to any specific service or trade mark is not controlled by Sedo or domain owner and does not constitute or imply its association, endorsement or recommendation.

tsqltutorials.com

Introduction and Definitions - T-SQL (Transact SQL) Tutorials

T-SQL Tutorials - TSQLTutorials.com. Tables, Columns, Rows. What is an index? This site will primarily focus on T-SQL used with Microsoft SQL Server. Most examples are for Microsoft SQL Server 2005, but most will work for earlier and later editions. The site will be updated as new editions of SQL Server are released. The Pages that aren't not linked in the navigation bar, have not yet be completed. Please help us complete the pages by giving a small donation (Button on left menu bar). Microsoft SQL Serve...