SQL Server 2008 has hundreds of new features and improvements for Production DBAs, Developer DBAs, and Business Intelligence specialists…in this book I focus on what I thought were the ten most important new features for Production DBAs.
2013-04-11
14,365 reads
There can be more to managing a SQL Server instance than just examining the performance metrics. There are times when understanding how your system is performing for the application is important.
2013-04-11
1,446 reads
The concept of a sliding window scenario is to manage and keep the same number of partitions on a partitioned table over time. Learn how in this step-by-step from Arshad Ali.
2013-04-11
2,684 reads
Overview of 2 very important clauses added to SELECT statement in SQL2012 to allow paging on result sets.
2013-04-10
661 reads
2013-04-10
10,688 reads
We need to exclude SQL Server database files from Antivirus and Third Party Backup Software (to make sure that files are not accessed directly). How can we be sure that all of our SQL Server file extensions are using the standard file extensions for database files?
2013-04-10
2,438 reads
Microsoft Database Engine Tuning Advisor (DTA) is a database performance tuning utility designed to analyze your SQL Server database and suggest actions to be taken in order for taking your query performance to the next level.
2013-04-09
5,123 reads
Alex talks through a simple practical example of a database deployment, First creating a empty database and then upgrading it through three steps by writing T-SQL scripts, adjusting configuration files and the change log, before generating a full build script containing all schema objects.
2013-04-09
3,749 reads
Join us at SQL Saturday Costa Rica on April 13, 2013 for a day of SQL Server Training and Networking.
2013-04-08
1,469 reads
You, as a SQL Server data professional, are looking for ways to improve your queries. You've done the usual - avoided cursors and loops, used locks effectively, examined execution plans - what else can you tweak? Check out this tip to learn more.
2013-04-08
6,542 reads
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Alamat Kontak WA CS:087878229292 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo,...
Comments posted to this topic are about the item Why SQL Server Database Attach...
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers