Microsoft's free version of their popular enterprise software, SQL Server. Targeted at smaller installations, SQL Server Express cannot be used on databases larger than 10GB, and cannot use more than a single processor.

learn more… | top users | synonyms

4
votes
3answers
3k views

SQL Server Timeout: Drop and Recreate Index Solves the Issue

After having sql timeout issues with one of our queries we added a few indices that then made the query run very quickly and got rid of any timeout out issues we were having. The strange thing is ...
3
votes
2answers
667 views

checksum(newid()) as primary key - what happens if a collision occurs?

Inspecting a rather critical database that is used by some software on my system, I found that one of the tables had a primary key on the column Id, where Id is calculated using checksum(newid()). ...
2
votes
2answers
161 views

Upgrade SQL Server 2008 Express to SQL Server Workgroup 2008 Volume License

I'm in need of some help with SQL Server. I’m fairly new to SQL Server so bear with me. My situation: We currently have SQL Server 2008 Express installed and running on Windows Server 2003. We are ...
1
vote
1answer
796 views

How to create database, and add user linked to login?

created a login and a user in the master database and linked that user to the login. I created a new database, then went to that database and immediately tried to create a user linked to the same ...
0
votes
1answer
80 views

Hazards of Upgrading SQL Server Express 2008 to R2

A client of mine reached the 4GB database limit on a SQL Server 2008 Express. As a test I installed the R2 version on another machine and restored a backup of the database. I'd like to upgrade the ...
0
votes
3answers
130 views

DISTINCT Role in SELECT

EDIT: @Moderators: Please delete this question. I still feel that it is unclear what I am asking. Maybe I could have used some Venn diagrams in order to describe the problem. The COUNTs do not seem to ...
0
votes
1answer
83 views

Should I use backup compression for databases where all data is already compressed?

In SQL server with enterprise edition, there are databases with all the tables/indexes compressed. Does it still make sense to do compressed backup?
0
votes
2answers
547 views

SQL Server account delegation setup

I am try to run bulk insert command on SQL Server 2008 but I am having issues with the security. after researching via internet, the problem has something to do with account delegation and ...
0
votes
0answers
46 views

Connecting from SQL Server 2000 client to SQL Server 2008 Express

How to connect from SQL Server 2000 client in my pc to our SQL Server 2008 express server? I'm using to connect to our SQL Server 2008 with 'servername' using sql server authentication. error: ...
0
votes
0answers
34 views

Got error with lookup transformation in sql server 2005 BIDS

I have query to seperate the current and history DB's ** select , year(doj) from source where year(doj)<=(year(getdate())-3)* Here the moved data(<=2011) from current DB should be deleted and ...
0
votes
0answers
67 views

The fulltext catalog upgrade failed because of an inconsistency in metadata between sys.master_files and sys.fulltext_catalogs

I am using sql server 2008 and when trying to restore .bak file I'm getting this error: The fulltext catalog upgrade failed because of an inconsistency in metadata between sys.master_files and ...
-1
votes
1answer
77 views

Transferring Data from SQL Server to SQL Server Express? [duplicate]

How do I transfer a database from a physical server running SQL Server 2012 to another server running SQL Server 2008 Express? The database was created by sa under SQL Server 2012. Thank you.
-1
votes
1answer
185 views

valid index on SQL server 2008 [closed]

Which of the following is not valid index configuration for a table on SQL server 2008? A partitioned clustered index and a partitioned non_clustered index. A non clustered index and many clustered ...
-2
votes
2answers
495 views

Can the transaction log in SQL Server 2008 Express edition be viewed in text?

Is it possible to read the transaction log in text/table format, and if so, how can I do that?