Viewing 15 posts - 24,841 through 24,855 (of 49,552 total)
bopeavy (7/18/2011)
The site will tell you how long the evaluation copy last but i will bet it will not be over 90 days. Probably more like 30 days.
SQL evaluation editions...
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
July 18, 2011 at 12:02 pm
adas-768309 (7/18/2011)
I have been using SQL server 2005 Standard (32-bit).
I am planning to upgrade to 64 bit. But unfortunately I cant find a download link for SQl server 2005...
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
July 18, 2011 at 12:01 pm
Yes.
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
July 18, 2011 at 11:54 am
Jeff Moden (7/18/2011)
GilaMonster (7/18/2011)
Jeff Moden (7/17/2011)
Ummm... isn't MCM only two weeks long?
The MCM is 2 exams, no training component. The chance of passing without finding some suitable training...
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
July 18, 2011 at 11:42 am
subbkarth (7/18/2011)
no log backups: only full backups
Given that, and that the log reuse wait is 'Log Backup', what does it tell you?
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
July 18, 2011 at 7:28 am
a.e.ghorbani (7/18/2011)
isnt anyone to help me??
Have some patience will you. Bumping your post twice in 2 hours is completely unnecessary.
We're all volunteers here, we all have our own jobs, own...
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
July 18, 2011 at 7:26 am
How often are you running log backups?
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
July 18, 2011 at 7:21 am
steveblakemore (7/18/2011)
Can I just untick one of the boxes and everything will continue to work fine, presumably slower?
You can, but...
When I've unticked one of the boxes do I then only...
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
July 18, 2011 at 7:16 am
The log shipping job takes log backups, exactly as a normal log backup job would do.
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
July 18, 2011 at 4:02 am
Peawet (7/18/2011)
Does a readonly filegroup improve performance?
As opposed to what? A normal filegroup. Can do, just depends on how it's used and where it's put. Main point with a read-only...
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
July 18, 2011 at 3:57 am
Doesn't solve the performance problems. Snapshot is on the same server as the source DB, hence any queries against a snapshot are still taking resources on the live server. Won't...
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
July 18, 2011 at 3:53 am
Yes, because the log backups are taken by the log shipping. Make sure they run frequently enough for your data-loss allowance and log size.
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
July 18, 2011 at 3:40 am
Why are you asking? What's the reasoning here.
I already told you what objects are involved, the model database and the hidden system tables that sit below the sys.databases and related...
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
July 18, 2011 at 3:33 am
Jayanth_Kurup (7/18/2011)
If real time reporting is not requried you could consider shared database
Do note that with scalable shared databases, all of the databases involved have to be read only....
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
July 18, 2011 at 3:32 am
It's easy enough to write a query that uses the system tables to generate those create index statements for you.
Why do you want to move all 1000 tables to 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
July 18, 2011 at 3:25 am
Viewing 15 posts - 24,841 through 24,855 (of 49,552 total)