Hicks


Technical Article

Recompile all Udf's associated with a Table

When altering the structure of tables it is good practice to run SP_RECOMPILE against the table to force triggers and stored procedures to recompile. However this does not incude Udf's which also rely on the table, and this means the Udf's may fail when they are called. Run this script and supply the table name […]

2002-09-05

342 reads

Blogs

VMware & SQL Server 823-824 alerts

By

We’ve been tracking a weird state with SQL Server virtual machines on VMware and...

Daily Coping 18 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Storage Field Day 23 – SIOS

By

I am thrilled to have been a part of this year’s Storage Field Day...

Read the latest Blogs

Forums

need some help in tweaking a query

By bobrooney.81

Hi All, I am looking for some tsql help. I am from Oracle background....

SQL Server 2017 AlwaysON Secondary Replica use case

By vsamantha35

Hi All, I need some advice on Always on secondary replica usage. We are...

DENSE_RANK different sequences

By vilaca

Hi all, I have this data: Code               ...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers