Viewing 15 posts - 39,571 through 39,585 (of 49,571 total)
Change the primary key to clustered. Is there any good reason it was created as a nonclustered index in the first place?
April 23, 2009 at 7:31 am
mithun.gite (4/23/2009)
ok means the max row size is 8060 bytes and anything more than then resides off the page , right...
No.
The max row size is 8060 bytes and creating a...
April 23, 2009 at 4:05 am
create table my table (str1 varchar(3000),
str2 varchar(3000)
str3 varchar(3000)
)
it created the table and i entered 3000 chars in all columns and it working fine.
Yup. Varchar are variable length character data. See...
April 23, 2009 at 3:36 am
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...
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...
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...
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...
April 23, 2009 at 2:03 am
Query sys.databases. What does the log_reuse_wait_descr column say for that database?
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...
April 23, 2009 at 1:48 am
Drop all the foreign keys that reference that table. Drop the unique index. Recreate the foreign keys.
April 23, 2009 at 1:40 am
homebrew01 (4/22/2009)
April 23, 2009 at 1:39 am
Query sys.databases. What does the log_reuse_wait_descr column say for this database?
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
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
April 22, 2009 at 12:02 pm
Viewing 15 posts - 39,571 through 39,585 (of 49,571 total)