Does your table already have a clustered index on the column you will use for partitioning? If not, it will need to. That presents the likelihood of downtime & locking...

The closest I could find are this article from 2009 and this article from 2009

You could use sums of case statements to get the count:

WITH subquery as 
(
SELECT 
'A' AS SYMBOL, CAST(GETDATE() AS DATE) AS TRADE_DATE,
0 AS AB30_C, 1 AS AB30_P, 1 AS...

SSMSBoost appears to be back from the dead.

https://www.ssmsboost.com/Changelog

I haven't begun to use all of SQL Prompt's features. But it's code completion is much better than SSMS built-in intellisense. I have found Smart Rename & Find Invalid Objects...

Duplicate of https://www.sqlservercentral.com/forums/topic/row-changes-per-hour-by-tagid

How many rows are you keeping?

It may be faster & easier to insert retained rows into a new table, rename or drop the old table, and rename the new table...

Don't. Use SQL Server Reporting Services or some other external service.

Best practice: Don't truncate your transaction log, except in unanticipated emergencies where you have run out of storage, and the cost of waiting to add storage exceeds to cost of...

Has anyone applied any SQL Server CUs to that server in February?

What does SELECT @@VERSION return?

I'd rather strongly recommend a separate note table for each entity.

If you need/want a single querying point, create a view that unions those individual tables. You can use an EntityType/EntityTypeID...

• This reply was modified 2 years, 4 months ago by ratbak.

DDL Triggers have a "RENAME" EventType.

If you want to catch it after the fact using some kind of comparison, then you're probably looking for columns that have the same data...

In the signature of Jeff's reply:

How to post code problems

Duplicate due to slow response/double click

Typo