Viewing 15 posts - 10,861 through 10,875 (of 49,552 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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 21, 2013 at 6:35 am
ignore...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 20, 2013 at 1:35 pm
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 20, 2013 at 1:03 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 20, 2013 at 12:53 pm
Roger Tranchez (11/20/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 20, 2013 at 6:20 am
Viewing 15 posts - 10,861 through 10,875 (of 49,552 total)