Moving the tempdb database
Moving the tempdb database in SQL Server is a simple process but does require the service to be restarted.
2007-12-06
3,660 reads
Additional Articles
2007-12-06
2,678 reads
SQL Server Reference Guide
Buck Woody's SQL Server Reference Guide is your "one-stop shop" into the world of Microsoft's SQL Server, providing you with the information you need to manage and program SQL Server.
2007-12-06
4,623 reads
File Management with Scripting Object
Once you get familiar with the File Scripting Object (FSO), managing files in Access is not so bad--getting started is the painful part. To help you along, this month's download includes sample code for both Access (early bound) and VB Script (late bound).
2007-12-05
4,203 reads
Storing XML Data in a Relational Database
Use familiar XML markup to extend the capabilities of your relational database.
2007-12-05
2,565 reads
The “sys.dm_os_performance_counters” Dynamic Management View
SQL Server performance can be tracked and monitored by using performance counters. For SQL Server 2005 performance counters can be displayed by using the “sys.os_exec_performance_counters” Dynamic Management View (DMV).
2007-12-05
2,495 reads
Advanced Matrix Reporting Techniques
In SQL Reporting Services, the native Matrix control provides a crosstab view of data, similar in behavior to a PivotTable in MS Excel. Rows and columns will have intersecting points of data which is often useful in time based reporting . David Leibowitz shows you how...
2007-12-04
2,768 reads
Implementing Common Reference Data in a Data Warehouse
This article provides an architecture and process framework for implementing common reference data in a data-warehousing environment.
2007-12-04
2,734 reads
SQL Server Indexes: The Basics
Indexes directly affect the performance of database applications. This article uses analogies to describe how indexes work. The estimated execution plan feature of the Query Window is utilized to compare the performance of two queries in a batch.
2007-12-04
5,686 reads
Business Analysis: A Guide to Better Business Requirements
This article presents ten business analysis guidelines, representing best practices from successful projects.
2007-12-03
3,044 reads
Blogs
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Why I stopped using MCP for AI coding stuff
By HeyMo0sh
Something has shifted quietly in 2026. The developers I know/respect—the ones actually shipping, not...
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers