DBCC CHECKDB
Torn Pages \ Corrupt pages – all in a days work for a DBA. But can anyone tell me how to use...
2011-11-14
29,168 reads
Merge Business Logic Handler Conflict Resolver
Introduction
This example demonstrates how to implement a business logic handler for a Merge article to perform custom resolution of conflicting...
2011-11-13
1,419 reads
Merge Business Logic Handler Custom Conflict Resolver
Introduction
This example demonstrates how to implement a business logic handler for a Merge article to perform custom resolution of conflicting...
2011-11-13
2,483 reads
An Informal Compendium of SSAS Errors, Part 5: Incorrect Calculation Results, Miscellaneous and MDX Studio Errors
This is the fourth in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-11-13
1,915 reads
OT: Amateur Astronomy
Back in 1997, when the Mars Pathfinder bounced down on Mars on July 4, releasing the little Sojourner rover to...
2011-11-12
1,167 reads
Parallel execution in SSIS
Parallel execution in SSIS improves performance on computers that have multiple physical or logical processors. To support parallel execution of...
2011-11-11
6,531 reads
SQL Server 2008R2 BI Presenations
I recently gave a couple of presentations about the new Business Intelligence features in SQL Server 2008 R2. Here are...
2011-11-11
1,527 reads
SQL University: Advanced Indexing – Indexing Strategies
Right, I know it’s Friday and everyone’s tired and looking forward to the weekend, but I do need to finish...
2011-11-11
1,596 reads
Cool Windows 8 Blog
For those of you interested in cool new technology, you should definitely check out ?Building Windows 8? which is a...
2011-11-11
904 reads
SQL Server 2012 Licensing and Hardware Considerations
Last week, Microsoft announced some pretty fundamental changes in how SQL Server 2012 will be licensed compared to previous versions...
2011-11-11
5,565 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers