Viewing 15 posts - 34,381 through 34,395 (of 49,552 total)
shaunspad (1/27/2010)
Andrew thank you for looking. I was under the impression that the sp_detach_db was being deprecated and should no longer be used.
Does Books Online have a "This feature...
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
January 27, 2010 at 12:48 pm
Use profiler since the backup happens every night, include the login name, host name and application name columns.
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
January 27, 2010 at 12:47 pm
The upgrade advisor. Free download from MS. It probably won't pick up all the issues, but most.
You'll still need to do careful testing...
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
January 27, 2010 at 9:16 am
G.R.Preethiviraj Kulasingham (1/27/2010)
I receive mails on all subjects (not only threads) I have subscribed to. For example, I receive mails on "Administering"
Which means that you've subscribed to 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
January 27, 2010 at 9:07 am
Jeffrey Williams-493691 (1/27/2010)
Using instant initialization, the files that are created would not be zeroed
Using instant initialization, the data files that are created would not be zeroed. The log files still...
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
January 27, 2010 at 8:51 am
Running some Linq-to-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
January 27, 2010 at 7:43 am
Is there a question here?
IAM is basically a roadmap for heap's data pages.
Not just heaps.
In sql2005 onwards this has started allocating INCLUDE columns for non clustered index, BLOB and row...
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
January 27, 2010 at 7:29 am
A derived table, despite the name, is not a real table, it's just an interim resultset that can be references as if it were a table. If you want an...
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
January 27, 2010 at 7:29 am
Lynn Pettis (1/27/2010)
I agree, it should be fixed in a hotfix or in the next service pack, SP 2.
If you feel that way, add your comments on the Connect item.
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
January 27, 2010 at 7:19 am
Greg Edwards-268690 (1/27/2010)
I wonder what they are really considering the next major relaese?
Next major version. R2 is not considered a major version, for eg it doesn't bump the major version...
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
January 27, 2010 at 7:16 am
If you are absolutely, totally sure that the DB will never grow that big again, do a once-off shrink of the data file to a reasonable size (20GB from 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
January 26, 2010 at 10:22 pm
harpistic: I think the most important thing at the moment is to get access to the server so that you can check the Services app and see if SQL is...
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
January 26, 2010 at 10:20 pm
MothInTheMachine (1/26/2010)
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
January 26, 2010 at 10:17 pm
CirquedeSQLeil (1/26/2010)
Alvin Ramard (1/26/2010)
I haven't been paying much attention to the forums lately, but I have been checking regularly today. :w00t:I'm ready to return to the desert!!!!
I think this week...
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
January 26, 2010 at 1:27 pm
Are you 100% sure that the directory F:\MSSQL\OVOPS\Datafiles\master.mdf exists, the file is there and SQL has full permission to that directory?
If this is a clustered instance, check that the drive...
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
January 26, 2010 at 1:01 pm
Viewing 15 posts - 34,381 through 34,395 (of 49,552 total)