External Article

SQL Server's Auto Update Statistics Async Option

  • Article

I have been trying to tune my SQL Server and I noticed a few database settings for statistics. I also read the previous tip on automatic statistics updates. Could you please describe the Auto Create Statistics Async option? How is this configured and when should I use it and when should I avoid using it?


4,282 reads

Technical Article

RE: Ignoring INSERT errors in job steps

  • Reply

See the post on this site: Jobs - embed TSQL or Call Stored Procedure?? Posted 3/15/2004 7:12:00 AM Looks like someone with the same problem but I don't think they attained a complete solution. Rather than persevering with a workaroubnd for the problem, I think you will be better off filtering out the error before […]


Technical Article

RE: SQL Server 2000 and Virtual Servers

  • Reply

The registy on both Servers (both nodes in the cluster) have no reference to the new Virtual Server name - which is why I can't understand why SQL Server setup won't run saying the name already exists!!! I'll have to keep poking around. Thank you!


Technical Article

RE: Summarizing duplicate data

  • Reply

Yes. Brian to the rescue.Its actually quite simple.  I guess I was overcomplicating it in my mind (easy for me to do)Basically the query above can be rewritten as the following...INSERT  TABLENAME1 SELECT         Field1     = A.Field1,         Field2     = A.Field2,          Field3     = A.Field3,            Field4     = A.Field4,         Field5     = SUM(A.Field5),         Field6     […]



InvalidAbfsRestOperationException in Azure Synapse notebook


Problem The first issue that developers in my team noticed was when they tried...

What do we want to achieve by encrypting our data?


On the face of it, this is a very obvious question with a very...

Daily Coping 5 Dec 2022


Today’s coping tip is to look for new reasons to be hopeful, even in...

Read the latest Blogs


log shipping restore from primary server backup directory

By sqlfriend

To understand the concept of transaction log shipping, in below case, will it work:...

Optimization for Single Table with Thousands of Concurrent Updates

By keith.west-982594

I have a table with 5 million records and each record requires a "Value"...

Pivot not working, pivot without aggregate functions.

By sbhagyalakshmi95

Hi Team,   Can you please help me to get data pivot data. my...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers