Viewing 15 posts - 15,556 through 15,570 (of 19,560 total)
Five or more years of experience with SQL Server 7.0 or later: installing, configuring, and troubleshooting
One or more years of experience with SQL Server 2005 or later: installing, configuring, and...
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
April 1, 2010 at 1:59 pm
You're welcome.
How big is the database? And log?
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
April 1, 2010 at 1:55 pm
Yes you can install up to 50 instances of Enterprise edition on a single server.
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
April 1, 2010 at 1:53 pm
Yes have done it. No, I did not encounter any issues.
Install the second instance as a named instance. My preference is also to assign a static port to...
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
April 1, 2010 at 1:52 pm
Thanks for the links Paul.
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
April 1, 2010 at 1:51 pm
And then it typically defaults to the first database when trying to do something like this.
As Paul suggested, dynamic SQL, SSIS package, nested stored procedures, synonyms or views could resolve...
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
April 1, 2010 at 1:49 pm
NF Scott Smith (4/1/2010)
Happy Easter too if that's your thing!
Well put, and very thoughtful.
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
April 1, 2010 at 1:47 pm
Absolutely, remove the logins. No sense in having something there that is unnecessary.
Besides the side by side install, have you considered moving all of the databases to SQL 2005?...
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
April 1, 2010 at 1:45 pm
chrismat (4/1/2010)
In order to test, I added "exec sp" to the end of the query...
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
April 1, 2010 at 1:42 pm
So we have the model by PMP as one suggestion.
Anybody have anymore suggestions as to models to research and potentially emulate?
I think the direction the conversation needs to go 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
April 1, 2010 at 1:40 pm
keith.littlejohn (4/1/2010)
They are not looking for real time but close to it. The database size is around 200gb so i think I am going to look at replication.
Good Luck....
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
April 1, 2010 at 1:39 pm
Catman (1963)
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
April 1, 2010 at 1:38 pm
WayneS (4/1/2010)
CirquedeSQLeil (3/30/2010)
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
April 1, 2010 at 1:31 pm
Michael Meierruth (4/1/2010)
CirquedeSQLeil (4/1/2010)
Michael Meierruth (4/1/2010)
Paul White NZ (4/1/2010)
CirquedeSQLeil (4/1/2010)
Thanks for clarifying that for us Paul.No problem, and at least you all stopped talking about certification for a while 🙂
I...
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
April 1, 2010 at 1:30 pm
Replace your disks with SSD?
Seriously, I like what Lynn suggested.
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
April 1, 2010 at 1:28 pm
Viewing 15 posts - 15,556 through 15,570 (of 19,560 total)