sqldts.com
SQLDTS.com - Data Transformation Services on the web
The Rational Guide to Extending SSIS 2005 with Script. Data Transformation Services on the web. Welcome to SQLDTS.com, the Data Transformation Services (DTS) resource on the web. Hopefully there is something here for all levels of DTS user including you. Featured article: DTS Backup 2000. Most popular articles this month. Global Variables and Stored Procedure Parameters. Working with files and the FileSystemObject. Getting Syntax Help for DTSRun. Redistributing DTS with your program. Connections are wher...
sqldud.blogspot.com
SQL Tips & Tricks
SQL Tips and Tricks. Its all about structured query language (SQL) - SQL Query Snippets, LINQ Snippets, SQL Stored Procedures, SQL Server Articles, SQL Server Feeds, SQL Server Analytics, SQL Server Integration Services (SSIS), Microsoft SQL Server BIG DATA - HortonWorks, SQL Server CRM Integration. C# / VB.NET Tips and Tricks. Tuesday, May 14, 2013. How to Perform Analysis with SQL Server Analysis Services Project (Step by Step Instruction). Select the Generate tables option. Time dimension is created a...
sqldude.wordpress.com
Sqldude's Blog | A random Collection of SQL
A random Collection of SQL. Month name from month number. December 13, 2010. At times, we have to get the month name and all that we have is a month number, here is a quick smart way to get the name of the month corresponding to the month number:. SET @month = 4. SELECT DateName(mm,DATEADD(mm,@month,-1) Month. To get the list of all the months spelled our along with their corresponding month numbers:. SELECT Number 1 as [Month Number],. DateName(mm,DATEADD(mm,Number,0) as [Month Name]. From → Scripts.
sqldumbass.com
SQL Dumbass
Fighting dumbasses, one query at a time…. This is the top bar widget. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis quis ipsum magna, sit amet ultricies nulla. Phasellus justo neque, interdum sed porta tempus, dapibus eu augue. Curabitur quis dolor ac nunc accumsan ultricies. Praesent et diam orci, id tincidunt massa. Nunc ut tortor turpis. Share the Love, Dumbass! September 6th, 2011. Enjoy and have fun, and don’t make it personal (or offensive) or you will find yourself banned. July 20t...
sqldump.wikidot.com
Welcome my SQL Dump - Marcus' SQL Dump
Oracle queries and stuff that I need frequently. Perf, Traceing, Auditing. Hint for a good optimizer index cost adj value. Deleteing failed datapump jobs. Query PGA/UGA sizes by SID. Last analyzed - Statistics. PROCESSES Parameter to low? Converting Date to TIMESTAMP TZ. Size PGA and SGA. It seems you have no tags attached to pages. To attach a tag simply click on the. Button at the bottom of any page. Add a new page. Welcome my SQL Dump. Use the navigation bar on top to get to the real content. Notify a...
sqldumps.com
sqldumps.com - Registered at Namecheap.com
This domain is registered at Namecheap. This domain was recently registered at Namecheap. Please check back later! This domain is registered at Namecheap. This domain was recently registered at Namecheap. Please check back later! The Sponsored Listings displayed above are served automatically by a third party. Neither Parkingcrew nor the domain owner maintain any relationship with the advertisers.
sqldumpster.com
SQL Database Resources & Data Base Dumps for MySQL, CSV, Access & Oracle
Food and Drink databases. Welcome Guest, please login. Welcome to SQL Dumpster. Hello We provide databases in ready to use formats including CSV and SQL database dumps. We provide databases for website designers. Software developers, direct marketing and market research. We supply website content. Marketing lead databases, directory data for location based services and other business listings. Range from postcode data. To football player databases. And everything in between! Car makes and models.
sqldusty.com
SQL with Dustin Ryan | Dustin Ryan is an MSBI consultant, trainer, speaker & author specializing in data warehousing, SSAS, SSIS, SSRS, Power BI and SharePoint
SQL with Dustin Ryan. Here’s the New #Excel 2016 Chart Types! Power BI Desktop Designer. PowerBI Tip: Use the Treemap, Column or Funnel Chart as a Colorful Slicer. Power BI Desktop Designer. Three Best Practices for #PowerBI. MDXMonday: Previous Year Month to Date Calculation. Power BI Desktop Designer. Power BI Desktop: My First Run Through. 3 SSAS Dimension Design Best Practices to Live By. Refreshing Excel Power Query and Pivot Tables with SSIS and Task Factory. August 14, 2015. Once you create your c...
sqldv.org
SQLDV - SQL with data Domains and Versions
SQLDV - SQL with data Domains and Versions. SQLDV is not a product (yet). SQLDV is rather a request for SQL features and a request for comments. I expect this to exist already. If not: this can't be patented anymore because now it's published. After over 20 years of application development I have come to a point where I miss 2 features in standard SQL implementations. The letters D and V stand for the missing features. Data domains on record level. Versions on record level. Versions on record level.
sqldvp.blogspot.com
SQLDVP
Friday, October 29, 2010. Meyyapan's sql fly demo. He is a gifted speaker. Very down to earth but very sharp. My taek away from the session is that:. 1 Make sure there are no sort warnings. If that is happening , the cache is spilling to tempdb. 2 best practices like one file on tempdb per core may be counter producitonve if your streaming is geared for only sequential I/O. If you have SAn infra-structure then it can handle up to 16 streams? Tuesday, December 22, 2009. Works for SQL Server 2005. FK NOT F...
SOCIAL ENGAGEMENT