Viewing 15 posts - 15,871 through 15,885 (of 49,552 total)
I did in my first post. Books Online (the SQL documentation)
p.s. Please stop calling me that.
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
October 30, 2012 at 1:25 pm
As Books Online clearly says, shrinkfile with the emptyfile option is for data files. It is used to migrate data pages to other data files in the same filegroup.
Log records...
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
October 30, 2012 at 1:13 pm
Post the results of both 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
October 30, 2012 at 1:09 pm
menon.satyen (10/30/2012)
1. Take backup of your databases.
2. Detach your database after closing all active connections
3. Attach the database using SSMS.
4. Delete the log file that's not required from 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
October 30, 2012 at 1:01 pm
As I said...
You're looking at a nonclustered index in the first one (index id 9) and all indexes (clustered and nonclustered in the second)
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
October 30, 2012 at 12:59 pm
You don't need to run a checkpoint. All you need to do is wait a bit. Forcing a checkpoint just makes SQL re-check and update the DMV (well, simplifed)
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
October 30, 2012 at 12:10 pm
Resource governor (SQL feature) is not managed by Windows Server Resource Manager. They are two completely different things. The former allows usage of certain resources by sessions within SQL 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
October 30, 2012 at 12:01 pm
You're looking at a nonclustered index in the first one (index id 9) and all indexes (clustered and nonclustered in the second)
p.s. sys.sysindexes is deprecated, should not be used. Replacement...
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
October 30, 2012 at 11:40 am
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
October 30, 2012 at 11:32 am
That's part of resource governor, allows sessions to be classified and have some limits applied to them.
As for what's optimal or best, that depends on your apps, db usage, how...
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
October 30, 2012 at 11:24 am
mike 57299 (10/29/2012)
I tried to change a table from char(xx) to varchar(xx). It seems that it doubled the amount of space used. What gives?
Rebuild the clustered...
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
October 30, 2012 at 11:01 am
What do you mean by cap limit?
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
October 30, 2012 at 10:41 am
Log_reuse doesn't change instantly. Wait a bit, run a checkpoint if you want to hurry things along, then check what it says after that. Also check to make sure that...
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
October 30, 2012 at 10:36 am
You can't delete any log file that has any portion of the active log regardless of whether there are any currently running transactions or not (stopping transactions won't change that).
Use...
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
October 30, 2012 at 10:35 am
It's historical. 255 used to be reserved for LOB (it's not any longer). It's basically legacy from SQL 2000 and before.
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
October 30, 2012 at 10:28 am
Viewing 15 posts - 15,871 through 15,885 (of 49,552 total)