Viewing 15 posts - 301 through 315 (of 575 total)
Have you applied any patches to one SQL Server and not the other? Not Service Packs, patches!
November 8, 2004 at 4:32 pm
Here is my plan of attack!
1) Detirmine how much data the result set will return.
2) Produce a graphical query plan and see if the query optimizer is making use of...
November 8, 2004 at 4:24 pm
The default Transaction Isolation Level for SQL Server is READ COMITTED. This level issues Shared Locks on rows that will be selected and Exclusive Locks on rows that will modified.
As...
November 7, 2004 at 4:27 pm
You must rememebr that by default, a SELECT statement will issue SHARED LOCKS on all rows required for the query and the SHARED LOCK is released as soon as the...
November 4, 2004 at 9:34 pm
You could script the entire Database and then remove all but the Roles and Permissions, save the script and then execute the script on the other Database.
November 3, 2004 at 4:29 pm
November 1, 2004 at 5:00 pm
Ok. I currently have a Snapshot Publication of Stored procedures and Views to another Database and it works fine here.
As long as the Publication has the Stored Procedures and Views...
November 1, 2004 at 4:57 pm
When you configure Transactional Replication, 2 jobs are setup in the process. 1 is the Snapshot and the other is the job that perfroms the Replication.
All you have to do...
October 31, 2004 at 4:50 pm
Have you checked the Data in the text files to see if they are compatible with the DataTypes on the Table/s?
October 28, 2004 at 7:35 pm
Reporting Services is in its initial stages and it will improve on some features as new versions release.
My biggest gripe with Reporting Services is the Security Model. Until someone explains...
October 28, 2004 at 5:28 pm
Can you explain yourself a bit more?
When you do the synchronisation, did you specify that the snapshot should initially take place?
When you modified Data, what do you mean "the old...
October 27, 2004 at 5:40 pm
I don't know why this is happening but what you could do in the short term is stop the Distribution Job and let the Log Reader do its thing and...
October 27, 2004 at 5:35 pm
When I Design & Develop Databases, more often than not, just about every Table has an Identity Column that is also the Primary Key. I create a NON-Clustered Index on...
October 27, 2004 at 5:22 pm
Kim03,
Surely you can come up with better DBA Interview questions than that! How bout sussing out the candidate if he or she can develop Functions & Stored Procedures.
October 27, 2004 at 5:07 pm
October 26, 2004 at 7:57 pm
Viewing 15 posts - 301 through 315 (of 575 total)