Alone Time
Working in a distributed team can be challenging, but working in an office can be just as difficult. Steve Jones talks a bit about time management today.
2008-12-09
588 reads
Articles
Alone Time
Working in a distributed team can be challenging, but working in an office can be just as difficult. Steve Jones talks a bit about time management today.
2008-12-09
607 reads
Scheduling Jobs in SQL Server Express - Part 2
In my previous article Scheduling Jobs in SQL Server Express we saw how to make simple job scheduling in SQL Server 2005 Express work. We limited the scheduling to one time or daily repeats. Sometimes this isn't enough. In this article we'll take a look at how to make a scheduling solution based on Service Broker worthy of the SQL Server Agent itself.
2008-12-09
2,872 reads
Script to build a SQL Server Data Dictionary and report with Microsoft Excel
There is value in using the extended properties across some of the industry leading data modeling tools. What if I do not have access to any of those tools? Is it possible to build the extended properties and then be able to generate reports by using Excel or Reporting Services?
2008-12-09
4,930 reads
Understanding the MERGE DML Statement in SQL Server 2008
This article about MERGE DML Statement in SQL SERVER 2008 and how to implements it and several examples
2008-12-08
4,159 reads
2008-12-08
518 reads
2008-12-08
488 reads
2008-12-08
736 reads
TechEd: 80 minute video of Corruption Survival Techniques presentation
A great presentation from Paul Randal of SQL Skills from TechEd 2008. Definitely worth the time to watch.
2008-12-08
5,046 reads
Using SQL Server DMVs to Identify Missing Indexes
I can run the Database Tuning Advisor or examine the query plans, but is there any easier way to determine which indexes may be needed?
2008-12-08
2,297 reads
Blogs
Advice I Like: Ranch Rules
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
Three Ways to Use Snowflake Data in Microsoft Fabric
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Forums
You Have Homework
Comments posted to this topic are about the item You Have Homework
SSIS 2019 or 2022 - Microsoft Connector for Oracle
Hello all, I am having one heck of a time installing Microsoft Connector for...
bringing a .bak across the wire without rdp'ing or mapping into the sql server
hi, a peer of mine would like to be self sufficient in bringing small...
Question of the Day
The Query Optimizer and Page Density
If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?
See possible answers