Viewing 15 posts - 16 through 30 (of 34 total)
I actually found that you can find the SPID of the of a linked server call using master..sysprocesses on the local server under the waitresource field, INVENTORY is the alias...
March 28, 2013 at 7:44 am
You don't treat the concepts replication/mirroring any differently with a virtual environment. The most important aspect with virtualization is making sure you configure the physical host(s), hypervisor, and VMs to...
February 25, 2013 at 8:00 pm
Raid 6 is just like Raid 5 with the addition of another parity bit. From a disk perspective there is no penalty for reads but you do generate overhead when...
January 24, 2013 at 8:11 pm
S. Kusen, thank you for this helpful script!
January 24, 2013 at 10:00 am
AmarettoSlim (10/17/2012)After reading the posts on this thread I'm sensing you already kinda know the acceptable thresholds of data loss based on experience in the company.
I do. It's the...
October 17, 2012 at 2:36 pm
After reading the posts on this thread I'm sensing you already kinda know the acceptable thresholds of data loss based on experience in the company. That being said confirm them...
October 17, 2012 at 1:21 pm
Hmm, as for not being able to see remote instances or the local instance is the SQL Server Browser service running on this troubled machine? Firewall settings good? SQL Server...
October 5, 2012 at 9:31 pm
Based on the information provided its likely you have UAC enabled on this server. Running SSMS as administrator, aka elevated privileges allows you to connect locally using a member of...
September 28, 2012 at 11:02 pm
I'd start with asking your VMware Admin to check the memory usage statistics for the physical host of your VM. The reason I'd start here is because its very quick...
September 26, 2012 at 7:00 pm
What is the exact error SSMS is throwing? Do you see anything corresponding to these failed login attempts in Event Viewer?
September 26, 2012 at 6:52 pm
My personal favorite reference for SQL Server builds of all versions is at SQLSecurity.com
Check it out, left hand side has the versions:
March 27, 2012 at 3:15 pm
Great, thank you Gail. I will look it over today!
March 2, 2012 at 8:50 am
Sorry Henrico 🙁
February 21, 2012 at 6:50 am
It looks like there's an update to a row on the publisher that is failing as the appropriate row cannot be found on the subscriber...
Your options are:
a) Skip these kinds...
February 19, 2012 at 12:17 pm
In this case since it's all coming from the same array, same HBA, then you won't see a performance increase. However from a manageability standpoint it's nice to have these...
February 6, 2012 at 9:04 pm