Viewing 15 posts - 46,951 through 46,965 (of 49,552 total)
No need to start a second thread. People have already posted suggestions to your other one - http://www.sqlservercentral.com/Forums/Topic481421-338-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
April 9, 2008 at 5:56 am
Did you copy the files off a CD/DVD? If so, they'll be marked readonly (file property) and hence the DB will be read only once attached.
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 9, 2008 at 4:15 am
Is the folder that the DB files are in either encrypted or compressed?
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 9, 2008 at 3:48 am
tosscrosby (4/8/2008)
Just a tip - When you have really bad fragmentation, with the databases offline (SQL server services are stopped), you can run the system tool "Disk Defragmenter".
That 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
April 9, 2008 at 3:38 am
The Practical troubleshooting book (edited by Ken Henderson) has a chapter dedicated to memory, including when and why to use the switches and exactly what effect they have. It's a...
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 9, 2008 at 3:21 am
bradfordshultz (4/8/2008)
A)you shouldnt index 150 fields
If you're using SQL 2000, you can't create a covering index over 150 fields. Index keys are limited to 16 columns.
In 2005 and...
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 9, 2008 at 12:37 am
SQL 2005's a lot better at ORs than 2000 was. It now can (and sometimes does) process an or the same way it would process a union.
Try them both, see...
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 9, 2008 at 12:29 am
Matt Miller (4/8/2008)
The truncate activity (which essentially deallocates pages or marks them as "free") itself is not logged.
The changes to the allocation pages are logged, otherwise you couldn't...
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 9, 2008 at 12:27 am
Stanley Pagenel (4/8/2008)
Msg 195, Level 15, State 5, Line 2'SHOWPLAN_XML' is not a recognized option.
Are you using SQL 2005 or 2000?
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 8, 2008 at 8:07 am
There shouldn't be any difference in performance.
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 8, 2008 at 7:50 am
I'm curious. Why do you need to do this?
You can use a startup procedure, or you can create a job that will run when SQL agent starts. Either 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
April 8, 2008 at 5:50 am
Hmm. Never used plan guides, so I'm guessing.
How about the template option? That's for use by parameterised queries, so maybe...
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 8, 2008 at 5:37 am
I believe that lock pages is required if you're using AWE. If you don't have more than 4GB memory on the server, you do not need awe or /PAE
As 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
April 8, 2008 at 5:35 am
Why are you trying to send me the excel spreadsheet?
I was talking about sending the exported file to your consultants.
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 8, 2008 at 3:11 am
How are you trying to mail the files? I can't offer much help unless I know what you're doing...
With SQL 2005, Database Mail's probably the easiest to set up if...
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 8, 2008 at 2:41 am
Viewing 15 posts - 46,951 through 46,965 (of 49,552 total)