Viewing 15 posts - 13,591 through 13,605 (of 49,552 total)
Most likely someone's switched the DB to simple recovery and back to full since the last full backup. As such, there's no current database backup to base the transaction log...
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
April 5, 2013 at 9:30 am
I would have some doubts about that BoL page, never seen a minimally logged operation trigger a checkpoint before and besides, it doesn't need to trigger a checkpoint. Any data...
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
April 5, 2013 at 9:24 am
As I said
GilaMonster (4/5/2013)
/PAE needs to be in the boot.ini, not /3GB, or IncreaseuserVA
You have 32 GB of memory in that machine. If you add the /3GB, you will limit...
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
April 5, 2013 at 3:28 am
How did you drop the statistic? How are you seeing that it's still there?
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
April 5, 2013 at 1:48 am
Please read through this - Managing Transaction Logs[/url]
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
April 5, 2013 at 1:47 am
/PAE needs to be in the boot.ini, not /3GB, or IncreaseuserVA
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
April 5, 2013 at 1:44 am
And if they have sysadmin permissions, you have larger problems than a DDL trigger, they could drop the database, shut down SQL, steal a backup, change data, etc.
Minimal permissions!
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
April 4, 2013 at 7:06 am
Short of profiling the instance, I don't think you can tell which session created which table. You can see the temp space that each session uses with the sys.dm_db_session_space_usage DMV.
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
April 4, 2013 at 5:52 am
There has never been a guarantee that a select without an order by will return the data in any particular order, whether it be insert order or anything else. It...
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
April 3, 2013 at 1:24 pm
Rob Phillips (4/3/2013)
The test box is a Windows 7 Home machine (insert chuckle here). I don't believe there's even the ability to set local security policy.
Administrative tools -> Local...
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
April 3, 2013 at 1:13 pm
Probably instant file initialisation.
How do you know it's not on? Checked the local security policy setting? If SQL's running as admin, could be that someone gave the administrators group...
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
April 3, 2013 at 12:40 pm
Query sys.dm_exec_cached_plans, cross apply to sys.dm_exec_sql_text and search for the text matching the ad-hoc 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
April 3, 2013 at 12:30 pm
You've given the same physical file name to all three of the data files. They need to all be different physical files, so each of the data files needs 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
April 3, 2013 at 11:01 am
Then just switch to simple recovery, switch back to full immediately, run a full backup and restart the log backups after that. Providing there's nothing else preventing log reuse, 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
April 3, 2013 at 10:42 am
That's not a standard job. As your client what it does or open in in maintenance plan editor and take a look. As for why it's failing, take a look...
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
April 3, 2013 at 10:12 am
Viewing 15 posts - 13,591 through 13,605 (of 49,552 total)