Viewing 15 posts - 16,126 through 16,140 (of 49,552 total)
Eugene Elutin (10/15/2012)
... There wouldn't be any overhead since the DB isn't querying anything to get the value of [a].
...
Except the fact that this will lead 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 15, 2012 at 6:40 am
Uninstall the 32-bit version. Install the 64-bit version. Take backups of the system databases and detach all user databases before then after you've installed the 64-bit restore the system DBs...
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 15, 2012 at 6:36 am
I have to agree, some of the comments I've had have been so strange that you just can't get anything useful out of them.
Grant and I got something like 'Next...
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 15, 2012 at 6:27 am
Nope. Maybe read the last two articles I linked above.
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 15, 2012 at 3:16 am
Abu Dina (10/15/2012)
Bulk recovery - Bulk operations are minimally logged - other operations are logged as normal.
But that's true for simple recovery as well.
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 15, 2012 at 3:08 am
http://msdn.microsoft.com/en-us/library/ms175526.aspx
Managing Transaction Logs[/url]
http://www.sqlservercentral.com/articles/Administration/75461/
http://www.sqlservercentral.com/articles/Recovery+models/89664/
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 15, 2012 at 3:08 am
The CX packet wait means queries are running in parallel, nothing more. It does not automatically mean you need to reduce maxdop (and certainly not to 1)
What you need 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 15, 2012 at 2:37 am
Ok, why, why, why, why are you wanting to do this? I hope this isn't for a production system, because it's far from good design.
You need to use dynamic 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
October 15, 2012 at 2:34 am
You cannot insert a row to a system table (and those views are views of the system tables).
The grant statement I posted grants the permission that you say 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
October 14, 2012 at 1:59 am
For a VLF to be marked inactive by a log backup, none of the log records within that VLF must be needed for anything. Anything includes checkpoint, active transaction, replication,...
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 14, 2012 at 1:57 am
Active. The log records are still needed by something, in this case the checkpoint.
A VLF is only inactive when none of the log records in it are needed for anything.
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 13, 2012 at 2:29 pm
Marios Philippopoulos (10/13/2012)
I found out that this data file contains data from a text column.Could this be the reason I am having trouble shrinking the file?
Yes it is. The structure...
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 13, 2012 at 2:26 pm
Very normal with LOBs, they do take huge amounts of time to move around. You just have to wait.
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 13, 2012 at 2:25 pm
You should be able to. As long as you just shrink the files with the TEXT it shouldn't even cause the usual fragmentation. Log pages are arranged differently than index...
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 13, 2012 at 9:54 am
Did you install the database engine, or just the client tools?
Is the service listed in service manager? Is it running?
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 13, 2012 at 8:59 am
Viewing 15 posts - 16,126 through 16,140 (of 49,552 total)