Sharing the lessons I've learned through my experiences as a Database Administrator (by Dustin Brown)
http://tsqlsource.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Wednesday
LOAD TIME
0.2 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
8
SSL
EXTERNAL LINKS
10
SITE IP
192.0.78.13
LOAD TIME
0.249 sec
SCORE
6.2
T-SQL at your fingertips | Sharing the lessons I've learned through my experiences as a Database Administrator | tsqlsource.wordpress.com Reviews
https://tsqlsource.wordpress.com
Sharing the lessons I've learned through my experiences as a Database Administrator (by Dustin Brown)
tsqlsource.wordpress.com
Long Running Transaction Detection | T-SQL at your fingertips
https://tsqlsource.wordpress.com/2011/05/19/longrunningtransactiondetection
T-SQL at your fingertips. Sharing the lessons I've learned through my experiences as a Database Administrator. Practical Table Partitioning with SQL Server. Looping through a data set using Dynamic SQL or Cursor →. Long Running Transaction Detection. May 19, 2011. This script lists all of the current transactions occuring on the server on a per database level. It also displays the inputbuffer, spid of the transaction, transatction log state, and the transaction start time. Leave a Reply Cancel reply.
September | 2010 | T-SQL at your fingertips
https://tsqlsource.wordpress.com/2010/09
T-SQL at your fingertips. Sharing the lessons I've learned through my experiences as a Database Administrator. Monthly Archives: September 2010. Practical Table Partitioning with SQL Server. September 3, 2010. Throughout my career year I have had the opportunity to get deeply involved in database partitioning while developing a reporting system against my companies OLTP database. As my data warehouse grew I quickly realized the benefits table partitioning could offer … Continue reading →.
Dustin Brown | T-SQL at your fingertips
https://tsqlsource.wordpress.com/author/bro98025
T-SQL at your fingertips. Sharing the lessons I've learned through my experiences as a Database Administrator. Author Archives: Dustin Brown. Using Cursors to efficiently delete large amounts of data from a table. May 20, 2011. Sometimes we get requests to delete millions of rows out of a table all at once. Any seasoned DBA will tell you this is not a task to take on lightly. The following example illustrates how to delete chunks of … Continue reading →. May 20, 2011. Long Running Transaction Detection.
Practical Table Partitioning with SQL Server | T-SQL at your fingertips
https://tsqlsource.wordpress.com/2010/09/03/practical-issues-in-partitioning
T-SQL at your fingertips. Sharing the lessons I've learned through my experiences as a Database Administrator. Long Running Transaction Detection →. Practical Table Partitioning with SQL Server. September 3, 2010. The most useful feature of table partitioning is the use of metadata operations. The Key? 100% metadata operation, one side of the switch will always will be empty. Safe if using to create new partitions which are empty. Split can be dangerous if splitting a partition loaded with data becau...
About | T-SQL at your fingertips
https://tsqlsource.wordpress.com/about
T-SQL at your fingertips. Sharing the lessons I've learned through my experiences as a Database Administrator. My name is Dustin Brown I have been working with SQL Server for the last 7 years. When I am not developing or administrating databases I enjoy spending time with my family and living the good life with her and our 4 children. I live and work in Sonora, CA. Please drop me a line at dustinkbrown@gmail.com. Leave a Reply Cancel reply. Enter your comment here. Address never made public).
TOTAL PAGES IN THIS WEBSITE
8
特色清流
野生冬笋 现挖现卖 纯天然福建清流冬笋 野生竹笋春笋新鲜冬笋. 清流紫薯 养生天然甘薯 连城地瓜干 香脆紫薯干120g袋装. 连城地瓜片 清流天然香酥红薯 地瓜干 番薯条 香脆红薯脆片 120克. 小薯仔 舌尖上的美食 零食佐餐 紫薯红心 清流连城番薯. 野生 润喉茶 白茶 藤茶 莓茶/霉茶/土家甘露茶 客家福建三明清流.
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.
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...
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: 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...
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...
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 - 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.
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...
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.
