Full backups, the log chain and the COPY_ONLY option.
There have been a large number of posts made regarding the interaction between full database backups and the log chain...
2011-03-08
1,324 reads
There have been a large number of posts made regarding the interaction between full database backups and the log chain...
2011-03-08
1,324 reads
A while back I wrote up a short introductory overview of Genetic Algorithms. Just for the shear, absolute fun of...
2011-02-22
1,543 reads
This one comes up a lot on the forums, often as advice given…
“You should use integers for the key rather...
2011-02-15
3,125 reads
I was guest presenter on last week’s Quest Pain of the Week presentation. The presentation is available for download from...
2011-02-14
635 reads
I see a lot of advice that talks about the clustered index been the best index for use for range...
2011-02-01
1,322 reads
It’s looking like it’s going to be a busy year.
It’s only January and I already have three presentations lined up...
2011-01-28
534 reads
This is going to be a quick one…
I keep seeing forum code (and production code) that includes the DISTINCT in...
2011-01-18
5,555 reads
One last post on execution plans and Profiler (at least for now)
When trying to check a query’s execution plan, the...
2011-01-04
1,321 reads
I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...
2010-12-14
1,482 reads
I’ve looked at cache hit and miss events and at the cache insert and remove events. The only cache-monitoring event...
2010-11-18
2,074 reads
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
This is one I haven't seen before. I'm trying to drop a database user...
I have a PowerShell script that I use to automate the backup of Analysis...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers