2008-07-11
424 reads
Scripts
Monitor Any Linked Server From SQL 2000
Best way to monitor Excel, Access, SQL Linked Servers from SQL 2000
2008-07-11 (first published: 2008-06-03)
1,589 reads
usp_createsnapshot
Stored procedure which creates snapshot of database. Timestamp in snapshot. Multiple datafiles are supported
2008-07-04 (first published: 2008-05-28)
823 reads
usp_ActiveProcesses - SQL 2k5
Returns list of active processes and their buffer contents over a specified time.
2008-07-02 (first published: 2008-05-20)
1,465 reads
sp_utilityFindObjectModifying
SHOW WHICH TABLES ARE MODIFIED BY A STORED OR FUNCTION OR WHICH STORED OR FUNCTION MODIFIES A TABLE
2008-06-27 (first published: 2008-05-21)
802 reads
2008-06-26 (first published: 2008-05-20)
901 reads
2008-06-25 (first published: 2008-05-20)
1,241 reads
2008-06-25
307 reads
Check DTS Package Logs for Errors
This will let you know which package had errors rather than sifting through all the package logs one by one.You just need to replace the date.
2008-06-23 (first published: 2008-05-20)
705 reads
2008-06-20 (first published: 2008-05-11)
1,459 reads
Blogs
Book Review – Microsoft Power BI Performance Best Practices
I was asked to do a review of the book Microsoft Power BI Performance...
SQL Server Distributed Availability Groups and Kubernetes
A while back I wrote about how to use a Cross Platform (or Clusterless)...
Introducing SQL Server 2025 - Enterprise Ready AI
Introducing SQL Server 2025 - Enterprise Ready AI SQL Server 2025 is an upcoming...
Forums
normal role member to be able to view list of other role members in his DB
is this even possible ?
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers