trace flags

Technical Article

RE: Indexed Views

  • Reply

I am confused about what can and can't be done with SQL Server Standard Edition. I have Standard Edition and want to turn some of my existing views into indexed views if it will increase the performance of selects against them.Is this possible?


Technical Article

RE: date math within 1 column

  • Reply

This query does as you as. Difference between two most recent. Dont you want the difference between the start and end of each query though? I inserted you data into a table called test. Create Table Test([field] varchar(45)) Insert Into Test(field) values('13 2004-07-13 13:15:26.140 end query 10 0') go Insert Into Test(field) values('12 2004-07-13 13:15:01.263 […]



Flyway Desktop Projects for My PoC


In a previous post, I set up the basic databases for the PoC project...

Daily Coping 30 Jan 2023


Today’s coping tip is to plan something fun and invite others to join you....

Migrating or Recovering a TDE Protected Database 


When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...

Read the latest Blogs


Database copies (cross environment) and sizing strategies for 2019

By MyDoggieJessie

I'm sure this has been asked many, many, many times and hoping several optimal...

TSQL to determine status of subscription reinitialization

By ratbak

How do I determine the initialization status of a subscription with T-SQL -- i.e,...


By sqlguru

Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers