A Virtual Database World
Steve Jones talks about virtualization with databases, but not in the way you might think.
A Virtual Database World
Steve Jones talks about virtualization with databases, but not in the way you might think.
Filtered Indexes in SQL Server 2008
This article demonstrates the performance improvements that can be achieved using Filtered Indexes in SQL server 2008
Tips for tuning SQL Server 2005 to improve reporting performance
We are required to report from our SQL Server 2005 database. There are five or six tables regularly used for holding the reporting data, but these tables have five-to-seven million rows of data in them already. We need to use these tables consistently and our performance involving reporting is struggling. Do you have any tips to help improve it?
Data Ownership
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
Multi Select Parameters in SSRS - SQL School Video
Diving deeper into Reporting Services with this SQL School video, MVP Brian Knight shows how to create a report with a multi-select parameter, allowing the user to select multiple items for inclusion in the report.
36 Changes
Agile, or maybe even hyper-agile. Steve Jones talks about some challenges in the web 2.0 world.
36 Changes
Agile, or maybe even hyper-agile. Steve Jones talks about some challenges in the web 2.0 world.
36 Changes
Agile, or maybe even hyper-agile. Steve Jones talks about some challenges in the web 2.0 world.
SQL Server 2005 Express Edition - Part 32 - Distributed Service Broker Environment - Conducting Dialogs
This installment of our series focuses on establishing, conducting, and terminating a sample Service Broker dialog in a distributed environment, leveraging previously established routes and dialog-level permission.
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers