Viewing 15 posts - 27,721 through 27,735 (of 49,552 total)
Can you post a sample piece of XML?
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
February 16, 2011 at 5:57 am
Brandie Tarvin (2/16/2011)
In fact, if the database is online and suspect, a restart might make the db completely unrecoverable.
Not quite.
Restarting SQL when there's a corrupt database could take 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
February 16, 2011 at 5:54 am
Marco V (2/16/2011)
true, thats why addressed in my post it should be done when he is at the point of restoring
The only time one should restart SQL as part 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
February 16, 2011 at 5:47 am
There's your problem. It;s set to compatibility for SQL 2000. Check the databases where it does work, my bet is the compat will be 90 or higher.
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
February 16, 2011 at 5:45 am
Restore the latest full backup with norecovery
Restore the latest differential with norecovery
Restore all log backups since the latest differential with norecovery
RESTORE DATABASE <db name> WITH RECOVERY
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
February 16, 2011 at 5:05 am
Hashbytes is a one-way hash. It's not reversible and that's the whole point of a hash.
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
February 16, 2011 at 5:04 am
Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1064852-146-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
February 16, 2011 at 5:02 am
What version is production? What's the compatibility level of the DB on 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
February 16, 2011 at 5:00 am
We had a starwars weekend some time back (good couple of years). Just about everyone had a starwars avatar and used starwars-style phrasing and idioms. I just never bothered switching...
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
February 16, 2011 at 4:59 am
abhas (2/16/2011)
Hi,if i don't specify commit then when delete command will be commited?
The moment that the delete command completes (assuming no explicit begin tran and that implicit transactions is off)
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
February 16, 2011 at 4:57 am
Brandie Tarvin (2/16/2011)
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
February 16, 2011 at 4:49 am
kvr1985 (2/16/2011)
master0ONLINEtempdb0ONLINE
model0ONLINE
msdb 0ONLINE
DBAAdmin 0ONLINE
another database not showing any thing.
If you open object explorer, is the database listed 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
February 16, 2011 at 4:44 am
crazy4sql (2/16/2011)
if we select database it's showing error. database is not operational
what Gail is referring is to run this query in master database:-
select name, state,state_desc from sys.databases
and report...
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
February 16, 2011 at 4:43 am
If the optimiser decides there are too many key lookups it will chose rather to use a clustered index scan as it will be faster.
Use a more restrictive predicate 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
February 16, 2011 at 3:22 am
That's like asking a car mechanic if he can replace the engine without him knowing the slightest thing about what is wrong with the car.
Once more with feeling...
GilaMonster (2/15/2011)
GilaMonster (2/15/2011)
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
February 16, 2011 at 3:18 am
Viewing 15 posts - 27,721 through 27,735 (of 49,552 total)