Viewing 15 posts - 36,061 through 36,075 (of 49,562 total)
There's about 1 coffee shop per block in this city, plus a couple in the convention center.
coming to the SSC party tonight?
November 2, 2009 at 9:15 am
There's no easy calculation for an 'optimal' fill factor. Depends on the clustered index key, depends on how fast the clustered index fragments, how much you want to reduce fragmentation,...
November 2, 2009 at 7:40 am
You can try RESTORE VERIFYONLY. If the backup was done with the CheckSum option and all the database pages had checksums, then if this returns successful the backup will very...
November 2, 2009 at 7:37 am
You are correct. To do file/filegroup restores you have to have the log backups because, to bring the DB online, all the files/filegroups have to be rolled forward to the...
November 2, 2009 at 7:35 am
stephenmbell (11/1/2009)
November 1, 2009 at 9:49 pm
Jack Corbett (11/1/2009)
I hate traveling!
Likewise.
15 min late leaving JHB because of bad weather (hail, rain, lightning and thunder), 30 min late into Paris (and turbulence entire flight).
2 hours late out...
November 1, 2009 at 10:13 am
Databases can never be downgraded. The internal database version and changes to design of the system tables prevent that
November 1, 2009 at 7:19 am
Do you just want to check if there is any row that satisfies that condition and do the stuff in the if once, or do you want to do the...
November 1, 2009 at 7:14 am
November 1, 2009 at 7:08 am
Though table value functions (well, multistatement ones) do have some performance issues.
October 30, 2009 at 2:21 am
Enterprise edition is not supported on non-server OS's.
Why Enterprise? Those licences aren't cheap and it can't be because of required enterprise-only features if you're upgrading from Express. Consider Standard edition...
October 30, 2009 at 1:52 am
Would someone be willing to keep an eye on this thread?
http://www.sqlservercentral.com/Forums/Topic811359-266-1.aspx
I'm not sure at this point how big a problem it is, but I'm leaving for the airport in 3...
October 30, 2009 at 1:51 am
Ankit Mathur-481681 (10/30/2009)
If it can work 1 level deep why not 2 level. Not even by any workaround????
Because 1 level is not nested and two is?
Do the procs always get...
October 30, 2009 at 1:41 am
Please run the following and post the full output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Take a look at this article. http://www.sqlservercentral.com/articles/65804/
Do you have a clean backup of this database? (a...
October 30, 2009 at 1:37 am
Viewing 15 posts - 36,061 through 36,075 (of 49,562 total)