Viewing 15 posts - 1,051 through 1,065 (of 1,157 total)
The limit is your capacity and usage vs cost.
If you intend to bring the databases into standby mode, you will incur a licence fee in addition to the hardware costs.
March 5, 2011 at 11:09 am
We do this almost on a day to day basis.
1. Add the article using script
2 Add the subscription to the article
3. Generate snapshot (1 article will be generated)
Step 1 will...
March 5, 2011 at 11:02 am
Use the IF UPDATE() funtion to test for columns that have been updated.
You can also use the COLUMNS_UPDATED() function which uses a bitmap but could be a little too complicated...
March 5, 2011 at 10:46 am
We've encountered this issue as well.
Hopefully MS will fix this bug in the next SP.
March 4, 2011 at 6:37 am
sree-879715 (12/18/2009)
This morning I was asked by my business managers whether we can clone a SQL Server 2005 Instance and move it to another virtual server and use it.
I...
March 3, 2011 at 8:54 am
There is only one way of getting rid of a killed/rollback spid that wont go and that is to restart the service.
I've had this once before and found the only...
February 24, 2011 at 1:03 pm
Also, fragmentation only really has a major impact on index scans, its a lot less detrimental if you are doing index seeks.
February 23, 2011 at 1:56 pm
A good start to an overview to SQL trace.
It'd be useful if the next one detailed the difference between profiler and server side tracing where one uses rowset and the...
February 23, 2011 at 8:50 am
I've got a number of scripts I use daily and have them stored safely in a SSMS Solution and version control. Some of them are job specific but these...
February 21, 2011 at 9:36 am
As a rule, I never perform actions from the GUI. The most I do is use it to generate T-SQL for efficiency. You'll find that management studio performs...
February 21, 2011 at 5:49 am
Oliiii (2/17/2011)
February 18, 2011 at 2:51 am
Can you provide the sql version please?
select serverproperty('ProductVersion')
This advanced setting is only available in 2005 and above.
My only other thought is running each sql statement individually and confirming success as...
February 16, 2011 at 6:50 am
Some companies use a second instance to provide a distinct separation of databases and roles. Others are happy to have a single instance shared.
February 16, 2011 at 6:40 am
I've previously set up a powershell task on a Windows 2008 cluster (as this has clustering PS) and this was able to tell if both instances were running on the...
February 15, 2011 at 7:01 am
There are many licencing models.
Is this to be per processor based licensing?
Do you operate under any sort of volume licensing contract?
All companies I've worked for to date have been able...
February 11, 2011 at 10:18 am
Viewing 15 posts - 1,051 through 1,065 (of 1,157 total)