Viewing 15 posts - 34,486 through 34,500 (of 49,552 total)
The error's pretty clear
robblot (1/22/2010)
Unable to open the physical file "C:\Visual Studio 2008\Projects\LabReports Database\LabReports_log.ldf". Operating system error 5: "5(Access is denied.)".
SQL does not have permission to access the log file....
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
January 23, 2010 at 1:04 am
TheSQLGuru (1/22/2010)
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
January 23, 2010 at 12:55 am
I know, but crossposting is frowned on here and on just about every other forum there is. Best bet it to find one forum that best reflects your need 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
January 23, 2010 at 12:54 am
Is there a second SQL instance or is that the only one?
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
January 22, 2010 at 1:12 pm
The maximum size of a SQL database is 524 272 TB. Somehow I don't think, with 300 rows, you need to worry about hitting that limit any time soon.
For what...
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
January 22, 2010 at 1:11 pm
Some clarification needed here.
A database that's on a SQL 2005 server in compatibility mode 80 is still a SQL 2005 database. It's only that it's behaving like it was still...
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
January 22, 2010 at 12:48 pm
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
January 22, 2010 at 12:42 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic852243-1042-1.aspx
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
January 22, 2010 at 12:41 pm
rudy komacsar - Doctor "X" (1/22/2010)
Why not do it the easyway with alter database ???
Where's the fun in that?
:hehe:
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
January 22, 2010 at 12:32 pm
Silaphet Mounkhaty (1/22/2010)
Also, if I run into this issue again, I'll advise developers to modify the procedure to put WITH RECOMPILE option.What do you think?
I think that's using 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
January 22, 2010 at 12:29 pm
Chris Morris-439714 (1/22/2010)
GilaMonster (1/22/2010)
So not so much Windhoek as the Namib itself.Have you been there, Gail?
No. Would like to sometime.
Most safaris and hotels are aimed at the US/Europe market...
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
January 22, 2010 at 12:28 pm
So not so much Windhoek as the Namib itself.
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
January 22, 2010 at 7:46 am
malleswarareddy_m (1/22/2010)
charindex( 'F3',vr_formsfilled)>0 OR charindex( 'F4',vr_formsfilled)>0and convert(varchar,vr_visitDate,101) between @date1 and @date2
That is never going to perform well. i do hope fast response time is not a requirement here.
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
January 22, 2010 at 7:43 am
Chris Morris-439714 (1/22/2010)
I'd give several toes to visit parts of Southern Africa, including Knysna, Windhoek, the Okavango delta.
Windhoek? Why on earth do you want to visit Windhoek? There's desert 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
January 22, 2010 at 7:30 am
And it's only ever joined on the two columns? No filtered are ever done against other columns in this table?
If that's the case then you probably want to put 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
January 22, 2010 at 5:50 am
Viewing 15 posts - 34,486 through 34,500 (of 49,552 total)