List instances hosting similarly named databases
Lists instances, aliased linked servers, and databases pattern matched on the linked server and database names
2016-06-03 (first published: 2016-05-06)
323 reads
Instance
Log and report on table growth for trending
Log and report on table growth for trending, so you can track exactly which table(s) are your hotspots for growth.
2016-06-09 (first published: 2016-05-05)
1,417 reads
Part 2 -- Restore a database to another instance...
This script should be created in the source instance of the database to be backed up and then restored in conjunction with that on the destination in Step 1.
2016-03-15 (first published: 2016-02-25)
1,131 reads
Part 1 -- Restore a database to another instance...
A great script that I wrote some time ago to allow the last database backup to be restored across a linked server to another server, after running a remote sproc on the destination to kill off any users on the receiving side.
2016-03-14 (first published: 2016-02-25)
784 reads
SQL Server System Report
Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.
2019-04-15 (first published: 2010-05-11)
15,325 reads
RE: Calling SP from ASP versus Query Analyzer
i had the same Problem .The stored procedure builds a temp file and the displays the selection.We seperated the Procedure and till now have had no Problems.
2004-10-12
RE: How to save DB diagram, generated in SQL ,in word format?
Yeah, there's no way to do it directly. I've discovered that Visio Professional, has a nice database reverse engineering wizard. It seems to do a better job at database diagrams than the one included in Enterprise Manager.
2004-10-11
RE: Query across records
it sounds like you mean that it is a two part primary key dp + num. so then you could do exactly the same thing except with a self join select... FROM legal a JOIN legal b on a.dp = b.dp AND a.num = 1 and b.num = 2 WHERE rtrim(a.descr1) + ' ' + […]
2004-09-22
Startup Account and Connection Account
What is the difference between the SQL Agent Startup account (Agent...Properties...General tab) and the SQL Server Connection account (Agent...properties...Connection tab)I have always assumed that the Agent Startup Account is used when running scheduled DTS packages, replication etc. but don't know what the connection account is used for.Can anyone provide me with 2 scenarios one that […]
2004-09-08
2 reads
2004-09-07
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers