Viewing 15 posts - 41,761 through 41,775 (of 49,571 total)
foxjazz (1/14/2009)
Ok, instead of giving me problems, how about providing a solution.
This is not the first time that you've criticised the free help that you're getting here. If you want...
January 14, 2009 at 9:09 am
Grant Fritchey (1/14/2009)
Evidently I'm only providing problems, not solutions.
*twitch* I'm losing my temper here....
January 14, 2009 at 9:06 am
plreeter (1/13/2009)
Does anyone know if disabling the indexes and rebuilding them after the bulk insert is a more efficient method than dropping the indexes and recreating them after the insert?
It'll...
January 14, 2009 at 9:00 am
Since you have the execution plan that you want to force, try using the OPTIOn (USE PLAN ...) hint. That guarantees that the baseline query will never change plan.
The disclaimer...
January 14, 2009 at 8:21 am
A snapshot is a sparse file. The size of the file appears to be the size of the database, but it hasn't reserved that much space on the disk. The...
January 14, 2009 at 8:07 am
If you're on SQL 2005, and I assume you are because this is the SQL 2005 forum, use traceflag 1222 rather than 1204. It produces a lot more output and...
January 14, 2009 at 8:04 am
For testing purposes only!
Hints should not be used in production code, unless you really, really know what you're doing and are 120% certain you know better than the optimiser.
Right, now...
January 14, 2009 at 8:01 am
It would be nicer it it was a script that I could just run to create the tables and insert the data, but it will do. I probably won't be...
January 14, 2009 at 12:58 am
Sandra Skaar (1/13/2009)
One question - is it possible that SQL Server's alerting is a bit wacky when the server is virtual, and on a SAN to boot? Just curious.
No. If...
January 13, 2009 at 11:34 pm
Can you please connect to that server from a querying tool and run the following. Post all of the outputs
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
January 13, 2009 at 11:24 pm
madhu.arda (1/13/2009)
I did this already DBCC SHRINKFILE (N'MSDBLog' , 500) . But the log file size still showing as 17Gb after shrinking the file!!!
How full is the log file? Have...
January 13, 2009 at 10:58 pm
Avinash (1/13/2009)
you can restore the backup in a different box that is taken before the update.
Except that he doesn't have a backup.
January 13, 2009 at 10:56 pm
shnex (1/13/2009)
I should be kicked a little for the way I posted 😀I will write the tables and the desired output
🙂 Don't worry. We only kick repeat offenders. 😉
January 13, 2009 at 1:34 pm
Viewing 15 posts - 41,761 through 41,775 (of 49,571 total)