2023-02-03 (first published: 2023-02-02)
8 reads
async
SQL CLR Multi-Threaded File Copy
A CLR Procedure that performs multi-threaded fie copies without external command line tools.
2013-11-19
2,931 reads
SQL Server's Auto Update Statistics Async Option
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?
2013-03-26
4,282 reads
RE: Ignoring INSERT errors in job steps
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 […]
2004-05-06
RE: SQL Server 2000 and Virtual Servers
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!
2004-03-04
RE: Summarizing duplicate data
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 […]
2004-01-28
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers