Viewing 15 posts - 38,896 through 38,910 (of 49,552 total)
What you could try is to put the tables that you don't care about into a different database and set it to simple recovery. Doesn't stop logging, but tran 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
May 26, 2009 at 12:27 pm
homebrew01 (5/26/2009)
Would adding a new field at the end of a table cause locking ?
Yes. Adding a column will take a schema modification lock, which is incompatible with...
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
May 26, 2009 at 12:13 pm
now make sure that you set up a job to run regular log backups. Otherwise this is just going to happen again.
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
May 26, 2009 at 12:11 pm
Operating system error 5 is "Access denied"
Check the folder and the log file, make sure that the SQL Service account has full permissions on the 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
May 26, 2009 at 12:10 pm
Roy Ernest (5/26/2009)
Hey, How are you all getting on to the site? The only page that works for me is this. Rest of them gives me a zonal error. 🙁
http://www.sqlservercentral.com/Forums/Topic723332-433-1.aspx
Someone...
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
May 26, 2009 at 10:02 am
Is it first normal form?
The requirement for being first normal forum is that there are no repeating groups. If we take the addresses as repeating groups, then this isn't even...
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
May 26, 2009 at 9:31 am
I guess my first question here would be whether you'll need all the addresses every time that you query the users table, or will you need them only a small...
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
May 26, 2009 at 8:27 am
george sibbald (5/26/2009)
worth a ping to steve, thanks a lot Gailseems a bit fishy to me (and you can spell that with a ph too)
Turns out to be a bit...
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
May 26, 2009 at 8:20 am
da.drew (5/26/2009)
I was informed that by selecting the DB it would go to the right one, clearly not true!
Definitely not true.
The DB selected in object explorer is not 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
May 26, 2009 at 7:41 am
select MyColumn
from MyTable
order by REPLACE(MyColumn,'(','')
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
May 26, 2009 at 7:38 am
Lowell (5/26/2009)
TWill changing my clustered index to include those columns, instead of the exisitng identity() column, assist the query performance wise?
A clustered index has the data page at it's...
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
May 26, 2009 at 7:32 am
There's no predicate (filter) on that scan, so alone there's no way to see what index would be useful there. The cluster is being scanned and the entire thing returned....
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
May 26, 2009 at 7:03 am
george sibbald (5/26/2009)
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
May 26, 2009 at 6:56 am
kladibeeto (5/25/2009)
I am using sql server 2000.
Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely 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
May 26, 2009 at 5:20 am
Leo (5/26/2009)
Is that better to change it up to 16GB for Max Memory?
Absolutely not. If you do that, SQL will try and take all 16 GB and it may...
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
May 26, 2009 at 5:20 am
Viewing 15 posts - 38,896 through 38,910 (of 49,552 total)