Viewing 15 posts - 37,966 through 37,980 (of 49,552 total)
Writing 2TB of zeros will take a while. That's exactly what instant file initialisation was added to prevent - the need to first write over the data file with zeros...
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
July 1, 2009 at 1:14 pm
Bhargav Patel (7/1/2009)
CTE really improves performance as always in most cases.
Got some examples of that?
CTEs are pretty much 'named subqueries'. The whole query still runs in one go just...
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
July 1, 2009 at 12:22 pm
This is one reason why columns should always be prefixed with the name or alias of the table they're from. It's just good practice and, if you do that, putting...
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
July 1, 2009 at 12:16 pm
I assume you mean multiple TempDB files, seeing as there can only be one TempDB database.
I would start with 4 files for TempDB, all on the same drive. Placing any...
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
July 1, 2009 at 12:12 pm
Please in future start a new thread for a new question.
Placing the mdf file on one drive and the ldf on a separate drive will give you IO benefits as...
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
July 1, 2009 at 12:07 pm
Krasavita (7/1/2009)
Thank you it make sense,just make sure I understand corectly: Is for data and logs the same?
The recommendations are the same. Whether or not you set the growth 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
July 1, 2009 at 11:13 am
It's not a bug. You're allowed to reference columns from the outer query inside a subquery. It has to be allowed, or something like this couldn't be done
select * from...
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
July 1, 2009 at 11:08 am
It's not about security. Checksum page protection lets SQL pick up more forms of corruption than Torn page could, and also can show that said corruption is caused outside 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
July 1, 2009 at 10:54 am
Odd. I can't see why that should be happening.
This seems to work, though I'm not sure why it does and the other version doesn't.
EXEC master..sp_MSForeachdb '
IF DB_ID(''?'') > 4
BEGIN
EXEC (''Alter...
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
July 1, 2009 at 10:27 am
There are no hard and fast rules for this. We can't say that your config is right or wrong.
Recommended practices:
Monitor the size of the DB and manually grow 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
July 1, 2009 at 10:19 am
david.morrison (7/1/2009)
sorry IE had a freak out when posting. I tried to delete but didnt work
Threads can't be deleted. No worries.
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
July 1, 2009 at 9:55 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic745523-359-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
July 1, 2009 at 9:45 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic745523-359-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
July 1, 2009 at 9:44 am
You can chance them as you like. A switch to simple takes effect immediately. A switch from simple to either full or bulk logged takes effect after the next full/diff...
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
July 1, 2009 at 9:43 am
Are you sure? I just ran it on my local server (admittedly SQL 2008) with just the SELECT ''?'' inside the IF and I got a list of all 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
July 1, 2009 at 9:24 am
Viewing 15 posts - 37,966 through 37,980 (of 49,552 total)