Viewing 15 posts - 211 through 225 (of 276 total)
Yes, stated in the post above, network DTC is up and running.
February 7, 2007 at 11:39 am
Here is what I use - I do have alerts set to email...And every morning I run "Reoganization", kick out the tables that are to large and will not complete...
February 5, 2007 at 10:38 am
I have this product as well...however, some days I wonder if I am not using it to its full potetial. What sort of things do you use this for? How...
February 2, 2007 at 8:49 pm
MANY thanks! I have made the change, and will continue to research the DBCC options you have shown me. Thanks again!
December 4, 2006 at 11:52 am
one thing you need to remember, when setting the memory min and max, you need to leave some memory for the OS as well. with the 7 gigs you have...
November 2, 2006 at 8:28 am
Very nice - I have learned a lot, cannot wait till the next article.
October 23, 2006 at 6:45 am
Thanks for the explaination. Another way to look at this may be that if you want everything from today and yesterday, you need the DATAADD/DATEDIFF. If you want everything for...
October 17, 2006 at 8:00 am
why have the datediff and dateadd? Would it be easier to just do something like this:
declare
@offset int
set
@offset = 1
October 17, 2006 at 7:10 am
I do not have SQL 2205. I just started working with SQL 2005 not to long ago.
October 13, 2006 at 12:33 pm
Perhaps I do not understand the question. Are you looking for opinions to how to construct your usernames, or a way to, within SQL to create a unique userid...
October 11, 2006 at 12:44 pm
If I understand your question correctly, you are wondering if SQL Server 2000 on an A/A or A/P cluster is done at the server (OS) level or SQL Server, then the...
September 27, 2006 at 7:33 am
Idera has a solution as well. I currently only use Diagnostic Manager, and really like it. there are a number of other tools that are good as well with in...
September 25, 2006 at 8:03 am
It works for me, however, when I am trying to do this from a consulting gig, their internet watching program does not allow video, and there, it stops after the commercial.
September 21, 2006 at 6:22 am
Here is a pretty simple (and quick) option.
===============================================
declare
@string varchar(50)
select
@string
September 18, 2006 at 11:13 am
Viewing 15 posts - 211 through 225 (of 276 total)