Tagged Questions
18
votes
2answers
3k views
What does a DBA have to know about SSAS?
I've seen a lot of material covering the business aspect of SSAS, but not really much about the important aspects of administration and management.
From the point of view of administering an instance ...
15
votes
7answers
12k views
How can I tell if a SQL Server database is still being used?
We're looking to decommission a SQL Server instance which has a couple databases still remaining on it.
How can I tell if they are still being used by users or a web application?
I found a forum ...
14
votes
2answers
1k views
How to make a transition from SQL Server DBA to Oracle?
As an interest, if I would to transition from a SQL Server DBA to Oracle what will be the major learning or unlearning that I would have to do?
I would assume the concepts are the same and the ...
10
votes
1answer
264 views
What does a SQL Server DBA need to know about Windows Server?
Analogous to my previous question What does a DBA have to know about SSAS?, which generated a really wonderful answer (thank you, @ConcernedOfTunbridgeWells!), I now ask a similiar question:
What ...
9
votes
1answer
332 views
Are there reasons why I should not set my db owner to [sa]?
Yesterday I asked this question regarding changing the dbo of multiple databases that I have. The change makes sense, but I want to be clear.
Is there any, good reason or circumstance why I should ...
8
votes
2answers
1k views
Handling growing number of Tenants in Multi-tenant Database Architecture
Handling a modest number of customers (tenants) in a common server with separate databases for each tenant's instance of the application is relatively straightforward and is normally the correct way ...
7
votes
2answers
435 views
SQL Server schema intact but every record from every table is gone
We recently set up a new virtual machine running Windows Server 2008 and slapped a copy of SQL server 2005 on it. The server had running and in use without a hitch for about two weeks. The only real ...
6
votes
5answers
461 views
How do I rule out SQL Server as the reason for a slow website
A website we host has recently been experiencing slow load times. It's been ruled out that the problem lies with the web server and it maybe database related.
What steps or procedures do I take to ...
6
votes
2answers
139 views
Automation of backups of Large Number of Database
In a multi-tenant web application where a database is set up for each tenant, the database can be backed up and restored manually through a fairly conventional approach.
I am considering this type of ...
6
votes
3answers
162 views
Can I check the services currently running through SSMS?
I want to check which services has started and which has not by running a script/query on SSMS.
6
votes
1answer
146 views
On-the-fly query/command modification
I'm responsible for administrating an instance of SQL Server 200x which has the misfortune of serving as a backend to a turnkey application written with a disgusting performance problem. It repeatedly ...
6
votes
1answer
190 views
Role of Database Administrators
I am currently working as an application developer on a project which involves the creation of a new SQL Server database. I am actively working with a group of DBAs who will play some role in the ...
5
votes
2answers
197 views
Running each SQL Server service under different Windows accounts
Besides the Database Engine, SQL Server has some additional Services, namely:
SQL Server Integration Services
SQL Server Analysis Services
SQL Server Reporting Services
SQL Server Agent
Should ...
5
votes
1answer
327 views
Does dropping a Primary Key constraint from a Partitioned Table break the partition?
We have a table partitioned on a date column. The Primary Key for the table is a composite key of this date column and 4 other columns.
We are thinking about dropping the Primary Key constraint from ...
4
votes
3answers
2k views
How to reduce the log file size without shrinking it in SQL server
In SQL server, how do you reduce the log files size without (DBCC) shrinking it. I know shrinking the log file will free up some space, but will also cause fragmentation. Doing a checkpoint in simple ...
