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.
3
votes
1answer
33 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()). ...
1
vote
3answers
153 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 ...
-1
votes
1answer
24 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
3answers
447 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 ...
-2
votes
1answer
189 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?
1
vote
1answer
279 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 ...
2
votes
2answers
83 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 ...
