Fine Tuning your Database Design in SQL 2005
Sanchan Saxena gets to grips with the new index-tuning tools and features in SQL 2005
2006-10-17
3,510 reads
Additional Articles
Design Challenge: Global Address
Are you up to the latest design challenge? A great way to sharpen our analysis and modeling skills is to continuously address real-world scenarios. A modeling scenario with suggested solutions appears each month in this Design Challenge column. The scenario is emailed to more than 1,000 modelers. The responses are then consolidated into this column.
2006-10-16
2,039 reads
Executing all SSIS packages in a folder: three methods
This article examines a variety of ways in which you can execute all the SSIS packages in a folder.
2006-10-13
1,958 reads
Anticipate the worst when developing SQL Server databases
Arthur Fuller advises DBAs to try to break their software in order to make sure their SQL Server databases can withstand potential attacks. See if your code can hold up to his suggested tests.
2006-10-12
3,499 reads
Dealing with Database Concurrency Conflicts in the Real World
Database concurrency conflicts are somewhat of a plague in software development because they're hard to predict and handle. Unfortunately, they're also hard to prevent.
2006-10-11
2,638 reads
Executing predictions from the SQL Server relational engine
This tip shows you how to execute and use the results of prediction queries in multiple ways within the SQL Server relational database engine.
2006-10-10
2,466 reads
SQL Server 2005 Large Value Data Types
Microsoft has come to the rescue for managing large text fields in SQL Server 2005, by creating a few new large value data types. This article explores these new data types.
2006-10-09
2,297 reads
Beginning SQL Server 2005 Reporting
In Part 1 of this article, we looked at the basics of SQL Server Reporting Services 2005 (SSRS). We built one report with the Report Wizard, and one report using the Report Designer. In Part 2, we are going to look in more depth at the features that you can use everyday as an SSRS developer.
2006-10-06
3,902 reads
Configuring Design DB for Team Edition for Database Professionals
This video by Richard Waymire will describe how to install and configure SQL Server 2005 to support Visual Studio Team Edition for Database Professionals database projects.
2006-10-06
2,081 reads
Analysis: Where Rules Management and BPM Meet
Is your company trying to accelerate cycle times, lower costs, improve responsiveness, ensure compliance with policies and best practices, and increase customer satisfaction? Well, of course! That's why you need a comprehensive approach to managing your organization's business rules
2006-10-05
2,259 reads
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers