Tagged Questions
An acronym for "Structured Query Language", SQL can be used in relational database management systems (RDBMS) to query, update, delete, and insert data as well as modify the structure of the database. It can also be used to manage schemas and data access privileges.
0
votes
1answer
8 views
Installation problem in SQL server 2005?
Does SQL Server 2005 express has the problem in installation in single user systems
7
votes
1answer
47 views
How do I read Query Cost, and is it always a percentage?
I'm currently studying for SQL 70-433 (the Microsoft Certification exam), and I'm getting very confused about the "query cost" performance metric.
According to any documentation I could find via ...
3
votes
2answers
60 views
Database behind a Multilingual User Interface
This question is about an issue somewhat more complicated than the one which has already been addressed in these old questions, all of which are duplicates of one another:
Suggestion for database ...
0
votes
3answers
32 views
Upgrading to SQL Server 2008 R2 but downgrading the edition - will this cause problems?
I am looking at upgrading our SQL Servers from 2005 Enterprise edition to SQL Server 2008 R2 Standard edition.
Obviously, the upgrade to 2008 R2 gives us more features even in Standard edition, but I ...
0
votes
3answers
51 views
why locks a table will improve performance during transaction?
I just started to read about table lock in SQL (from this page)
It saids:
table lock may reduce the overhead of acquiring a large number of row
or page locks and save overall locking time
...
1
vote
1answer
20 views
How do I determine if a database restore file should be restored to the database based on backupset?
I have a production database that is fully backed up nightly and incrementally backed up hourly. On our backup machine, we have the differential backups and full backups restored ion a regular basis ...
0
votes
1answer
28 views
In which folder / directory does SQL 2008 store files?
Where can I set the folder to store a database in when I create a new Database in the Microsoft SQL 2008 Server?
0
votes
1answer
50 views
SQL Server job failure
I have a job that executes every 15mins on SQL Server 2008 and it comes up with the following error at least once in two days. But, it runs successfully the next time it runs. The account that is ...
1
vote
2answers
43 views
How to implement superkey sub key method on cascading tables
If I design a database with a securitymaster table that has all the common columns and then have a final column called securitytype which acts as a reference to the sub table, how is it possible to ...
1
vote
3answers
68 views
Local user login access in sql server 2008
I have a created a local user called 'MynetDB' with SQL Server Authentication (password) in SQL server 2008. Server roles is public and user mapping to 2 databases as db_owner and public. Status has ...
1
vote
1answer
37 views
SQL database restore failed
I have a c# application that is connected to my sql server 2005 database, i am working on the application to insert some entries in the database and due to power failure system got down and from that ...
1
vote
1answer
12 views
SQL database restore failed
I have a c# application that is connected to my sql server 2005 database, i am working on the application to insert some entries in the database and due to power failure system got down and from that ...
4
votes
3answers
89 views
Find the first gap in an aggregation of integers in SQL Server
Let's say I have a table called dbo.GroupAssignment.
GroupID | Rank
------------------
1 1
1 2
1 3
2 1
2 3
2 4
3 2
3 4
3 5
The PK is GroupID, Rank. Normally, the ranks ...
4
votes
2answers
73 views
PostgreSQL multi-column unique constraint and NULL values
I have a table like the following:
create table my_table (
id int8 not null,
id_A int8 not null,
id_B int8 not null,
id_C int8 null,
constraint pk_my_table primary key (id),
constraint ...
3
votes
3answers
77 views
NULLs in a composite primary key - SQL Server
I'm trying to work out the best way of creating SQL Server primary keys, foreign keys and constraints to accurately represent my data model in LINQ / Entity Data Objects. Let's assume - for the ...
