Viewing 15 posts - 15,961 through 15,975 (of 19,560 total)
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.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 24, 2010 at 5:53 pm
Looks like from the plans that it is related to the increased memory and cpu available in Prod2. Prod2 plan is more efficient. I also see that you...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 24, 2010 at 5:48 pm
vhakopian (3/24/2010)
I tried on 2005 and it did not work.It works on 2008
Hmmm. It works for me in both 2005 and 2008.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 24, 2010 at 5:39 pm
kramaswamy (3/24/2010)
The situation which we are facing is this - we have a "main" table, which stores all the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 24, 2010 at 5:26 pm
Trey Staker (3/24/2010)
Funny how things happen, I was just working on a nightly process to do something like this...
Yes, agreed. I have seen this several times here at SSC....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 24, 2010 at 4:50 pm
Viewing 15 posts - 15,961 through 15,975 (of 19,560 total)