This paper discusses how to use SQL Server 2008 to get great performance as your data warehouse scales up. We present lessons learned during extensive internal data warehouse testing on a 64-core HP Integrity Superdome during the development of the SQL Server 2008 release, and via production experience with large-scale SQL Server customers.
2008-11-14
2,699 reads
When the database is small, developers often use built-in SQL Server tools and scripts to create the data model. However when the data model grows into an enterprise level data model with all of the associated complexities, the management and maintenance grow as well. So what options are available to manage and build the data model?
2008-11-13
3,240 reads
This article shows how a database can be restored to achieve point in time recovery
2008-11-12
2,951 reads
Part 8 of our discussion on how to check SQL Server using Windows PowerShell examines how to get the SQL Server connection information.
2008-11-12
2,668 reads
With SQL Server 2008's new Data Collection feature and the Management Data Warehouse (MDW), came three system Data Collection sets. This article covers the different data collection standard reports that have been provided to display information related to the statistics collected by the system data collections.
2008-11-11
2,517 reads
Is there a way I can automate a file deletion process from within SQL Server?
2008-11-11
4,819 reads
The following article shows how Change Data Capture can be used to capture incremental data changes and use them in an ETL Process
2008-11-10
3,814 reads
Permissions on data are one of the most critical aspects of database administration.
2008-11-10
3,072 reads
There are a lot of scripts out there that will allow you to use the msdb to auto-generate restore scripts, but what if you cannot access the msdb database. What is the easiest way to make sure I have the proper restore scripts on hand without relying on the msdb database?
2008-11-07
3,562 reads
In this whitepaper, you will see the benefits of migrating your SQL Server 2000 Data Transformation Services (DTS) packages to Integration Services by using two proven methods. You will also see how you can run and manage your current DTS packages inside of the SQL Server 2005 and 2008 management tools.
2008-11-07
5,110 reads
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Comments posted to this topic are about the item Unraveling the Mysteries of the...
Comments posted to this topic are about the item QUOTENAME Behavior
Good Morning. I have a T-SQL Script which has been developed to execute a...
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers