Technical Article

How to use the new function fn_get_sql() ?

This article shows you how to use the new function fn_get_sql() and the 3 new columns of master.dbo.sysprocesses. These changes were introduced in SQL Server 2000 SP3/SP3A. In this article, you will find a general purpose stored procedure called ShowCodeLine. It makes use of these new features, to inspect a given spid, and display the currently executing line/query

SQLServerCentral Article

Cycling Those Error Logs

Have you ever tried to open the current error log in Enterprise Manager only to have it seize up and hang? Has that annoyed you? It certainly annoyed Steve Jones and he decided to do something about it. A little techinque for helping to manage the size of those logs and prevent the "not responding" message from appearing in Task Manager.

Blogs

SQL Training: Black Friday Deals Up to 75% Off

By

This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...

When is the perfect moment to build a data strategy in a company?

By

The post When is the perfect moment to build a data strategy in a...

How to Run Databases on Kubernetes: An 8-Step Guide

By

In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...

Read the latest Blogs

Forums

Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence

By Site Owners

Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...

Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...

Rebuild Index Job on a Large DB

By cooldude001

We have a db close to 3 tb and rebuilding/ reorganizing indexes weekly is...

Visit the forum

Question of the Day

Renaming a Database

If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)  

See possible answers