Managing Disk Space
How often do you worry about your database size and free space? Steve Jones asks how you administer your SQL Server database space this Friday.
2008-05-01
36 reads
Articles
Managing Disk Space
How often do you worry about your database size and free space? Steve Jones asks how you administer your SQL Server database space this Friday.
2008-05-01
31 reads
SQL Server 2008’s Management Data Warehouse
This article looks at the new Management Data Warehouse (MDW) that is incorporated into SQL Server 2008. This warehouse is performance analysis and capacity planning tool for DBAs. This article will discuss the basic architecture of the MDW and how to set it up using a wizard.
2008-05-01
2,161 reads
And You Thought You Had a Big Database
Steve Jones examines what big is these days and a few examples of what the largest database people in the world deal with.
2008-04-30
39 reads
And You Thought You Had a Big Database
Steve Jones examines what big is these days and a few examples of what the largest database people in the world deal with.
2008-04-30
35 reads
And You Thought You Had a Big Database
Steve Jones examines what big is these days and a few examples of what the largest database people in the world deal with.
2008-04-30
38 reads
Custom job categories to organize your SQL Agent jobs
Sometimes the tools that Microsoft provides us with do not give us complete control over the organization of our environment. Such is the case with organizing SQL Agent Jobs. We are able to organize and sort jobs by a variety of factors:
2008-04-30
2,633 reads
SQL Server 2005 Express Edition - Part 21 - Using Replication Management Objects
Recent installments of this series have demonstrated SQL Server 2005 Express Edition's replication characteristics by taking advantage of replication-specific executables and T-SQL code combined with Windows Synchronization Manager and Web Synchronization technologies. This article explores another method of reaching the same goal, which involves Replication Management Objects (RMO).
2008-04-30
2,233 reads
Usage of Functions in Stored Procedures
Building an application with modular programming not only speeds development, but can make for a more stable application. New author Sreeju Jumar brings us a look at how you can further modularize your stored procedures.
2008-04-29
11,937 reads
Advanced Matrix Reporting Techniques
Learn how to build robust Matrix-style reports in SQL Server Reporting Services. These advanced reporting techniques make it easier to build a fully-functional report.
2008-04-29
3,705 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers