Don't reuse the same temp table for different sets of columns. It makes debugging confusing, and it subverts the way SQL Server manages temp tables.

One of the small optimizations SQL...

Duplicate of https://www.sqlservercentral.com/forums/topic/replication-reinitialization-from-backup

You mention "app team" a few times. Does this mean only developers, or does app team also include product owners? The question of data retention is a business concern in...

https://dba.stackexchange.com/questions/134665/the-database-owner-account-has-been-deleted-what-impact

"I tried to create a stored procedure on a database that would execute as owner (blindly believing it to be 'sa'). The create failed because the owner didn't exist, so...

For some reason, you didn't ask -- perhaps deliberately -- about the simplest and probably the best option, which is just:

SELECT field1,field2
FROM table1

Because there is no where...

Duplicate created when original appeared to time out.

Deleted.

Are both servers running the same SQL Server version?

Are both databases using the same compatibility level?

Are both databases using the same transaction isolation level?

Are both databases/tables using the same collation?

Do...

• This reply was modified 1 year, 6 months ago by ratbak.

And if you truly don't care about the date entered when Type is not "Apple", you can simplify Emperor100's example to

ALTER TABLE [Testing]
ADD CONSTRAINT CHK_Dates CHECK 
(
...

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...