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 ...
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 ...
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 ...
Is it possible to read the transaction log in text/table format, and if so, how can I do that?
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 ...
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 ...