InterWorks Blog: Sql
Seeing as we're the experts, we thought we'd share some of our intel. But beware, this level of inside information may cause extreme shock and awe. If you get lost, just fire up a flare - we'll come and get you.
In this video I describe the concept of Source Code Control and demonstrate how you can use source code control (in this case Redgate’s SQL Source Control) to manage changes in your SQL Server...[more]
A common question I've received from new Vertica users is, "How do I enter newlines into a string literal, or use other backslash sequences like '\t'?" This is especially common from users...[more]
Loading data into Teradata can be done quickly and fairly easily using the Teradata FastLoad utility, but the utility isn’t exactly friendly to new users. This article provides a quick introduction...[more]
Summary/Purpose The purpose of this article is to explain a few instances of how an “Object Server Not Found Error” may occur and to show how to modify your Veeam database to fix your jobs in the...[more]
Let me tell you a secret about working with SQL Server. Anyone can do it. I’m not going to imply that it’s easy. You can’t do it in 24 hours and it’s certainly not for dummies … but...[more]
I ran across this multiple times over the last two years or so. This issue started with the introduction of the AMD tri-core processors, and continued when Intel released the hexa-core processors....[more]
SQL Server: The index "[IndexName]" on table "[TableName]" cannot be reorganized because page level locking is disabled.
If you've managed production database servers for any amount of time, you may have run into this error message in your maintenance plan logs. "The index "[IndexName]" on table "[TableName]" cannot be...[more]
In SQL Server 2005 and 2008 it's possible to start an agent job with T-SQL syntax. This is frequently useful. For example, you may have a job that you'd like to have an outside application invoke....[more]
With the advent of C# 3.0, Microsoft introduced the Language Integrated Query (LINQ) feature to provide .NET developers the ability to query and transform data using any .NET language. This...[more]
SQL Server User Defined Function Synchronization: The "yo dawg" method. A client we've worked with for some time had an interesting SQL problem for me recently. These guys usually have interesting...[more]
code, function, meme, sql, sql server, stored procedure, synchronization, synchronize, t-sql, triggers, yo dawg