Stored procedures can be an effective way to handle conflicting needs, but it's not always so obvious how to write them so they both perform well and scale.
2008-01-30 (first published: 2007-02-05)
10,708 reads
Paul Randal of SQLskills takes a look at lock escalation in SQL Server 2008
2008-01-30
1,436 reads
In this video, Randy Dyess shows you how important SQL Server dependencies are and some of the faults with SQL Server 2005 with these. For example, SQL Server will allow you to create a stored procedure that points to a table that doesn't exist. He also shows you how this problem has been corrected in SQL Server 2008.
2008-01-30
6,718 reads
A simple UPSERT can reduce reads on tables. This in turn will increase the performance of a DB.
2008-01-29
12,342 reads
How can IT get along better with the rest of the business? Often a SQL Server DBA isn't in charge, but you can influence others and make everything work smoother with a little effort. Andy Warren gives you some tips and tricks that have worked well in the past.
2008-01-29
3,494 reads
Building a data warehouse usually isn't a small project, but somehow management sometimes sees it as something that can quickly eb done with a tool or two. Longtime DBA Janet Wong brings us a look at some of the problems you might face when getting ready to embark on this
type of project.
2008-01-29 (first published: 2007-03-05)
7,541 reads
This article, part 4 in a series, discusses how to use, publish, maintain and govern the enterprise architecture.
2008-01-29
3,259 reads
If we will get a new version of SQL Server every 3 years, how can we make the process smoother.
2008-01-29
47 reads
If we will get a new version of SQL Server every 3 years, how can we make the process smoother.
2008-01-29
55 reads
If we will get a new version of SQL Server every 3 years, how can we make the process smoother.
2008-01-29
57 reads
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item This Week's AI Trust Problem...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers