For some versions it appears to be "select name from sysdatabases" and for some "sp_databases"
??? - thanks - dave
View Complete Post
i have a problem to bring the data from the oracle (external database) and the
sql server together (with similar data). The linq entities are linked to each
other. The structure is like different countries with different cities and so
on. To display these "non original linq objects" i need to put them
into entities (linked to each other). Now i add some of them to my sql database.
But for every entity i must check the connection to the other objects i don't
want to add and delete them (otherwise linq will add all the connected objects, even those I don't want to add). If this goes wrong the whole input-method crashes. Is there any
other possibility, except from checking every single entity and removing unwanted connections, to handle this procedure?
Thanks a lot,
How can I get the databases names attached to specific SQL server instance?
I Need to configure Merge Replication, in this replication Can i chose the Replication Databases Recove model are
Simple is there any problem or not, why i am asking this question is, every time my log file size is become very large nearly 250GB.
Please help me
While SQL queries don't reference indexes explicitly, we all know how important indexes are to database performance. They constitute the backbone of database operations. Indexing currently is a difficult
undertaking usually mastered by senior DBAs/developers. What happens if a SQL Server site does not have an indexing expert? Performance will range from less than optimal to unacceptable.
The SQL Server Database Engine has access to all the technical information, albeit not all recorded currently, to enable automating indexing.
The DBA would have to supply query priority information, especially indicate which are the
Business Critical queries. It is safe to assume that very frequent queries are Business Critical. However, there are less frequent queries which maybe Business Critical as well.
In a nutshell current indexing wisdom: Primary Key columns (this is already automatic), Foreign Key columns and columns in WHERE clause predicates should be indexed.
I am new to SQL Server Administration. I have set up the Backup jobs according to the requirements from the Application team. Also I have set tip the update stats, Reindexing Job every 2 weeks as far as the maintenance as maintenance is concerned.
I am using SQL Scripts in the SQL Agent to perform all these jobs
But i have not scheduled any Integrity Check (CheckDB ) Jobs on any of the database in any of the servers. I have databases of Size 1Gb-50 GB and few from 100-600 Gb.
I want to set up the integrity jobs on all the databases. Can you please suggest me some best ways how I can schedule jobs every 2 or 3 weeks on small databases and on big databases like 100 - 600 GB in SQL Server 2005,2008.
We have 40 Backup serves which are 25 are Mysql Linux, 5 Oracle Linux and 5 SQL Server cluster servers (windows).
We are planning majority of Database server are in linux and we are planning to use R.Linux server as a backup server.
What are the necessary configuration are required in Windows server and Linux Server to successive in Setting up Linux backup Server.
Any suggestion is great for my implementation.
Setting up a new install who will be using SharePoint Foundation 2010 in Standalone mode. They do not have SQL SERVER 2008 so need to utilize the Standalone option and the latest version of SQL Server 2008 Express R2. They are just getting started with SharePoint
and it is unknown how much the technology will be embraced to afford to purchase SQL Server at this point. I wanted to get that explanation out of the way before everyone tells me the best practice of installing in Farm mode only! I realize the best practice
but sometimes we have to roll with the punches because getting a client to begin using SharePoint on their current budget is better than never getting the chance to use it at all.
So SharePoint Foundation 2010 is installed with the default SQL Server 2008 R2 Express instance. Is there a procedure for moving the databases to a new drive? What is the default instance name that is created? I'm having a hard time locating that information
in the documentation. I've done this before with WSS 3.0 without issue but wondered if there were any documents on moving the newest databases and what the default instance name is. Thank you in advance.