I want to create a sequence of numbers in sql server it will have the minimum value and maximum value, I want to cycle if the number reaches the maximum limit. ?
How costly (CPU or memory wise) is it to have multiple instances of SQL server 2005 instead of only one instance with prefixed databases?
A company have three application providers. They each will install one application and they each require two or three databases. Should they all use the same instance or should every provider use it's own named instance?
Is there any strong reason for one or other setup?
Hi there
We have a 1TB storage server I've just gone to transfer a 100Gb file across to it.
And it has deleted the shadow copy. From Googling I understand that this probably occurred: http://support.microsoft.com/kb/826936
Is there any way of recovering those shadow copies back?
Thank you very much for having a read anyhow and any help would be greatly appreciated.
Hey I have to make a file system with an encrypted partition with on ubuntu server. something like
Unencrypted:
/ - 10 GB
/home - 10GB
/var - 5GB
--------------
Encrypted:
/opt - 50GB
This I can figure out in the setup, just partition as normal, setup /tmp as a encrypted volume with dm-crypt. However im not sure how to mirror this entire drive, so that if either failed i could still boot. and how will that affect the encrypted partition.
Any help would be appreciated.
There's a motivation in my office to make sure that all file systems on all servers in the production environment (It's a Windows environment) are identical until the last file and i'm looking for a program/tool which can help me achieve this goal.
What i actually look for is a tool that will allow me to diff server's file systems by connecting them remotely (as they are spreaded around the world).
Anyone knows a tool which allows it?
Hey Guys,
Is it a bad idea to put Exchange and Sql Server on a same box?
We have about 4-5 GB database and 10 users for exchange, can this work?
Thanks
I have a scenario based question...Something , I haven't faced till now ,but i would be interested to know the answer.
If i have assigned a luns (say, of 50 GB) and put them in storage group.However, the windows server team did not grab that lun but sent an acknowledgment saying the Luns are alingned.
I would like to know what will happen to the Luns that belong to the SG ..in my opinion they will remain in the SG as unassigned Luns ..or is there a possibility that the lUns will move back to the storage.
I have 8 SQL Server installations (on 8 separate servers).
I want a way in which I can estimate future disk space requirements. Can anyone list down the parameters which can be helpful in making such reports?
Hello,
I run into the same issue as someone who posted this question on experts-exchange.com (couldn't read the answer though as I don't have an account there):
{Quote Begin}
I noticed that the 180-day Evaluation version of SQL Server 2008 is the
Enterprise version. Is there going to be any problem "upgrading" the Evaluation Enterprise
version to a licensed STANDARD version (and how much additional stuff is going to be
left inactive on my disk and, more importantly, in my registry, etc. if I do
so)?
{Quote End}
Any advice is appreciated.
I've been tasked with taking over the administration of a MySQL installation (running on Red Hat Linux) that will become fairly critical to our business in the near future.
I was wondering if anyone could recommend some resources in regards to administering MySQL for DBAs already experienced with other relational database (SQL Server and some Oracle in my case). Specifically I'm looking for information around disaster recovery as well as high availability to start with, but I do want to get well rounded with the entire system.
Thanks in advance,
Dan
Hi,
On a SQL server, why do we need a weekly update stats job (with full scan) when we have AUTO_UPDATE_STATISTICS=ON for all databases?
Doesn't this option update statistics all the time?
Regards
here can I find somewhat reliable indications of server market shares, without having to fork out $$$$$ for IDC or Gartner reports?
I have considered the W3 statistics, net applications etc, and these are not what I would consider reliable.
Is there anything more, that is free?
I have a local user of a windows Server 2008 that is a member of builtin Users group, a program that run this user need to have write access to a Key located in the HKEY_LOCAL_MACHINE, can i enable this user to have write access in HKLM without adding it to Administrators group ?
Thanks.
I have folder to be shared on window server 2008.
If i disable all firewalls then MAC can see the folder
If i enable firewall then MAC can't connect to my folder
WHich rule i have to apply in firewall setting to make that share work
Please provide your tips and best practices for virtualizing SQL Server in VMWare ESX
I am interested in advanced configurations and settings.
Please provide reasoning behind your recommendations
Edit:
Just to clarify, I already have over 70 Virtual SQL servers in separate clusters using an ISCSI equallogic San -
What I am really looking for are those advanced configurations like:
How you configured your disks / RDM's
Do you make use of settings like
Mem.ShareScanGHz - http://communities.vmware.com/thread/143828 -
that are not well documented
I am trying to figure out how I can connect to an ESX server's storage system so that I can upload VM image files. I am a windows user if that matters (i suspect it does).
Thanks in advance
I have a Sql Server database that has a few tables with zero row count but take up a combined 10 GB of space. I can see this by doing right-click/properties on the tables in question (data space is huge, between 1 and 6 GB, and row count is zero on these tables). I have no clue what could be causing this as I would assume zero rows would mean nearly zero space taken.
Any ideas?
Now that Windows Server 2012 comes with de-duplication features for NTFS volumes I am having a hard time finding technical details about it. I can deduce from the TechNet documentation that the de-duplication action itself is an asynchronous process - not unlike how the SIS Groveler used to work - but there is virtually no detail about the implementation (algorithms used, resources needed, even the info on performance considerations is nothing but a bunch rule-of-thumb-style recommendations).
Insights and pointers are greatly appreciated, a comparison to Solaris' ZFS de-duplication efficiency for a set of scenarios would be wonderful.
Hi,
I was asked to drop some tables on a Company SQL 2005 Server and provide proof of deletion because of these tables contains sensible data. Is it possible?
Thank you all for help
Am I correct that the NET TIME command should return the time from the PDC for the domain?
If so, the issue we are contending with is that NET TIME command returns \randomfileserver.
How do I reset time server for domain to be the PDC?
I have a SQL server behind a firewall. I need to push some limited SQL 2005 information to a Web Server in the DMZ so that I do not have to let database queries come all the way into the database server on our internal network. I want to push a small amount of dynamic data to a Web server in the DMZ and lock it down so that our hosted website does not need to come into the internal network for information; I want to put a server in the DMZ that will be the only connection allowed to the SQL database. This DMZ server will be the only server that can have any sort of connection to the back-end database so the hosting provider just pull the data from our server in the DMZ...
I currently have VPS in my company and there i host about 20 websites.
My company wants to set up server locally where they can host all websites rather using 3rd party VPS
How it will cost e,g about upload ,download speed from data centre.
Cpanel license
IP registration,
hardware ,
backups,
electricity backups,
Any other costs
etc
I would prefer centos