TempDB Deleted Accidentally
TempDB is the ALU of the SQL Server and if somehow this gets deleted Server cannot start. Here is a solution of how to get the server started when TempDB is deleted.
A Developers' Guide to Refactoring Databases
When Agile meets 'Big Design', the result can be frustration on both sides. Is it possible for database development to to easily coexist with Agile methodologies for application development? Nick suggests that the technical solutions already exist, and the dissonance is more due to cultural and organizational problems
Cascading Human Error
The recent Amazon AWS outage was blamed on human error. Steve Jones notes that the more interconnected our systems are, the more likely that a human error might cause cascades between the systems.
SQL 2008 SP/CU Patching Through Windows Scheduled Tasks
Automate patch installations using the task scheduler and command line hotfix options for SQL.
SQL Server Foreign Key Update and Delete Rules
Foreign key constraints are an integral part of SQL Server database design. These are used to maintain integrity among related data in different tables. While implementing update and delete operations on values in the parent table (referenced table with primary key) we have to consider the impact on related values in the child table. SQL Server provides different rules for managing the effect of updates and deletes on child table values. How can these rules be used effectively without threatening the relational integrity?
100% Microsoft?
This week Brad McGehee asks if your company is a 100% Microsoft software shop or if you are allowed to use third party software with your SQL Server.
The Intelligence Cloud
More cloud talk today as the Air Force is building a new intelligence sharing system in the cloud? Why the cloud? Is the cloud really better?
TSQL Challenge 55 - Multiply two very long decimal strings and return
This challenge to multiply two positive integer strings and return their product. The strings can be really long: up to 1024 digits
Performing DBCC Checks Using SQL Virtual Restore
Ever restored a corrupted database from the backup, only to find that the backups are corrupted too - All the backups? Sure it can happen and it isn't nice when it does. To check that a database backup is internally consistent you have to use DBCC CheckDB. On a huge highly-loaded live system? Grant Fritchey has, as usual, a practical solution.
Temporary Indexes
Temporary indexes can speed up processes that run periodically in your applications. This Friday Steve Jones asks how many of you use temporary indexes and how you do so.
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers