Viewing 15 posts - 39,556 through 39,570 (of 49,552 total)
8060 bytes.
You can get around that by using one of the MAX data types that are stored off page. Also variable length character data can be pushed off page (row...
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 23, 2009 at 2:54 am
Anytime that you use a unicode constant, the query will be slower. That's because of implicit conversion that's required on the column which prevents any index seeks.
None of 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
April 23, 2009 at 2:53 am
CH&HU (4/23/2009)
5. Yes we are using the secondary server for pulling SharePoint & reports.
I'm not sure you can run sharepoint against a database snapshot. Have you tried?
The mirror db...
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 23, 2009 at 2:04 am
Turning that off is not the same as dropping the indexes. All you gain by turning that option off is that SQL won't automatically update statistics if it thinks 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
April 23, 2009 at 2:03 am
Query sys.databases. What does the log_reuse_wait_descr column say for that database?
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 23, 2009 at 1:59 am
Differentials are based on the previous full backup. If you do not have the last full backup that ran before the differential, you cannot use that differential backup.
If you have...
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 23, 2009 at 1:48 am
Drop all the foreign keys that reference that table. Drop the unique index. Recreate the foreign keys.
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 23, 2009 at 1:40 am
homebrew01 (4/22/2009)
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 23, 2009 at 1:39 am
Query sys.databases. What does the log_reuse_wait_descr column say for this database?
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 23, 2009 at 1:37 am
In previous years you've been able to register right up until the start of the conference. It just gets progressively more expensive as you get closer to the conference
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 23, 2009 at 1:30 am
Rather try doing the backup from a query window. Have object explorer disconnected.
Backup log ... to disk ... WITH NO_truncate, no_recovery
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 22, 2009 at 12:02 pm
mikeoflaherty (4/22/2009)
What are the ramifications of ticking the Boost SQL Server Priority on Windows option?
Don't. It's strongly advised (by Microsoft) that the setting not be changed.
If you have performance problems,...
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 22, 2009 at 10:49 am
Here's something that may get you started. I make no guarantees as to how well it will perform.
SELECT USER,
SUM(CASE WHEN STATUS NOT IN ('90R','99I') THEN 1 ELSE...
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 22, 2009 at 10:46 am
megho_man (4/22/2009)
Ok , it's not a SQL Server error , but what is the cause ?I want to know the reason of this issue , or the solution.
No...
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 22, 2009 at 10:35 am
Something my previous manager told me that's stuck in my memory.
"When you accept a job, have a plan for what you want to do 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
April 22, 2009 at 10:29 am
Viewing 15 posts - 39,556 through 39,570 (of 49,552 total)