Viewing 15 posts - 1 through 15 (of 65 total)
thanks for all your suggestions. Now off to find a valid MS email address that will server questions like this. Will let you know if I can get any definitive...
November 24, 2014 at 2:52 am
Hi, thanks for your replies. I agree, certified DBA figures will not really paint the accurate picture for the reason you state. But I'm guessing that's the only tangible figure....
November 17, 2014 at 8:09 am
I am aware of all the features that SQL Server offers out of the box but I specifically need a Third Party Tool.
money is not an issue, but time is...
April 15, 2011 at 8:13 am
nice article. one question?
in your backup TLog statement did you mean to say....
BACKUP DATABASE AdventureWorks TO DISK = '\\hanode1\backup\AdventureWorks_createnewfile.trn' WITH INIT
March 1, 2011 at 2:13 am
January 18, 2011 at 6:14 am
The order by matches the Index definition. Its clustered on local_ts. So it shouldnt need to sort no?
January 18, 2011 at 4:04 am
Yep as stated I have tried that but the order by at the end still causes a SORT to carried out for each query either side of the UNION ALL
January 18, 2011 at 3:43 am
as happycat says this is just a warning message and the data should be replicating away in the background
Run the following on the distributionDB to see how much data is...
December 24, 2010 at 5:15 am
Many thanks for all your help on this and pointing me in the right direction. I finally got round to getting the time to complete the solution and add other...
December 13, 2010 at 10:20 am
Thanks for you responses so far. Heres my response to some of the queries.
Why would hide a data element inside a string, then have to pull it out? A...
December 13, 2010 at 4:20 am
Did this get resolved by reinstalling the SNAC? I am having the same problems querying a linked server using a Windows Domain account that has SA on both servers. When...
November 12, 2010 at 4:34 am
all I was doing was reading from sys.database_pricipals and other permission related tables from each database so all I needed to go was grant read permission on every database to...
September 24, 2010 at 4:55 am
yep this was indeed Policy Based Management. This is a test server and one of my team had enabled it to have a play. Disabling it removed the icon and...
July 2, 2010 at 4:49 am
I'm not using policy manager anywhere in our estate. But I will check
July 1, 2010 at 12:44 pm
I agree with Hans, this original post was about updating SQL 2005 Standard Edition to SQL 2005 Enterprise edition. Its nothing to do with Upgrading a whole SQL Server version...
June 2, 2010 at 8:07 am