Viewing 15 posts - 766 through 780 (of 2,496 total)
How can you work out a new architecture until you know exactly what they currently have? Until you know this, your new design can only be provisional.
It is very...
March 12, 2012 at 4:48 am
Understanding of what reporting services is doing is a little easier if you have been programming in one of the .net languages (or even something like VB6).
Very true!!!
Under the covers,...
March 12, 2012 at 4:42 am
MSSQLTips has a good article about the performance impact of TDE...
March 6, 2012 at 8:00 am
select [Column List] from MyView where MyColumn = @TheParameterHere
In SQL Server, this syntax is often just as efficient as including the WHERE clause within the view definition itself. If...
March 6, 2012 at 7:52 am
Doing any upgrade in place between SQL Server versions has risks.
Your plan needs to include what you will do if the upgrade fails part way through and SQL...
March 6, 2012 at 7:31 am
A bit off topic... WSUS is full of 'If Only....'
If Only WSUS had a automatic Decline rules feature as well as an automatic Accept rules. I could then...
March 5, 2012 at 7:24 am
WSUS has categories to filter what it will download. Maybe SQL Service Packs were not configured for download within WSUS.
It is not uncommon to exclude SQL Service Packs from...
March 5, 2012 at 4:58 am
You virtual OS image exists on a VHD or similar. Why not get the physical server to boot to the same VHD?
The first time you do this, boot into...
March 5, 2012 at 4:35 am
Shrinking a database is a bit like letting the air out of your car tyres while you are parked because you do not see the need for them to have...
February 29, 2012 at 6:07 am
If you can afford it, ask your manager about dropping to part time, so you get paid for less days each week. Then approach charities to see if they...
February 28, 2012 at 9:06 am
What is the Business SLA? If the performance satisfies the SLA, then the box is good enough.
If the SLA is met, then your next question should be 'Is the...
February 27, 2012 at 4:52 am
Any upgrade plan from SQL Server version X to version Y (for example from SQL 2005 to SQL 2008) that uses an upgrade in place or uninstall reinstall on the...
February 27, 2012 at 4:41 am
Up until November last year we had a mixed SQL 2005 and SQL 2008 R2 environment.
We direct all database writes for our critical systems to a central server...
February 27, 2012 at 4:19 am
Ultimately you can pick whatever time horizon you want. However, there are factors you should include when picking your time scale...
1) What is the realistic time between raising a...
February 20, 2012 at 8:47 am
Jamie, have you done any research to find out what might be going on? If so, what are your results so far?
February 20, 2012 at 7:56 am
Viewing 15 posts - 766 through 780 (of 2,496 total)