471 reputation
17
bio website
location
age
visits member for 1 year, 6 months
seen 2 days ago

Jul
9
comment SQL Server: Worse performance on a new server
Are you sure about this statement: "If there are any missing indexes (I don't think there are) they affect the old and new servers equally." I would start with the assumption that some of the indexes did not transfer with the restore, and take steps to make sure all of the indexes present in the source DB are actually present in the target DB too.
Jun
28
comment Unusal internet traffic drop off
I disagree that historical data is needed to investigate. If historical data supported his theory, how would that help the investigation, except that you know you need to investigate?
Apr
8
comment What MS SQL Server administrator client should I use?
I guess when the OP commented: "The ssms version is the most recent. I downloaded it today.", he must have meant he downloaded the most recent version of SSMS 2005.
Mar
12
comment Windows Server 2008 R2: Weekly network failure
How long does the problem last if you don't do a reboot? Or does it never go away unless you reboot?
Mar
8
comment Trusted Connection to SQL fails after connecting to a VPN
Ok, in that case, the vpn domain is taking precedent for some reason. I don't know if there's a way when you're logged into both to specify the precedent domain. Since you said you setup trusts, can you give your user in the vpn domain permission to sql server the same way your normal user has? That way you wouldn't have to use the runas /netonly command when vpn'd in.
Mar
7
comment Trusted Connection to SQL fails after connecting to a VPN
I just had another thought. If you open SSMS and connect before you vpn in- I assume it doesn't stop working after you connect to the vpn?
Mar
7
comment Trusted Connection to SQL fails after connecting to a VPN
Are the VPN and local network on the same subnets? (From a command prompt, do ipconfig /all when vpn'd in and see what your two IPs are.) If the networks are overlapping this might cause it. If this is the case, you can just change your local subnet to a different IP range.
Mar
7
comment Trusted Connection to SQL fails after connecting to a VPN
Sorry I wasn't clear about how to use the /netonly switch. It must be used in conjunction with the runas command. I updated my answer with better instructions.
Mar
5
comment How exactly does one store SQL Server on an attached EBS volume? EC2
Where is that quote from? Perhaps with more context it will make better sense.
Mar
5
comment Trusted Connection to SQL fails after connecting to a VPN
I assume the app pool users can still connect when you're VPN'd in, it is only you with SQL Server that can't access the DB while VPN'd in? Does running SSMS with /netonly work?
Mar
5
comment to overwrite a table or update it?
The consensus seems to be choose TRUNCATE over DROP: stackoverflow.com/questions/9103037/…
Mar
5
comment to overwrite a table or update it?
I just want to point out that your third option is functionally different than the first two. Consider the case when the new table has less rows than the one you are overwriting. In the 3rd case the old rows would still be there.
Feb
19
comment Getting “error: 26 - Error Locating Server/Instance Specified” all of a sudden
In Sql Server Configuration Manager, you are absolutely sure SQL Server (SQLEXPRESS) is running on both machines? Perhaps stop it and restart it on the problematic machine to rule out any weird issues that may have happened on the last startup. What is the "Log On As" user listed in SQL Server Configuration Manager (usually it is NETWORKSERVICE), and in Management Studio, are you using SQL authentication or Windows Authentication? Could any passwords have recently changed?
Feb
13
comment win2008r2: Delete corrupted directory without reboot
The original problem hasn't recurred yet, however I just tried to move a directory on a Win7 machine, and couldn't because it was locked. I just used handle for the first time to tell me what process was the culprit. Worked wonderfully!
Feb
11
comment win2008r2: Delete corrupted directory without reboot
I used the term "corrupted" because I thought when there is an open handle it should give you "permission denied" or an "in use by process" type message and it shouldn't attempt the delete at all? The directory would still be browsable after that happens. In my case it thinks it succeeded with the delete. If there is an open handle, I would think that is a bug that Windows still tried and got as far as it did. Anyway, thanks for the link, when it happens again I will try using Handle and update this post.