Viewing 15 posts - 1 through 15 (of 15 total)
Nice question .. thought Provoking and had to try a number of times.
January 5, 2010 at 11:11 am
As far as I remember you will be able to do this from Cluster Administrator in Windows.
As far as I remember (i dont have access to a cluster now) we...
March 11, 2009 at 2:05 pm
may be there is a reason, but why create table for last run and where do you want to create it?
February 19, 2009 at 2:21 pm
this is from one of my previous posts
For DB:
Option 1: If Downtime is permitted and db is of medium size --> put source DB in read only mode -->...
February 19, 2009 at 2:17 pm
it depends on the types of data you will store.
In the example provided - agreed there is no performance implication.
however if the data stored in the...
February 19, 2009 at 2:12 pm
sp_who2 returns
SPID --> which is the process under consideration
BLK --> if it has a value represents the SPID of the blocking process
Ex. SPID =10 BLK=51 --> Process...
February 5, 2009 at 8:26 am
requirements are not clear - how do you insert/update thur a SPROC or DTS or some other means.
Clarify requirements so we can provide directions
January 15, 2009 at 10:18 am
I looked at http://msdn.microsoft.com/en-us/library/ms175515.aspx too,
i'm not sure if just reducing the activity will help - because of the statment - "Regardless of system activity, running DBCC...
January 15, 2009 at 7:54 am
The default config for various options is available
http://msdn.microsoft.com/en-us/library/ms190707.aspx.
It is best to reset to the original config after the work on index view is done
January 12, 2009 at 2:40 pm
is it possible for you to post what the expected output is suppose to be. That will help with resolution
January 12, 2009 at 2:22 pm
The following query will give an idea of why len is returning 12 and how to get it to return 9.
select len('123456789 ') IfVarchar, (cast(cast('123456789 ' as float) as varchar))...
January 12, 2009 at 2:06 pm
Hello since the request format is not a standard we will have to manipulate.
The query below provides the format requested
select getdate(),
cast(datepart(dd,getdate()) as varchar) + '-'+ left(convert(char(12),getdate(),9),3) +'-'+ cast(datepart(yyyy,getdate()) as...
January 7, 2009 at 11:26 am
For DB:
Option 1: If Downtime is permitted and db is of medium size --> put source DB in read only mode --> Full backup and restore on new server.
Option...
January 5, 2009 at 3:28 pm
understaning your data is quite difficult - its not clear. can you provide better data and expected output?
December 23, 2008 at 1:16 pm
Viewing 15 posts - 1 through 15 (of 15 total)