Viewing 15 posts - 15,961 through 15,975 (of 19,564 total)
Jeffrey Williams-493691 (3/24/2010)
Sorry, but that is just too risky a situation for me...
Leaving the database wide open is too risky for me as well. I think you will find...
March 24, 2010 at 10:05 pm
The Dixie Flatline (3/24/2010)
Instead, why don't you look into partitioning your main table (and it's indexes too!) ? That bought us some excellent performance benefits.
I like the...
March 24, 2010 at 9:06 pm
Profiler is one method. You could also search your stored procs to find any instances of that table.
If code is hitting your database from the application and is not...
March 24, 2010 at 8:57 pm
If the servername, databasename, and schema are no longer present in the query being sent, then something has changed in the application. I would check again.
March 24, 2010 at 8:55 pm
Model is the "model" that will be used by SQL Server to create any new databases.
Thus it's importance is "it depends" on your environment. I would place MSDB above...
March 24, 2010 at 8:53 pm
repent_kog_is_near (3/24/2010)
one of the DB is just non-confidential info that the company wants to be in public mode so anyone can have access for PR.
I believe that status...
March 24, 2010 at 8:50 pm
Echoing Jeff here. SSIS is unnecessary to create a maint plan. However, if you have SSIS installed, you can edit the Maint Plan with BIDS. You would...
March 24, 2010 at 8:23 pm
SQL Reddy (3/24/2010)
If i have two nodes A,B and two instances X,Y .
If X,Y are running on A ,and B...
March 24, 2010 at 7:12 pm
Active/Active is having each node in a cluster hosting a differenet sql instance.
http://www.sqlmag.com/article/clustering/active-passive-vs-active-active-clustering.aspx
March 24, 2010 at 6:34 pm
I agree with Grant, Gus, Lowell, Lynn, and Steve.
Try to answer the questions, browse the topics, test the answers. Testing some of this stuff out is very effective in...
March 24, 2010 at 6:20 pm
I would start by finding some books. Narrow down the topic by picking a few specific things you want to learn - and then find the answers.
March 24, 2010 at 6:10 pm
Without the clustered index, no.
For the archiving of the heap tables - do you have a unique key or unique index on the table - could help with the archiving,...
March 24, 2010 at 6:02 pm
The group will need to have select permission for the tables on the database where the tables reside.
It would be best to assign these permissions to a role and then...
March 24, 2010 at 5:58 pm
The main difference is that transactional is one way replication (by default). Merge replication is two way replication.
March 24, 2010 at 5:53 pm
Viewing 15 posts - 15,961 through 15,975 (of 19,564 total)