SQL Server – Script to Configure TempDB Files per Number of Logical Processors
In order to reduce Tempdb contention one of the best practices is to maintain multiple sized Tempdb data files, matching the...
2014-06-24
1,225 reads
In order to reduce Tempdb contention one of the best practices is to maintain multiple sized Tempdb data files, matching the...
2014-06-24
1,225 reads
Often times it is required to find out the SQL name from the host names in a clustered environment so you...
2014-04-14
1,158 reads
Here is the session I gave for the techies at Microsoft about in-built tools available in SQL Server to analyze...
2014-02-11
951 reads
Though there are several ways for importing SSIS packages into SQL Server either by creating a stored procedure or using...
2013-11-04
754 reads
Before we get started on this topic, here is a quick fact..in SQL Server 2000, there used to be hard...
2013-10-14
1,124 reads
In this article I will show you how to restore a database that is encrypted with Transparent Data Encryption (TDE)...
2013-10-03
973 reads
Being part of the database engineering team, we were given a task to setup disaster recovery program for some of...
2013-10-03
747 reads
The command prompt utility dtutil can be very handy when we want to quickly export an SSIS package from either file system...
2013-10-02
1,469 reads
Sometimes you might want to add more than one column as primary key. For example, if you have three columns...
2013-09-17
589 reads
Registered servers is a great way to manage, categorize and access the SQL servers through SSMS and also one of...
2013-09-16
480 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