Tagged Questions
0
votes
1answer
42 views
SQL Server database files on different disk as is OS installed
My very short overview
SQL Server databases are installed as virtual machines on VMWare, there are plugged a few disk areas with the same (or very similair) parameters
versions are SQL Server ...
0
votes
0answers
38 views
mySQL- large database
I need guideline to setup DBMS(MYSQL or SQL Server 2008). The database size is expected upto 80-100GB in next few months. One main table will contain textual content like essays. Can MySQL handle such ...
2
votes
0answers
135 views
SQL Server SSIS issue retrieve data when i enter into login of server side?
can any one try solve my problem here i am facing a problem Failed to retrieve data when i enter into login of server side
here is the error message
TITLE: Microsoft SQL Server Management Studio
...
0
votes
1answer
402 views
Database design : multiple category of users login into same system
In our new system we have three type of people
Business owner
Assistant of business owner
Staff (a skilled employee)
I am having following entity
[Business] - include detail about business ...
2
votes
4answers
1k views
Small sample database for practicing database administration?
I'm looking for a portable sample database that
can be created from a script
has a simple ER model
has little data for database administration practicing purposes.
I know that there is e.g. ...
3
votes
2answers
2k views
How to check that stored procedure is valid
As we know, it is possible to compile and to have so stored procedures:
CREATE PROC dbo.MyProc1
AS
SELECT * FROM Not_Exists_Or_Removed_Table
or
CREATE PROC dbo.MyProc2
AS
SELECT
Id
...
3
votes
1answer
102 views
Data transformation implementation
My company's database, I am working with, makes available a data to a lot of external applications. So I need to transform the same data to a lot of dynamic views. I can see that a former database ...
