2009-05-26
45 reads
Articles
Retaining historical index usage statistics for SQL Server
In this three-part series I'll look at what you can do to persist this data so you don't find yourself waiting for usage stats to compile over a reasonable period of time just so you can harness the power of the indexing DMOs in your performance tuning process.
2009-05-26
1,438 reads
Searching for tasks with code – Executables and Event Handlers
Searching packages or just enumerating through all tasks is not quite as straightforward as it may first appear, mainly because of the way you can nest tasks within other containers. You can see this illustrated in the sample package below where I have used several sequence containers and loops.
2009-05-26
1,144 reads
What is Twitter?
I saw an interesting blog post from Andy Leonard ( @AndyLeonard ) recently on what he thought Twitter was. I'd started my own post here, with some thoughts, and had to go back and rewrite things (Thanks, Andy!). He got me thinking, and I agree, it's...
2009-05-26
3,720 reads
2009-05-25
1,502 reads
Starting Conversations - Part 5
I just finished up my third coaching call with Don Gabor (Part 1, Part 2, Part 3, Part 4) and I think I'm gaining a little ground, but still finding that I have a lot to learn.
2009-05-25
813 reads
Understanding SSIS Data Flow Buffers (SQL Server Video)
This video looks at the memory buffers that transfer data to the data flow of an Integration Services package.
2009-05-25
1,040 reads
Using SQL Server to Build a Hub-and-Spoke Enterprise Data Warehouse Architecture
Scalable, cost-effective EDW implementation is an elusive goal for many large organizations. Three common approaches include centralized EDW the “monolithic” approach, decentralized collections of data marts, and attempts at hub-and-spoke architectures that combine the previous two. With the acquisition of DATAllegro and the pending release of Project codename “Madison,” Microsoft is poised to deliver a unique and compelling Massively Parallel Processing (MPP) data warehouse solution that combines the best features of both EDW and decentralized data marts.
2009-05-25
1,312 reads
Mathematical Auditing Of Email Broadcasts
In a sequel to his previous article on referential integrity, Glen Cooper looks at some ways to analyze who is getting emails based on a database system.
2009-05-22
4,242 reads
How to find out how long a SQL Server backup took
Many shops do full backups of their databases as part of a job within SQL Agent, typically as part of a maintenance plan. This job will often times do all database backups in secession. As such, while you may know how long the job takes, you may not know how long any one particular database takes to have a full backup taken.
2009-05-22
3,711 reads
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
Forums
DB Design Methods
I've read a few posts regarding what we use to design DB models and...
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers