Viewing 15 posts - 26,911 through 26,925 (of 49,552 total)
Please note: 5 year old thread.
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
April 1, 2011 at 3:24 am
prady_1988 (4/1/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
April 1, 2011 at 3:23 am
It clears both. As does detach, restore, offline.
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
March 31, 2011 at 2:34 pm
foscsamuels (3/31/2011)
It includes alter table rebuild, but it looks like that is new for sql 2008.
It is indeed, SQL 2008 only.
Generally there aren't too many good reasons for a table...
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
March 31, 2011 at 2:32 pm
Yes, more concern over forwarding pointers. However the point is moot, you can't rebuild a heap.
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
March 31, 2011 at 12:48 pm
Sean, next time it happens, if you're allowed to investigate, feel free to post specific questions and we'll see what we can help with.
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
March 31, 2011 at 11:13 am
Make sure that you are in the DB that you refer to. Index Physical Stats is database independent, sys.indexes is not. There's nothing wrong with your code that I can...
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
March 31, 2011 at 8:52 am
Vertigo44 (3/31/2011)
Ughh. Yeah I think I'm going to read up on taking away delete rights next! 😀
If this is a production server, why the hell do they have any rights...
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
March 31, 2011 at 8:46 am
David Benoit (3/31/2011)
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
If it is the post...
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
March 31, 2011 at 8:14 am
SQL 7?
From the forum you posted in I assumed 2005.
You can restore the logs with standby and inch the STOP AT time forward bit by bit. Tedious, but that's about...
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
March 31, 2011 at 7:06 am
I'm working on it, but it's not simple and I can't work on it while busy with client work.
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
March 31, 2011 at 5:03 am
Lynn Pettis (3/31/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
March 31, 2011 at 4:42 am
THE-FHA (3/31/2011)
but cant you jst upgrade 10.00.4000 to 10.50.*** without having to upgrade the entire server or that would still give issues? Isnt there a CU for this 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
March 31, 2011 at 4:40 am
prakashmohandoss86 (3/31/2011)
It took more than 1 hour and immediately i have tried...
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
March 31, 2011 at 4:36 am
There is no solution. You cannot restore a SQL 2008 R2 database to SQL 2008. They are separate versions of SQL and downgrade has never been possible for a 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
March 31, 2011 at 4:34 am
Viewing 15 posts - 26,911 through 26,925 (of 49,552 total)