sqlsafety.blogspot.com
SQL Safety
Wednesday, April 17, 2013. SSIS - Replace Dynamic SQL With Variables. Review Erland Sommarskog article that will answer any question you may have on this topic here. 160; Without diving into what can become a heated debate over the use of dynamic SQL I will just outline several reasons for replacing dynamic SQL with an SSIS variable. 1 First and foremost IT IS MUCH EASIER to troubleshoot and debug statements passed as variables than those using dynamic SQL. 160; Let's first focus on ...The above sa...
sqlsafety.com
SQL Safety | SQL Server End to End
SQL Server End to End. SQLSatDC 10 Reasons to Attend. November 5, 2014. It is just over one month until SQL Saturday #347 in Washington DC and if you haven’t made plans to attend then let me motivate you to git er done. Get Near Realtime ETL with Service Broker. Do you need your data warehouse to maintain near real time data? Learn how to use service broker to accomplish this! SQL Watchdog – find out instantly when SQL changes occur in production. Those AWESOME “. Object doesn’t exist. Stop thinking outs...
sqlsageadvice.com
SQL Sage Advice | Your Hub to SQL Resources
Other SQL Professional Resource Links. Other SQL Resource Links. Your Hub to SQL Resources. Other SQL Professional Resource Links. Other SQL Resource Links. High Performance Un-pivot Transformation Using a Pivot Table. Pivot Data in Dot Net Using Linq. Solve Your Database Change Management Woes With DBMaestro. Create a Rolling Window Function Using a Tally Table. On Use a Sequential Tally Table t…. Follow Blog via Email. Join 3 other followers. High Performance Un-pivot Transformation Using a Pivot Table.
sqlsailor.com
SQLSailor | Personal Notes on Microsoft SQL Server,Microsoft Azure and Database Trends !
Personal Notes on Microsoft SQL Server,Microsoft Azure and Database Trends! Why I won’t be running SQL Server Standard Edition on Business Critical Servers! July 9, 2015. I keep getting questions around what core features are missing in Standard Edition of SQL Server,and why there is a need to install Enterprise edition for business critical systems.Here are my top features which are missing in standard edition –. Memory Standard only supports 128 GB memory. Online page and file restore. Database size is...
sqlsalt.com
Sqlsalt.com
This domain has recently been listed in the marketplace. Please click here to inquire.
sqlsample.blogspot.com
Sql samples, sql tips
Sql samples, sql tips. Sql server 2000 2005 2008 2008R2, 2012 samples, tips, books, sharing. Sunday, November 10, 2013. Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383] [SQL server issues]. Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]. Wrote Feb 23, 2012 at 10:47 AM. Is this been taken care? Wrote Feb 26, 2012 at 5:21 AM. The attached script will fix the problem. Use the stored procedure to extend to future dates if needed. Labels: Created...
sqlsamplegeo.codeplex.com
Sample Geo Data for SQL 2008 - Home
Project Hosting for Open Source Software. Sample Geo Data for SQL 2008. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Change History (all pages). SQL Server 2008 R2 database backup with tables, containing sample geographic data, such as shapes/boundaries of Countries of the World, Territories and Provinces. The data was obtained from http:/ www.naturalearthdata.com/. 1:10,000,000 shapes and comes under their respective terms of use.
sqlsamson.wordpress.com
SQL SAMSON | everything sql
SSMS Copy Column Headers. Leave a comment ». Needing some sort of variation or at least a break from my certification studies I decided to revisit a title I purchased a while back: “ Beginning SQL Server 2008 for Developers. 8221; from @Apress written by Robin Dewson. Well not any more because page 42-43 of this awesome book had life changing screenshots of the Options dialog. Big deal right? Well a big deal for me at least! What you need to do is:. Step 1 – Go to Tools – Options. Just a side note, if yo...
sqlsanctum.wordpress.com
SQL Sanctum | A Join on SQL And Everything Else
A Join on SQL And Everything Else. Skip to primary content. Skip to secondary content. Automatic Tempdb Configuration Script. August 14, 2015. The default configuration for TempDb leaves a lot to be desired, and although good changes are on the way in 2016. It will be quite some time before any of us get to use that in production. If you hate reading. This script is meant to run against a new server that has the default settings in place for Tempdb, with a single data and log file. The script will re...
sqlsandwiches.com
SqlSandwiches
T-SQL Tuesday – SQL Family and community. August 12, 2014. This month’s T-SQL Tuesday is being hosted by Jeffrey Verheul ( B. Our topic of the month is SQL Family. Check out the host page here. Here is our task:. 8221; How do you feel about SQL Family? Did they help you, or did you help someone in the SQL Family? When I first started learning about databases, I lived on sites like SQL Server Central. Did you sign up yet? T-SQL Tuesday – Assumptions. July 8, 2014. I work for a vendor and our application(s...