Viewing 12 posts - 46 through 57 (of 57 total)
Thanks everyone, I have taken MyDoggieJessie's idea's with Scot's amendments, it works well and is now live in the prod environment.. 🙂
Ta
David
March 7, 2014 at 2:37 am
Hi,
I have had locking issues with the xp_cmdshell executing within the uncommited transaction so I have moved the catch up the script. I guess I could nest try/catch blocks which...
March 6, 2014 at 5:22 am
Grant makes a good point about using COPY_ONLY and Ed's point about data security is a very valid one in this digital age. Follow their advise..
March 5, 2014 at 1:49 am
Hi,
I'm assuming your laptop is part of the same domain as the SQL Server. Create a shared folder on your laptop, You will need to give the user which starts...
March 4, 2014 at 2:02 am
I would start by adding tempdb data files inline with the current wisdom from SQL Product Support which is to have 1 file per core up to 8 cores, over...
March 3, 2014 at 4:59 am
Another shot in the dark.. 🙂
How many Tempdb data files do you have? Using current wisdom on this you should have eight. I have seen your symptoms on a server...
March 3, 2014 at 3:24 am
I came across this article a while back. It might help
Ta
David
February 27, 2014 at 9:02 am
Hi,
My first step would be to set up a Central Management Server. There is a great article on it here:
http://www.brentozar.com/archive/2008/08/sql-server-2008s-new-central-management-server/
Then I would execute sp_spaceused against your group...
February 26, 2014 at 1:47 am
Hi,
something like this should work;
select [Year],
[FinanceValue-2014],
[FinanceValue-2013],
[FinanceValue-2012],
'FinanceValue Variance' = [FinanceValue-2014]-[FinanceValue-2013],
'SumofVariance' = CONVERT(MONEY,(([FinanceValue-2014]-[FinanceValue-2013])+[FinanceValue-2012]),2)
from Finance
Ta
David
February 25, 2014 at 5:19 am
Hi Dave,
My first question would be, whether you need all of the tables within the database, it maybe better to isolate a number of key tables then script those to...
February 25, 2014 at 2:18 am
Lowell and Keith,
Thanks for your input, I have modified my proc using Lowell's last script and it performs well.
Thanks for your time
Ta
David
February 10, 2014 at 10:35 am
Hi Keith,
I'll get on and read the artical.. 🙂
In the meantime I have been working with this as an example. The first row is correct, second has no order number,...
February 4, 2014 at 10:19 am
Viewing 12 posts - 46 through 57 (of 57 total)