2011-06-14 (first published: 2007-12-05)
5,858 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,813 reads
2008-12-17 (first published: 2008-11-10)
2,662 reads
2008-05-27 (first published: 2008-04-10)
1,569 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,765 reads
Blogs
Rowcount estimates when there are no Statistics
When you don't have statistics, what does SQL use to calculate the estimated number...
Synapse Analytics and .NET for Apache Spark Example 4 - JOINS
By Ed Elliott
This is a bit of a longer one, a look at how to do...
Recovering Data from a Backup with SQL Data Compare
By Steve Jones
I had a customer recently ask about how to recover data from a backup...
Forums
Accessing a RESTORING database for test refresh
I have a requirement whereby testers on ServerA need a copy of the production...
How to get value portion key to every rn from 1 to 3 row on one row?
I need to get value portion key to every 3 row on one row...
Median Processing time, Average Procesisng time for created/closed date
We have sharepoint as the data source and we have 2 dates created...
Ask SSC