Importing data files is always a challenge for a DBA, especially when the files might vary in format. Having one codebase is important and new author Mark Balasundram brings us the template for a high performance application to do just that.
2008-03-13 (first published: 2007-04-04)
17,539 reads
Vote for Service Pack 3!!! For SQL Server 2005. As of now, Microsoft has no plans to release Service Pack 3 for SQL Server 2005. I sent them our poll results, but we need more votes. Let them know this is important by voting on Connect. Vote Now!!!! Update: There's a post that they hear […]
2008-03-13 (first published: 2008-02-17)
37 reads
Discover how to use metadata for pooling information already resident in an application to create a flexible search interface that reduces complexity and increases users' productivity.
2008-03-13
2,613 reads
This article will show you how to use the sys.dm_exec_cached_plans DMV to monitor the performance of stored procedures
2008-03-13
3,804 reads
2008-03-13
30 reads
2008-03-13
30 reads
2008-03-13
37 reads
Is it better to use NOT IN() or <> in a T-SQL query? Ken Johnson had the question put to him and decided to investigate them both. Read about how these two functions perform.
2008-03-12 (first published: 2007-05-29)
22,306 reads
The next installment of Jacob Sebastian's great series on XML looks at how a .NET application might consume XML data returned from SQL Server.
2008-03-12
5,693 reads
The Data Generator Source is now available for SQL Server 2005 and SQL Server 2008. This component needs little explanation. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline.
2008-03-12
1,502 reads
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Comments posted to this topic are about the item Working Better Under Pressure
Comments posted to this topic are about the item Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers