Viewing 15 posts - 16,921 through 16,935 (of 49,552 total)
You said you tried to take the backup manually. What was the backup statement, what was the exact error?
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
August 27, 2012 at 7:13 am
What's the backup statement?
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
August 27, 2012 at 7:08 am
Yes, they are. http://www.sqlservercentral.com/Forums/Topic1350342-1549-1.aspx
Unless it's a language problem, he's a consultant or contractor. Either the client's asking for something that is not in his listed skills or....
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
August 27, 2012 at 7:03 am
Formatted so that it's readable
SELECT t1.GA_Drg_NO ,
SUM(t1.wr_scope) AS wr_scope ,
SUM(t1.fitup) AS fitup ,
...
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
August 27, 2012 at 6:50 am
I think you need to do a lot more research. Start with Book Online, after that look for the HA/DR whitepapers from Microsoft. Alternately, suggest to your client that they...
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
August 27, 2012 at 6:45 am
Start with the pages in Books Online on Database Mirroring and Log shipping. There's lots of info there. If you've done that, try google, there are lots of blog posts...
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
August 27, 2012 at 6:33 am
Query, table definitions and index definitions please.
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
August 27, 2012 at 6:07 am
Views are just saved select statements. They aren't tables, they don't store data. Where else would the changes go when you update a view?
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
August 27, 2012 at 6:05 am
Without details on exactly what you've done, what errors you're seeing and what exactly you mean by 'corrupted' it's impossible to give any useful advice on recovering the mdf.
That said,...
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
August 27, 2012 at 6:02 am
Let's put it this way, lots and lots of VLFs will slow the redo 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
August 27, 2012 at 5:59 am
Pass two parameters, one the start year, one the end year, both of type datetime (or date, or datetime2). One parameter of a mess of strings is just going 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
August 27, 2012 at 5:04 am
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/Topic1350030-145-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
August 27, 2012 at 5:01 am
Evaluates the subquery for each row in the outer table. Again, if you're using MySQL no idea what/if the replacement is.
If you are using MySQL, maybe a MySQL forum will...
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
August 27, 2012 at 3:20 am
SELECT OBJECT_NAME(object_id) AS TableName ,
i.name AS IndexName ,
ds.name AS FileGroupName
FROM ...
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
August 27, 2012 at 2:22 am
raghuldrag (8/27/2012)
while copying row in oracle we can use %type (or) %rowtype is there.....
Use it 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
August 27, 2012 at 2:08 am
Viewing 15 posts - 16,921 through 16,935 (of 49,552 total)