Viewing 15 posts - 1,951 through 1,965 (of 5,843 total)
Extended events or profiler is only way I know. You cannot use queries into the DMVs because I think they can have data removed due to memory management needs...
June 25, 2014 at 8:53 am
1) NEVER EVER leave max memory at the default. It is a somewhat religious discussion to pick a number for any given machine, but there are several reasonable guidelines...
June 25, 2014 at 8:27 am
1) You can diagram from SSMS. Right-click on the Database Diagrams folder in the Object Browser.
2) SSMS Tools Pack utility for SSMS has a tool to generate insert statements....
June 25, 2014 at 6:56 am
fantom (6/23/2014)
I run a dbcc checkdb every night as part of my backup plan on all databases. Would this alert me in all scenarios of corruption?
Well, the corruption(s) will...
June 23, 2014 at 3:02 pm
cheshirefox (6/23/2014)
I have two servers, one with 80 cores and another with 64 cores. Both are HP 980's. Different chip set and both connected to a flash appliance.
My question...
June 23, 2014 at 8:47 am
1) What are the FQDNs of both your primary and secondary servers?
2) can you set up a linked server for testing and connect between them that way?
June 23, 2014 at 7:49 am
ananda.murugesan (6/22/2014)
Can we configure Mirror setup with alwayson features on SQL 2012?
can it be done automatic failover over method, once principle DB server down?
How can be application automaticallay re-direct to...
June 23, 2014 at 7:47 am
Good recommendation Jeff! I always forget about synonyms. My client's stuff is typically so messed up we never get around to the little things like that that can...
June 21, 2014 at 6:45 am
Sean Lange (6/20/2014)
ngustafson-1056093 (6/20/2014)
June 20, 2014 at 2:50 pm
This should probably be done with sproc(s) as much as possible. Maybe in conjunction with some form of data movement into SQL Server that would allow set-based DML (insert/update/delete)...
June 20, 2014 at 11:22 am
Clone the tables, adjust as necessary and then swap in. Seems like a no-brainer best solution to your specific set of needs.
June 20, 2014 at 11:06 am
, we aren’t going to stop people from signing up to the site and the forums,
Then you are trying to solve this problem with one of the most effective...
June 19, 2014 at 10:05 am
The posts looks to be submitted manually (not scripted) so we don't believe something like captcha would make a difference.
1) I am curious how you can know that. ...
June 19, 2014 at 7:27 am
I am just wondering how you got hired by a company that is having performance problems with a SQL Server application, to help them fix said performance problems, when you...
June 18, 2014 at 6:27 pm
Clay Bowen (6/17/2014)
You fail to mention the price of Embarkadero is actually higher than Erwin. I would be looking for something more cost effective.
Please post a feature matrix and...
June 17, 2014 at 1:51 pm
Viewing 15 posts - 1,951 through 1,965 (of 5,843 total)