Viewing 15 posts - 44,866 through 44,880 (of 49,552 total)
onlo (8/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
August 26, 2008 at 12:43 am
Firstly, don't delete your log. You are asking for a suspect database doing that. It will grow when you do index rebuilds.
It could be a number of things. If you...
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
August 26, 2008 at 12:41 am
Are the instances all enterprise edition? Standard edition ignores locked pages.
What's the max memory set to on each of the instances?
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
August 26, 2008 at 12:34 am
Defaults only apply to new rows inserted. If you want the existing rows with null to change to that value, you'll have to run an update statement.
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
August 26, 2008 at 12:29 am
If you're working with 2005, take the 2005 exams. They're not redundant with SQL 2008 out and I believe there will be an upgrade path.
I wrote one of the betas...
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
August 26, 2008 at 12:28 am
Are you getting an error message? If so, what? How are you trying to set the primary key?
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
August 26, 2008 at 12:09 am
Colmn order doesn't really have a meaning in SQL. It just determines how the columns appear when the create table is scripted and how they are returned if SELECT *...
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
August 26, 2008 at 12:07 am
Duplicate post.
Direct replies to http://www.sqlservercentral.com/Forums/Topic558592-149-1.aspx please
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
August 25, 2008 at 11:46 pm
Not the backup.
You said the database had being detached. Can you reattach the database files to the SQL instance?
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
August 25, 2008 at 11:38 pm
armintucakovic (8/25/2008)
As I understand it rebuilding indexes will update stats automaticly equal to full scan and so I dont have to do that? correct?
Correct. There are a number of scripts...
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
August 25, 2008 at 10:37 am
HanShi (8/25/2008)
For performance it is better to NOT shrink the LOG-file. It takes lots of I/O for the log-file to expand each time.
In addition it causes internal log fragmentation...
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
August 25, 2008 at 10:33 am
Strange. It's as if it is in autoclose, despite not being set that way. That's certainly not normal behaviour. Strange. I'll look into this.
Some advice: CheckDB with any form of...
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
August 25, 2008 at 10:17 am
sugan (8/25/2008)
Is it possible to assign null value to variable.
Yes, and I showed how to do it. As for the second part, try something like this:
SET @string1 = 'insert...
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
August 25, 2008 at 10:11 am
Cliff Jones (8/25/2008)
Do you still need to enable trace flag -T1118 to enable the uniform allocations feature in SQL 2005 as we did in SQL 2000?
I don't believe so.
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
August 25, 2008 at 10:02 am
Please could you post create statements for the tables, sample data (as insert statements) and your expected output.
Having all that makes it much easier and faster for us to get...
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
August 25, 2008 at 5:05 am
Viewing 15 posts - 44,866 through 44,880 (of 49,552 total)