Viewing 15 posts - 20,446 through 20,460 (of 49,552 total)
raotor (2/8/2012)
GilaMonster (2/8/2012)
It's not a SQL Server error (and so unrelated to caching of data pages on the 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
February 9, 2012 at 1:35 am
Henrico Bekker (2/8/2012)
What's up with all the (some good, some weak, some short, some long) posts from:
Site OwnersDiscuss Content Posted by Unknown ...
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 9, 2012 at 1:34 am
Well, yes. That is the measure of how full the pages are, how much data on the 8k page vs how much free space. At 75%, the page is 3/4...
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 9, 2012 at 1:33 am
My guess - very slow IO subsystem (for whatever reason). Both files have to be zeroed out entirely and that can take time. Shouldn't take 3 hours for a 300GB...
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 8, 2012 at 3:25 pm
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 8, 2012 at 3:05 pm
That's a client error. You've run your client machine out of memory.
It's not a SQL Server error (and so unrelated to caching of data pages on the server) because SQL...
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 8, 2012 at 3:02 pm
ronmoses (2/8/2012)
I agree, it sounds pretty hopeless, and the customer realizes it. They're going to pay someone to try and restore the data, and more power to them.
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
February 8, 2012 at 2:48 pm
Tell them to start typing (to re-enter all data)
Seriously....
See if you can query any of the tables (you're in emergency mode, so the DB is 'readable'). Depending on the damage...
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 8, 2012 at 2:42 pm
Seeing any interesting messages in the errorlog?
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 8, 2012 at 2:32 pm
For when you want multiple statements to commit or rollback as atomic operations
Please read basics of transactions (including ACID) in Books Online.
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 8, 2012 at 2:13 pm
crawler486 (2/8/2012)
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 8, 2012 at 2:08 pm
First step in that restore would be zeroing out the files. While the files are getting zeroed out you won't see any stats because the restore itself hasn't started, 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
February 8, 2012 at 2:02 pm
Yes.
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 8, 2012 at 1:54 pm
Are you looking at a database snapshot perhaps rather than a normal database?
Why can't you post a screenshot?
What's the output of this when run in that database?
SELECT type_desc ,
...
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 8, 2012 at 1:26 pm
Delete from tableabcd where starttime <= 2011/07/01
That's all you need. Deletes are atomic, they complete or rollback as a single operation. A delete can't partially succeed.
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 8, 2012 at 1:21 pm
Viewing 15 posts - 20,446 through 20,460 (of 49,552 total)