2011-06-14 (first published: 2007-12-05)
5,860 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,708 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)
2,815 reads
2008-12-17 (first published: 2008-11-10)
2,664 reads
2008-05-27 (first published: 2008-04-10)
1,570 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)
1,771 reads
Blogs
The Diverse Data Platform–Dativerse.io
By Steve Jones
The other day I got a note from Ben Weissman the other day that...
Extended Events and Azure SQL Database
Knowledge of how your system behaves is vital to better control, maintain, and grow...
Daily Coping 19 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
upgrade path to SQL 2019
I read the upgrade path for standard edition to SQL server 2019, the oldest...
Help with detecting and sending alerts for lengthy blocking
Over the weekend we had 2 ETL jobs that were causing unresolved blocking with...
Ask SSC