Viewing 15 posts - 41,536 through 41,550 (of 49,571 total)
Rajesh kasturi (1/22/2009)
Thanks for your reply, While rebuilding the index log file will be used or data file will be used.
Both. The data file because that's where the new...
January 22, 2009 at 3:52 am
serge.kovacs (1/22/2009)
January 22, 2009 at 3:52 am
Suggest to the sharepoint admin that it would be better to take backups to the local disk and later move them to a network share?
If that's not an option, ensure...
January 22, 2009 at 12:37 am
ifila (1/21/2009)
Not looking for an argument, but why does MS offer a shrink capability if it is a bad idea ?
Because there are times when it's necessary. Note that...
January 22, 2009 at 12:36 am
It's used on Vista (and I think Server 2008) to add in an administrative user as, by default, the builtin\admins are no longer automatically sysadmin on those OSs. It's only...
January 22, 2009 at 12:25 am
lucassouzace (1/21/2009)
ok, is Latin1_General_CS_AS
Right. That's case sensitive (that's what the CS shows)
For some strange reason, the hierarchyid data type is case sensitive in some places in a case sensitive database....
January 22, 2009 at 12:10 am
Rajesh kasturi (1/21/2009)
If you run the backup log with truncate_only, I am sure your log file will be...
January 22, 2009 at 12:08 am
Unless you have a good reason not to, every table should have a clustered index.
Tests have shown that with a well-chosen clustering key, all operations are faster on the table...
January 21, 2009 at 1:18 pm
Grant Fritchey (1/21/2009)
I'm inclined to say the second without any data. But I've seen instances where the first can be faster.
If the indexes are good, the stats accurate and the...
January 21, 2009 at 1:15 pm
You can use the windows scheduler and sqlcmd to do scheduled backups. It's not as easy as SQLAgent, but it does work. For sqlcmd, you'll want to use the -i...
January 21, 2009 at 1:14 pm
JKSQL (1/21/2009)
which process is faster and better for longevity?
Depends. Test them both under load and see which one scales better. Sometimes the temp table is better as...
January 21, 2009 at 1:05 pm
My guess is that it found a possible index inconsistency in that table. (row in cluster that's not in the noncluster or vis versa)
The way the checkDB algorithm works is...
January 21, 2009 at 12:51 pm
pixye.sb (1/21/2009)
you mean that a user having the role db_datawriter on msdb has by default the same privilege on all databases in that instance?
No. A user with the db_datawriter on...
January 21, 2009 at 7:27 am
thulani.moyana (1/21/2009)
January 21, 2009 at 7:25 am
It's in the database properties. From object explorer, right click the database and select properties.
It's also probably available with one of the DATABASEPROPERTYEX options
January 21, 2009 at 7:24 am
Viewing 15 posts - 41,536 through 41,550 (of 49,571 total)