Viewing 15 posts - 6,811 through 6,825 (of 22,211 total)
You can use the Dynamic Management Views to get a look at the activity in the system. sys.dm_exec_requests will show you active sessions. You'll have the user_id and any existing...
February 3, 2015 at 12:17 pm
Since you're working in SQL SErver 2014, I strongly recommend you start using Dynamic Management Views to access information about the state of your systems. Using sp_who2 and DBCC commands...
February 3, 2015 at 5:52 am
Have there been changes to the queries being run? New functionality introduced? Additional tables or any other kind of change? A new annual process, something? Did someone accidentally run a...
February 3, 2015 at 5:43 am
I don't have quantifiable measures on this, but yes, I'm pretty sure that having an enforced structure will help to speed the queries. But, they still won't be "fast" because...
February 3, 2015 at 5:39 am
It's really up to the organization. I know a few places that still have SQL Server 2000 in place (I'm aware of two places that have SQL Server 7.0 running)....
February 3, 2015 at 5:37 am
That sounds like some sort of multi-hop problem within active directory. Weird.
February 3, 2015 at 5:14 am
That is the hard part. Let's say there's a reasonably defined set of possible searches, you could have a view do a UNION ALL query across each of the linked...
February 2, 2015 at 1:38 pm
That's tough to say. It really depends on the type of search we're talking about. Is it across a single data set that could be encapsulated in a partitioned view...
February 2, 2015 at 12:59 pm
If the agencies are going to be doing regular searches across the entire data set, I would consider putting it all into a single database (it does depend on the...
February 2, 2015 at 12:21 pm
Knock wood, I never had to restore a Sharepoint farm. But, what we were doing to protect it was point in time backups with the knowledge that we'd have to...
February 2, 2015 at 12:18 pm
Sioban Krzywicki (2/2/2015)
SQLRNNR (2/2/2015)
Ed Wagner (2/2/2015)
I only have Standard Edition, but I can't imagine running a production instance on SQL Express. Maybe I'm just spoiled.
I have to agree. ...
February 2, 2015 at 12:11 pm
Use the dynamic management views to gather better information. Sys.dm_exec_requests will show you the processes. That will let you more easily see what the query is of the blocking process:
SELECT...
February 2, 2015 at 7:41 am
Like Gail says. It sounds like something, unknown at this point, is wrong on your server. I'd get the consistency checks on all the databases, including the master, gets run...
February 2, 2015 at 5:02 am
jacksonandrew321 (2/2/2015)
Hi ExpertsWhich one is best, efficient and cost effective recovery plan among these log shipping, database mirroring, replication, fail-over clustering and backup and restore.
Thanks
Regardless of other choices, you should...
February 2, 2015 at 4:57 am
Weird duplicate post. Edited this to remove the repeated statements.
February 2, 2015 at 4:00 am
Viewing 15 posts - 6,811 through 6,825 (of 22,211 total)