2011-06-14 (first published: 2007-12-05)
5,970 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,740 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,134 reads
2008-12-17 (first published: 2008-11-10)
2,683 reads
2008-05-27 (first published: 2008-04-10)
1,743 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,080 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Everything is the right question away
Comments posted to this topic are about the item Everything is the right question...
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers