Viewing 15 posts - 46,051 through 46,065 (of 49,552 total)
You'll have to export each table individually to a csv file. You can use bcp, you can write a DTS package or you can use the inport/export wizard.
What does 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
June 30, 2008 at 4:24 am
What kind of information are you looking for?
The SQL error log usually records log failures with a brief reason. Also the history of the job/maintenance plan should show success 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
June 30, 2008 at 4:21 am
If you don't have some form of monitoring in place, there's no way to find out that information.
SQL 2000 does not keep track of when objects were modified 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
June 30, 2008 at 4:19 am
Firstly, make sure that G: exists and that the path G:\SQL2KData\Staging does exist and does have the required data and/or log files that SQL's expecting to be 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
June 30, 2008 at 12:35 am
Sure. See your other post.
http://www.sqlservercentral.com/Forums/Topic525175-10-1.aspx
If you want something more specific, please give us some more detail on what you're looking 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
June 30, 2008 at 12:34 am
Hmmm, not sure if you can. From what I know of xml, each plan will have to be in a separate file to be valid xml and to be readable.
Honestly,...
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
June 30, 2008 at 12:01 am
These links should get you started
http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx
http://www.microsoft.com/learning/mcp/mcitp/dbdev/default.mspx
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/default.mspx
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
June 29, 2008 at 10:41 am
How are you displaying it and saving 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
June 29, 2008 at 10:13 am
hyeng (6/28/2008)
2) If I find that there's 11GB of empty space, Should I shrink? What's the best way to shrink or recover the empty space without causing deframentation?
In general,...
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
June 29, 2008 at 10:01 am
Jeff Moden (6/27/2008)
All ya gotta do now is store all of the data in a single monster EAV and you'd have it made. 😛
<Shudder>
Fortunatly I don't think anyone here's quite...
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
June 27, 2008 at 12:18 am
Jeff Moden (6/26/2008)
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
June 27, 2008 at 12:12 am
Nisha (6/26/2008)
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
June 26, 2008 at 11:58 pm
TheSQLGuru (6/26/2008)
2) Page Life expectancy is too low. Need more RAM.
Except that he's on 2000 Standard edition and has 2GB allocated to SQL already.
4) Latch waits pretty high. ...
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
June 26, 2008 at 1:55 pm
rbarryyoung (6/26/2008)
mithun gite (6/26/2008)
Respected Mr. Gail shaw & RBarryYoung, ...Gail is probably too polite to point it out, but I think that you meant to say "Ms. Gail Shaw".
I'm used...
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
June 26, 2008 at 1:42 pm
The 2005 optimiser is quite different to the 2000 one and often produces different plans.
One very quick thing to check first. Did you update statistics after restoring the 2000 database...
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
June 26, 2008 at 1:27 pm
Viewing 15 posts - 46,051 through 46,065 (of 49,552 total)