Viewing 15 posts - 7,006 through 7,020 (of 49,571 total)
Different entries in the plan cache, very likely the same plan form, but two different plan objects in cache.
The queries would have to be an exact text match to have...
December 19, 2014 at 4:46 am
sej2008 (12/19/2014)
i am talking abt Sql 2012 High Availability group that requireswfc.
SQL Server failover clustering or Always On Availability Groups? Your posts are not clear as to which you're...
December 19, 2014 at 1:38 am
Brandie Tarvin (12/18/2014)
So, I'm curious. Anyone have any major projects that people want before the end of the year?
Yes. The complete reverse engineer and rewrite of a crop modelling system,...
December 18, 2014 at 5:31 am
Only checksum = you have no idea if your backup file is damaged
Only verify only = you have no idea if your backup file is damaged
Both - you have...
December 18, 2014 at 5:26 am
Are you appending to the file when taking backups?
December 18, 2014 at 5:24 am
Ignore scan count. It is not the number of times a table has been scanned.
As for the high logical reads:
Large table
No indexes
Non-optimal execution plan
Poorly written query
Poor table design
Pick any one,...
December 18, 2014 at 3:52 am
Blocking? Something on that server has rows for november locked?
December 18, 2014 at 3:30 am
Grant Fritchey (12/17/2014)
Check the error log. You can see when backups were fired off there.
Error log will also tell you the login name used.
December 18, 2014 at 3:29 am
Depends
Are you talking about Always On Windows Clustering or Always On Availability Groups?
December 18, 2014 at 3:13 am
Steps 4 and 8 both invalidate/remove the cached plan from cache forcing the optimiser to create a new execution plan
December 18, 2014 at 1:54 am
None of the rest require sysadmin, and to be honest you probably shouldn't be letting an app make random login changes. It has no business doing so (and that would...
December 18, 2014 at 1:51 am
As long as, when the service restarts, the system database files have the exact same path and name and SQL has full permissions on files and folders, you should be...
December 18, 2014 at 1:47 am
Via windows scheduler? Via an application?
December 18, 2014 at 1:42 am
The other thing to think about is that the database is the unit of restores. Will you ever be required to revert customer 42's data back to how it was...
December 18, 2014 at 1:41 am
Express12 (12/17/2014)
How can I restore the DB to multiple MDF's, NDF's across our 3 drives ( E: F: G: )
You can't.
A backup, no matter how many...
December 18, 2014 at 1:24 am
Viewing 15 posts - 7,006 through 7,020 (of 49,571 total)