Looked at sys.database_encryption_keys and the entries are there for the snapshot databases and claim that it is all encrypted, so now I'm leaning towards glitch. Still weird behavior though.

I was able to reproduce it failing in VS on my dev workstation, but then was able to work around it. Originally I had a for each loop using the...

The query is an insert that is part of a stored procedure. They are using a TABLOCK hint on the table being written to as well.
(table and some column...

Looking through your commentary there, it looks like you said you have encountered the same warning/error I did.

One question, in the vNUMA Scalability example what was the underlying hardware? Was it a 4 socket host? The article seems to indicate that it is, but I'm not sure...

A couple of thoughts,

Shrinking your db is going to fragment all of your indexes, can you avoid it?

As for the rest of your process, have you tested it?

I would also...

Quinn-793124 (7/28/2016)

I am working on a justification to upgrade from SQL Server 2008 R2. One of the arguments was way faster. My boss countered with show me...

Hmm, I was thinking something like all data access through stored procedures, which would...

Hobbit

Random thought: you might be able to cobble something together via sp_getapplock, but I think you would have to carefully architect and test how users access the database. Also no...

Hmm, finally found this CSS SQL Blog[/url].

AFAIK JTDS doesn't support AlwaysOn/HADR in the sense that it won't handle failover as one would expect (it can still connect just fine). However, Microsoft's jdbc driver does and that...

Shark

Hello Perry,

Yes we are using a single account across all our nodes for the SQL service (thank you btw for your series, it has helped me immensely)....