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

349 reads

Blogs

Resetting Git and Abandoning Changes–#SQLNewBlogger

By

I recently had an issue in one of my Git repos, and decided to...

Exploring Windows Function Execution Plans

By

There are quite a few different ways that you’re likely to see windows functions...

What to Know about Power BI Theme Colors

By

Power BI reports have a theme that specifies the default colors, fonts, and visual...

Read the latest Blogs

Forums

sp_server_diagnostics in ErrorLog

By Casper101

I have the following in the SQL Errorlog, that was never there before: sp_server_diagnostics...

Login failed for user sa sql server 2022 - windows server 2022

By aman

i got the login failed error for user sa, but not always so I...

Login failed for user sa sql server 2022 - windows server 2022

By aman

i got the login failed error for user sa, but not always so I...

Visit the forum

Question of the Day

Disable Memory Grant Feedback Persistence

In SQL Server 2022, how can I disable memory grant feedback persistence?

See possible answers