tsqlscripts.com
TSQLScripts.com: HomeTSQLScripts.com, SQLScripts for DBAs and Developers
http://www.tsqlscripts.com/
TSQLScripts.com, SQLScripts for DBAs and Developers
http://www.tsqlscripts.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
3 seconds
MonitorCare, LLC
Patrick LeBlanc
10647●●●●●lwood
Bato●●●●ouge , LA, 70810
US
View this contact
MonitorCare, LLC
Patrick LeBlanc
10647●●●●●lwood
Bato●●●●ouge , LA, 70810
US
View this contact
MonitorCare, LLC
Patrick LeBlanc
10647●●●●●lwood
Bato●●●●ouge , LA, 70810
US
View this contact
BUY YOUR DOMAIN
18
YEARS
0
MONTHS
25
DAYS
TUCOWS DOMAINS INC.
WHOIS : whois.tucows.com
REFERRED : http://domainhelp.opensrs.net
PAGES IN
THIS WEBSITE
0
SSL
EXTERNAL LINKS
8
SITE IP
66.96.146.203
LOAD TIME
3.037 sec
SCORE
6.2
TSQLScripts.com: Home | tsqlscripts.com Reviews
https://tsqlscripts.com
TSQLScripts.com, SQLScripts for DBAs and Developers
SQL Resources
http://martincatherall.com/sql-resources
Measure Twice, Cut Once. Martin Catherall's Blog. Here is a list of some SQL SERVER resources that I have found useful. Http:/ www.sqlskills.com/. Http:/ www.sqlservercentral.com/. Http:/ www.sqlpass.org/. Http:/ www.sql-server-performance.com/. Start the ball rolling by posting a comment on this article! Leave a Reply Cancel reply. Your email address will not be published. Required fields are marked *. You may use these. Martin’s Blog Archive. Martin on SQLServerCentral.com. September 30, 2015.
SQLDownSouth: June 2010
http://sqldownsouth.blogspot.com/2010_06_01_archive.html
Wednesday, June 30, 2010. Now that we have our feet wet, let’s get started with the next puzzle. In this puzzle we will be writing a query that returns Percentage Growth Year over Year. For example, if sales were $258,056 in 2006 and $389,456 in 2007, then the percentage growth would be (2007 sales – 2006 sales)/2006 sales. Here are the requirements:. 160; Internet Sales Amount and Percentage Growth (calculated measure). 160; Calendar Years. 160; Only Show United States Bike Sales. Talk to you soon,.
SQLDownSouth: April 2010
http://sqldownsouth.blogspot.com/2010_04_01_archive.html
Friday, April 23, 2010. R2 Road Show Recap. I will be doing a SQL Lunch. On each of the demonstrations in the upcoming months. The topics will include: Power Pivot, Report Builder 3.0, Utility Control Point, and Data Tier Applications. Stay tuned here and the SQL Lunch. Talk to you soon,. Patrick LeBlanc, MCTS. Founder www.TSQLScripts.com. And www.SQLLunch.com. Visit www.BIDN.com. Bring Business Intelligence to your company. Wednesday, April 14, 2010. Editing Saved SSIS Packages. During my last SQLLunch.
SQLDownSouth: July 2010
http://sqldownsouth.blogspot.com/2010_07_01_archive.html
Friday, July 30, 2010. MDX Puzzle #4 - Solution. So, here is what I started with:. Measures].[Internet Sales Amount]. Product].[SubCategory].Members ON. This satisfied all of the requirements except the filters, which are the reason for the post. My first try at limiting the result set to date between Ship Date Calendar Year 2006 and 2008 resembled this query:. Talk to you soon,. Patrick LeBlanc, SQL Server MVP, MCTS. Founder www.TSQLScripts.com. And www.SQLLunch.com. Visit www.BIDN.com. 160; I have dec...
SQLDownSouth: May 2010
http://sqldownsouth.blogspot.com/2010_05_01_archive.html
Wednesday, May 26, 2010. Connecting to DB2 using SSIS. To start, first download and install the Microsoft OLE DB Provider for DB2. Click here. To download. After it is installed I suggest rebooting your machine. In some cases a reboot is not required; however I have encountered problems without rebooting. Now click on the ellipses next to the Network drop down list and enter your IP address in the textbox labeled IP Address. Talk to you soon,. Patrick LeBlanc, MCTS. Founder www.TSQLScripts.com. I realize...
SQLDownSouth: March 2010
http://sqldownsouth.blogspot.com/2010_03_01_archive.html
Friday, March 19, 2010. SSRS – Format Multiple Columns. Often when designing reports you are required to apply the same formatting to multiple columns in one table or matrix. Since SSRS 2008 does not allow the developer to change the format of a column using Textbox Properties. When multiple columns are selected, the developer must either:. 183; Change the formatting one column at a time. 183; Be familiar with the expression language. Let’s assume that you have a report that looks similar to this:. Now a...
SQLDownSouth: August 2010
http://sqldownsouth.blogspot.com/2010_08_01_archive.html
Monday, August 30, 2010. Join me for Lunch - SQL Lunch #33 (Indicators, Sparklines and Databars). 33-SSRS 2008 R2 - Indicators, Sparklines and Databars. Live Meeting URL: https:/ www.livemeeting.com/cc/usergroups/join? 9/1/2010 11:30:00 AM CST. 33-SSRS 2008 R2 - Indicators, Sparklines and Databars. Talk to you soon,. Patrick LeBlanc, SQL Server MVP, MCTS. Founder www.TSQLScripts.com. And www.SQLLunch.com. Sunday, August 29, 2010. Rows: Country and State-Province. Your results should show Reseller Sales...
SQLDownSouth: September 2010
http://sqldownsouth.blogspot.com/2010_09_01_archive.html
Sunday, September 19, 2010. SSIS: Assign a value to Variable using Dataflow Script task. IDTSVariables100 vars = null. Vars[0].Value = Row.SalesDetailID;. Or post it here. Talk to you soon,. Patrick LeBlanc, SQL Server MVP, MCTS. Wednesday, September 15, 2010. Baton Rouge SQL Server User Group Meeting Tonight. There will be great prizes supplied by Enta. A Nook (plays all three e-reader types), Madden 2011, Windows 7, and many more. September 15, 2010. User Group Support Services. SQL Server 2008 R2 intr...
TOTAL LINKS TO THIS WEBSITE
8
TSqlMigrations - Home
Project Hosting for Open Source Software. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Change History (all pages). Moved to https:/ github.com/g0t4/tsqlmigrations. Script out individual objects into their own folders (views/procedures/tables etc). Baseline an existing database that is not under version control. Create update scripts in an Updates folder. This is great to setup integration test environments. Updates are timestamped when ap...
特色清流
野生冬笋 现挖现卖 纯天然福建清流冬笋 野生竹笋春笋新鲜冬笋. 清流紫薯 养生天然甘薯 连城地瓜干 香脆紫薯干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...
