Viewing 15 posts - 10,861 through 10,875 (of 49,566 total)
Why don't you download a trial, play with it for 14 days and decide for yourself if it's worth buying after that time?
November 21, 2013 at 6:36 am
Please post table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 21, 2013 at 6:35 am
ignore...
November 21, 2013 at 6:25 am
Yes, it makes a huge difference.
If you add it as as secondary filegroup, then it's a separate area of storage. Tables already in primary will continue to grow in primary,...
November 20, 2013 at 11:01 pm
To be honest, I wouldn't do a blanket index creation without a lot of analysis first. Could be many of those foreign keys don't need indexes on then, meaning this...
November 20, 2013 at 10:58 pm
That would only be possible if the transaction log backups did not truncate the log and only the full backup truncated the log after it ran. Not only would that...
November 20, 2013 at 1:35 pm
Roger Tranchez (11/20/2013)
I would prefer a way to do it that,
ALTER DATABASE <database name> SET RECOVERY SIMPLE
when the 'magic' series of commands are performed, the log file turns to...
November 20, 2013 at 12:53 pm
Roger Tranchez (11/20/2013)
November 20, 2013 at 12:50 pm
Missing objects is not a syntax error.
A script with missing objects will parse fine. The binding will fail, but that's allowed and will not terminate the query. The query...
November 20, 2013 at 11:04 am
Check all logs for errors, check for outdated drivers that have bug fixes, check that your caches are correctly configured as per your storage vendor documentation.
Basically, give it a...
November 20, 2013 at 8:28 am
Funny thing I saw here a few years ago. Someone was asking for urgent help because their mission critical SQL Server instance wouldn't start. They posted the error log and...
November 20, 2013 at 7:03 am
Yup, you've got problems in multiple tables.
You need to drop and recreate both of these indexes:
IX_InvMRF_AspireID on InvMRF
Aspire_IPAddress_NCI on Aspire
DO NOT rebuild them. Drop and recreate. A rebuild will either...
November 20, 2013 at 7:01 am
Where should you start? Generally either on the sysadmin side or the developer side. DBAs aren't usually hired with no experience at all, it's a big risk handing over the...
November 20, 2013 at 6:53 am
I wouldn't use any evaluation edition in production. They're for evaluating the product, they have time limits to them.
November 20, 2013 at 6:20 am
Viewing 15 posts - 10,861 through 10,875 (of 49,566 total)