Viewing 15 posts - 24,781 through 24,795 (of 49,552 total)
http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/
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 21, 2011 at 2:37 am
No, it won't be SQL patches. It might be hardware problems.
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 21, 2011 at 2:27 am
I tested it and it works. Just watch that the forum converted > to > (and that will give an error). Fixed now. If you have that, either copy 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
July 21, 2011 at 2:26 am
Jannie-186227 (7/20/2011)
exec sp_msforeachdb 'use [?]if db_name() not in (''tempdb'')
begin
alter database <> set read_only
end'
however, there should be no active connections.
Cheers
Jannie
I don't think you want to try setting the system databases...
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 21, 2011 at 1:37 am
Check the SQL error log, there will be messages in there saying why SQL marked the database suspect.
You've probably got some hardware problems, check error and event logs for your...
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 21, 2011 at 1:24 am
select 'test_backup_' + year(getdate()) + '_' + month(getdate()) + ....
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 21, 2011 at 1:23 am
Jannie-186227 (7/20/2011)
Make sure your tempdb is on the default 8mb growth.Then add the sort in tempdb and maxdop to your index build.
Is or isn't? The default tempDB size and growth...
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 21, 2011 at 1:22 am
Ninja's_RGR'us (7/20/2011)
DBCC CHECKDB('CheckListDB') WITH NO_INFOMSGS, ALL_ERRORMSGS
halifaxdal (7/20/2011)
success!What's the next step? Thanks.
Err, there's no way CheckDB can run clean normally if the run with repair fails. Did you run it for...
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 21, 2011 at 1:18 am
Who said anything about sp_resetstatus?
Is that the DB's name? Is that the name that appears in the list? Are you running queries on the same server as that list of...
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 20, 2011 at 12:55 pm
p.s. I seriously hope you're not doing this on a production server... It's insanely risky to do something like this on any server of importance.
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 20, 2011 at 12:53 pm
And that's the 2000 server?
If so...
allow updates
update sysdatabases, set that DB's status to 32767
see if the DB can be queried.
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 20, 2011 at 12:52 pm
Either. No difference really.
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 20, 2011 at 11:09 am
Restore from backup. Log file missing, database not cleanly shut down.
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 20, 2011 at 11:07 am
ZZartin (7/20/2011)
set allow updates on and then update sysdatabases and set the status to 36767 for that database.
Sorry if this is slightly off topic but isn't modifying system tables...
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 20, 2011 at 11:04 am
Ninja's_RGR'us (7/20/2011)
... unless one of the connection is not a sysadmin... or maybe the owner of the db is missing and that somehow blocks in the permissions.
You have 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
July 20, 2011 at 10:54 am
Viewing 15 posts - 24,781 through 24,795 (of 49,552 total)