Viewing 15 posts - 2,446 through 2,460 (of 7,502 total)
Thank you all !
Todays session went fine.
Still having a good voice after 4h+.
I banned coffee and consumed 1,5L water, nicely planned 10min break every 75 minutes. The speaking speed...
January 17, 2011 at 9:58 am
What's your MSDTC security configuration.
I think you db2 as400 uses xa transactions.
Did you enable XA transactions with MSDTC ?
January 15, 2011 at 8:43 am
Have a look at "Choosing an Authentication Mode" http://msdn.microsoft.com/en-us/library/ms144284.aspx
January 15, 2011 at 5:26 am
There are restrictions for online rebuild operations.
indexes that have columns of data types data type text, ntext, image, varchar(max), nvarchar(max), varbinary(max) or xml cannot be rebuild online.
I think your index...
January 15, 2011 at 1:27 am
If those objects are strictly for reporting purposes, you can easily put them in their own database at the reporting sql instance and have them access your read only database...
January 15, 2011 at 1:23 am
Did they ever consider database mirroring.
I know it very much depends on the volume of your db load, but it if you are on Ent Edtn, you could (re)create a...
January 14, 2011 at 12:50 pm
IMO you did forget to grant the needed auth for SQLServer.
Whenever I need to move db files to a new disk or folder I use
this in command prompt
rem /T...
January 14, 2011 at 12:37 pm
sqlservr.exe -f means start mimimum configuration .
Shouldn't you start it without the -f parameter and the trace flag after you performed the procedure Gail pointed to?
January 14, 2011 at 10:42 am
Keep in mind your "ID+1" solution will only work if you don't have gaps in your ID sequence.
If you are using the identity property for this column, you may have...
January 13, 2011 at 12:45 pm
Probably you are calculating using int columns or decimal(x,0).
With sqlserver you need to take care of the precision you need.
In your case I would suggest to test this:
cast((SumOfPremiumOnTime * 1.00...
January 13, 2011 at 12:33 pm
Nope, You're very serious with your observations :doze:
btw : deprecated stuff for sql2005 : http://msdn.microsoft.com/en-us/library/ms143729%28v=SQL.90%29.aspx
for the moment they still plan support for text/image with "Denali" :crazy:
January 13, 2011 at 4:45 am
Did they develop/implement new code or has a part of the application been used that they didn't use previousley.
If it is a new dev part, they should have used the...
January 13, 2011 at 4:04 am
If you know the expected file size is very small, you could as well read it directly into an xml object and the also have you clr proc load your...
January 12, 2011 at 5:00 am
Can't you block these addresses in your firewall, so they don't even get to your sqlserver ?
January 12, 2011 at 12:41 am
Viewing 15 posts - 2,446 through 2,460 (of 7,502 total)