2011-06-14 (first published: 2007-12-05)
6,013 reads
Searching through SPs, Tables, Views
Find quickly all stored procedures, tables and views that are somehow related to the search term.
2011-02-09 (first published: 2011-01-28)
2,796 reads
Restore Database from network location
When using GUI tools, it seems the DB cannot be restored from a network path. This is actually possible via the script.
2010-05-11 (first published: 2009-07-11)
3,168 reads
2008-12-17 (first published: 2008-11-10)
2,717 reads
2008-05-27 (first published: 2008-04-10)
1,773 reads
Refreshing Views and Recompiling Stored Procs
When a table is modified by changing the order of fields or changing field type or adjusting field sizes etc, some of the dependent views (or views on views on views :)) may become invalid as they store some metadata in order to run more efficiently. These views would need to be refreshed with new […]
2007-04-20 (first published: 2007-03-20)
2,120 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers