Viewing 15 posts - 35,851 through 35,865 (of 49,552 total)
How did you restore? Please post the exact script that you used. Check the SQL error log. Post all errors relating to that DB.
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
November 13, 2009 at 10:08 am
In SQL 2005 and above, the row count information is in sys.partitions. Filter on index_id IN (0,1) and sum the row count by object id. You have to sum because...
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
November 13, 2009 at 10:06 am
First things first. Replace those drives (or at least get the DB elsewhere). Playing around on drives that are known to have had problems before is just asking for trouble.
Best...
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
November 13, 2009 at 10:03 am
Glad to hear it.
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
November 13, 2009 at 9:48 am
It is very hard to max out a modern multi-proc server. Generally, if the queries are well written, disk or memory bottlenecks are hit well before the CPU and so...
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
November 13, 2009 at 9:46 am
OLDCHAPPY (11/13/2009)
nice article - yours?
Yup. My blog
No backup becasue it's a test server.
Doesn't mean it shouldn't be backed up. Personal opinion: If you can't recreate a DB completely...
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
November 13, 2009 at 6:58 am
Why no backup?
See this post for a way to hack the database back into the server and get things working. http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/. Don't delete the transaction log, just use the hack...
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
November 13, 2009 at 5:16 am
Please start a new thread for a new question in future.
There's some connection to the DB that you're trying to restore. Not necessarily yours, but there is one. If you're...
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
November 13, 2009 at 5:13 am
Danspojken (11/13/2009)
But I want the index to treat these two columns as one...
Why?
If you want to do that, create a calculated column in the table, persist the column 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
November 13, 2009 at 5:12 am
siddartha pal (11/13/2009)
Should I go ahead and create all of them or some other things I need to consider?
Not without testing them to make sure they really do help.
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
November 13, 2009 at 5:10 am
guptaajay1985 (11/13/2009)
Thanx Gilla ,as.mdf means application server.
Huh?
Do you really have a directory called E:\as.mdf\? Not a file, a directory?
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
November 13, 2009 at 5:09 am
Subhash-63067 (11/13/2009)
How about if assign the 'CONTROL SERVER' permission to the DBA's and "Deny Select" on all user tables in the database?
That'll work initially, however as someone with control server...
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
November 13, 2009 at 4:13 am
Encryption (with the keys stored outside the DB) is about the only way to do this. If a DBA has sysadmin permissions then, by definition, he can do absolutely anything...
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
November 13, 2009 at 3:17 am
amitsingh308 (11/13/2009)
Sir Can you provide me any help book for using Foxpro database
Try a google search. Should turn something up.
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
November 13, 2009 at 3:13 am
amitsingh308 (11/13/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
November 13, 2009 at 3:11 am
Viewing 15 posts - 35,851 through 35,865 (of 49,552 total)