Technical Article

usp_get_all_stats_date

This script gathers stats_date and index information for all of the current database. Please feel free to modify it as it is made up of components that are available on this site here- http://www.sqlservercentral.com/scripts/contributions/97.aspand a BOL entry for stats_date.I needed this information and thought I would share it.

2006-07-17 (first published: )

547 reads

Blogs

Daily Coping 31 Jan 2023

By

Today’s coping tip is to take a small step towards and important goal. One...

Tales From The Field Weekly Wrap Up for the Week of 01-23-2022

By

 Hello Dear Reader!  It's been a while since I had time to sit down...

CONCAT_WS Function Truncates Text

By

I was writing some dynamic SQL that generates some SQL statements to load my...

Read the latest Blogs

Forums

parameterizing a sql server connection

By winston Smith

I am parameterizing an sql server connection. There are the following fields: username password...

'DATE' is not a recognized built-in function name

By yrstruly

Please assist. I am getting the above error: CREATE VIEW DailyAccountBalances AS SELECT DATE(TransactionDate)...

SSIS Sort Alphanumeric?

By John524

Hello, I'm pretty new to SSIS, but I have an Excel source that I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers