Does anyone know where I can find the best Microsoft guide on installing SQL Server 2005. I want to improve the existing DBA team installation guide...
How can you align data in SQL Server 2008 to work on large sets in parallel?
Does anyone have a link for a calculation chart for saving space for differnt data types when using SPARSE?
Thanks - as all instances are running at the moment - i will decrease the memory without failing over - I don't need to bring up/turn online any...
Anyone got a useful example of this too?
Does anyone have a good example of this please?
1) Why is enterprise edition useful for server consolidation? 2) Is microsoft IE 6 SP1 needed to install SQL Server 2008? If so why? 3) Can an...
are you 100% sure u can change the memory setting without restarting the instance? let me know if you have actually tested this or you are making a...
I need to change the sql server memory on all 4 instances as they are set too high. Can I change the max memory setting by failing over the resources...
Hi Just to give u a little advice from my experience: consider the following when comparing: cost, skills, manageability, compatibility - this is a...
Hi everyone - I'm just starting to get to grips with 2008 for a client with no prior training so learning on the go! I'll be sending lots of 2008...
u can use sp_who to see logins connected - but i need to count active individual users (not just logins, as could be using a windows group login) -...
i forgot to say i need to log this info in a table on a regular schedule.
hi frank - this did the job! many thanks u r very helpful :) did u code this yourself or did you have this from somewhere?
how do i count active users? i need to determine whether a database is still active? any other ideas here would also be useful. thanks!
I need to automatically insert today's date into a datetime field but ensure the time part is blank so the result is like '2011-02-23 00:00:00:000'....
lol thanx franx !?! ;)
what are reduplication clusters?
Hi Frank these links state if u install and enable wmi provider for sql server 2000 then it creates root/MicrosoftSQLServer namespace and populates...
Separate names with a comma.
