2011-08-31 (first published: 2011-08-24)
2,504 reads
T-SQL
2011-08-24
2,770 reads
2011-08-17
3,033 reads
Simple Script to Backup All SQL Server Databases
Sometimes things that seem complicated are much easier then you think and this is the power of using T-SQL to take care of repetitive tasks. One of these tasks may be the need to backup all databases on your server.
2011-08-12
5,986 reads
Simplify Large Queries with Temporary Tables, Table Variables and CTEs
This article demonstrates how to manage the development of complex queries by building them in stages with temporary tables, table variables and common table expressions.
2011-08-09
10,317 reads
Hidden RBAR: Counting with Recursive CTE's
"Counting" is essential to many high performance code techniques. SQL Server MVP, Jeff Moden, shows us how to make sure that we're "Counting" and not "Crippling" our trick-code.
2011-08-08
22,491 reads
2011-08-04
2,684 reads
2011-08-03
2,980 reads
2011-07-25
2,735 reads
2011-07-20
2,878 reads
Blogs
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Forums
SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Do You Really Need HA?
Comments posted to this topic are about the item Do You Really Need HA?
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers