You need to do is to restart SQL Server

what about stored procedure/query (re)compilation ?

presentation: http://www.microsoft.at/eventsmedia/Getdocument.ashx?ID=1b10033b-84bd-4fed-860e-9a82897163d7

real fine box 😉

i think that you should look for ppt: "Dude, Where Is My Memory?". This session was delivered at many event (incl. Tech2008, Teched2009) by Maciej Pilecki -...

maybe you should ask folks from redgate ?

you have two options:

1) redesign your database - use normalization

2) buy much faster hardware

there is one more options:

maybe indexed views can help you in this problem ... but in my...

declare @table as table (student varchar(50), course varchar(50), marks int)

insert into @table values ('Sam', 'Maths',10),('Sam', 'Science',10),('Sam', 'English',30),

('John', 'Maths',60),('John', 'Science',70),('John', 'English',90)

select student, Maths, Science, English

from

(select marks, student, course from @table)...

i think that you dont know how to properly manage log files. you should read this one:

http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx

backup types:

full - backup of all data (backup database ...)

incremental - backup of changed data since last incremental backup (backup log ...)

differential - backup of changed data since last...

http://www.waldspurger.org/carl/papers/esx-mem-osdi02.pdf

http://www.vmware.com/pdf/esx3_memory.pdf

http://www.jimmcleod.net/blog/index.php/2008/06/10/vmware-balloon-drivers-and-sql-server/

how to disable:

http://communities.vmware.com/message/1205798;jsessionid=9AE80861BDBDF155C01208022D6FEA10

http://kb.vmware.com/kb/1002586

please check other counters: page life expectansy and buffer cache hit ratio

there is no substition for break on ;/ but maybe you can use something like this ?

declare @t as table (name varchar(50), dep varchar(10), num int)

insert into @t values ('Marcin','IT',1),('John','IT',2),('Marcin','IT',3),('John','IT',4),('Marcin','IT',5),('Steve','IT',1),

('Marcin','SEC',1),('John','MAR',2),('Marcin','SEC',3),('John','FIN',4),('Marcin','MAR',5),('Steve','FIN',1)

;with...

1. Does that mean we need to install the software on all 4-5 machines or just one?

Nope, CAL is only a paper 😉 all you need is to install you...

YES, it is supported. you should read following articles:

http://support.microsoft.com/kb/956893

http://blogs.msdn.com/psssql/archive/2008/10/08/sql-server-support-in-a-hardware-virtualization-environment.aspx

you should read more about Server Virtualization Validation Progam - http://www.windowsservercatalog.com/svvp.aspx

SQL elder then 2005 have some problems with updating some system tables. Because dbcc updateusage is generating some stress you shouldnt run this after every load cycle. But before every...