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 […]

You rated this post out of 5. Change rating

2002-09-05

345 reads

Blogs

Introduction to SQL Server Query Store

By

Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...

Flyway with Multiple Folders

By

A customer asked about how they could organize their migration scripts in different ways...

Migrating from EverNote to Joplin

By

Recently I got a message that my Evernote subscription was going up. It’s been...

Read the latest Blogs

Forums

Database copy issue through - COPY DB WIZARD

By Kaushik Parui

I have a production server with SQL server 2016 version (13.0.5026.0) and a database...

Help with a SQL Unpivot

By rogue1009

I am trying to use unpivot to extract some data, however, the results are...

how to de escalte a isolation level, and are there any implications.

By rajemessage 14195

hi, I have one nested transaction and want to deescalate to outer  transaction's isolation/...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers