Viewing 15 posts - 766 through 780 (of 5,103 total)
mnachu (1/5/2009)
Database: AdentureWorks.
.NET version 3.6 with SP1, EF is included in .NET. Using VS 2008 with SP1.
I am trying some examples in Microsoft Entity Framework. I...
January 5, 2009 at 10:35 am
I join to the "FREQUENT REORGANIZE" idea... In my 24x7 Servers Reindexing is banned!
January 5, 2009 at 9:24 am
row counts are not necessarily the same as the actual rows.
You should use tablediff or any other diff tool to determine if the rows are exactly the same. If they...
January 5, 2009 at 9:03 am
cherukuri1974 (1/4/2009)
Thanks for your reply , Suppose my Subscriber server is failed , Then what are immediate steps i have to perform,And i need complete solution if you have...
January 5, 2009 at 8:58 am
Kiran (1/5/2009)
January 5, 2009 at 8:44 am
sqlblue (1/5/2009)
100,000 at a time. How do i do it so that the...
January 5, 2009 at 8:36 am
sqlblue (1/5/2009)
January 5, 2009 at 8:21 am
Jon.Morisi (12/31/2008)
thanks noeld, that certainly was the easier way to do it!So, SQL 2000, are we stuck with using the trace files?
Yes. Manageability, is in my opinion one of the...
January 5, 2009 at 8:16 am
Restore will fail if there is a snapshot associated with the DB.
December 31, 2008 at 11:53 am
select datalength(imagecolumnnamehere) from tbl where productid = 'N340'
December 31, 2008 at 11:51 am
Jon.Morisi (12/31/2008)
Is there a better way...
December 31, 2008 at 11:41 am
cpailma (12/30/2008)
December 31, 2008 at 11:08 am
cpailma (12/30/2008)
My last batch is 2 minutes old.I back up my transaction log every night.
you should do it more often!
December 30, 2008 at 4:15 pm
Check the "severity" level
From BOL:
Errors with severity from 0 through 10 are informational messages and do not cause execution to jump from the CATCH block of a TRY…CATCH construct.
Errors that...
December 30, 2008 at 3:34 pm
Are you backing up you transaction logs ?
December 30, 2008 at 3:30 pm
Viewing 15 posts - 766 through 780 (of 5,103 total)