sp_whoindb
Modified the sp_who2 proc provided by Microsoft. This proc takes a dbname or dbid for input, and lists current processes in that database. If no database is provided, the current database is used.
2003-03-28
188 reads
Load Backup History from Backup File
This script creates a stored proc to verify all backups in a media set and load their history into MSDB. I use this frequently when I get backup files from clients and want to use Enterprise Manager's intelligent restore selection to quickly get the database restored on a test machine.
2003-03-11
300 reads
Blogs
What do client diagnostics in Cosmos DB mean?
This topic keeps coming up with my customers so the purpose of this blog...
Adding Row Numbers to a Query: #SQLNewBlogger
By Steve Jones
I realized that I hadn’t done much blogging on Window functions in T-SQL, and...
Adding Row Numbers to a Query: #SQLNewBlogger
By Steve Jones
I realized that I hadn’t done much blogging on Window functions in T-SQL, and...
Forums
service is not available
I was trying to access SSRS report in host server browser , throwing an...
FIFO and manufacturing ... how do I get the current cost?
Sorry, more bakery stuff. Say I buy ingredients over time and I want to...
Linked server and trouble between manager and agent
Hello, I have a problem and i don´t understand it. After to link a...
Question of the Day
Starting to Estimate Disk Storage for Memory-Optimized Tables
If I have durable memory-optimized tables, what is the starting point for estimating storage space?
See possible answers