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.
Click to get started.19
Apr 2012
0 comments |
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]
20
Feb 2012
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]
14
Jul 2011
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]
10
May 2010
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]
15
Jan 2010
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]
13
Jan 2010
Brian Gammill
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]
30
Sep 2009
code, function, meme, sql, sql server, stored procedure, synchronization, synchronize, t-sql, triggers, yo dawg
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]
