SQL Server 2008 R2 backup/restore - simple Tip
Simple, but I think somebody will ask:
Can restore the SQL Server 2008 R2 database to SQL Server 2008 ?
Simple answer,...
2010-05-12
10,245 reads
Blog Posts
SSRS - Time Saver using Templates
Creating a Reporting Services Template
Many companies like to have a consistent look and feel across their applications. Some even make...
2010-05-12
581 reads
Using the Report Items Collection in Reporting Services
Using the Report Items Collection in Reporting Services
Sometimes, you may want to do calculations or use some value that has...
2010-05-12
490 reads
Daily SQL Server 2008 New Feature – Day 4
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-05-11
406 reads
Exceptional DBA
It is once again that time of year. It is time to nominate the DBA in your life for the...
2010-05-11
938 reads
Five Things SQL Server Should Drop
Joining in the current meme started by Paul Randal (blog | twitter), here is my list of five features or settings...
2010-05-11
12,532 reads
How Do I Move SQL Database Files Around?
Here is a script that will generate a script to move database files around in SQL 2005/2008. Continue reading ?
2010-05-11
21 reads
How Do I Move SQL Database Files Around?
Introduction
Today’s script is one that I had not planned on blogging so soon but since Paul Randal just talked about...
2010-05-11
602 reads
How Do I Move SQL Database Files Around?
Here is a script that will generate a script to move database files around in SQL 2005/2008. Continue reading ?
The post How Do I Move SQL Database Files Around?...
2010-05-11
4 reads
Is Pivot Worth it?
I’ve been trying to learn more about the T-SQL changes in SQL Server 2005/2008 over time. I don’t have requirements...
2010-05-11
667 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...