Viewing 15 posts - 17,596 through 17,610 (of 22,219 total)
I've had 2000, 2005, 2008, and four different versions of Express all running at the same time on an XP box. No issues. Well, except that it's slow as hell...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 28, 2009 at 6:11 am
Yikes. That won't be easy. I'd try using a UNION between each of the different databases, assuming you know what they all are. That way, any given query against any...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 28, 2009 at 6:10 am
Have you read through the topics in the Books Online (documentation included with SQL Server). I think it explains parallel query execution pretty well.
By and large, there's little that you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 28, 2009 at 6:07 am
You should read Gail's articles first. They'll answer a lot of your questions. You might want to pick up Kalen Delaney's book Inside SQL Server 2005: The Storage Engine to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 28, 2009 at 6:02 am
They are. Just not to the extent of other resources. Steve has a pretty open policy and lets people learn by writing articles. Yeah, sometimes that leads to... interesting... results,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 28, 2009 at 5:40 am
Since you are worried about licensing, but you correctly are trying to avoid Access... This is hardly and optimal solution, but what about another instance on the same server. You...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2009 at 8:48 pm
The Performance & Tuning book from the Inside SQL Server series is extremely good. Tips and best practices from some of the best people in the industry. It's kind of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2009 at 8:43 pm
I remember running SQL Server 6.5 and having to reboot the server once a week whether we wanted to or not.
But no, with SQL Server 2000/2005/2008, I would not suggest...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2009 at 2:39 pm
That's a managed stored procedure. That means it's a procedure written in CLR code, not TSQL. Here's a link on how to write one. So that's not going to help...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2009 at 8:13 am
Do you mean encryption? Here's the entyry in the Books Online.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2009 at 6:57 am
RBarryYoung (4/26/2009)
For anyone who has been wondering where I've been, let's jsut say that it has been an eventful two weeks. I am writing this now from...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2009 at 6:52 am
Here's the documentation on it from Microsoft
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2009 at 6:46 am
If you still have the old version of the database online, why not just take a backup of it and then restore it to the new location?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2009 at 6:40 am
But, prior to attempting to run 2000 scripts on 2005, you need to be sure that they're compatible. Certain TSQL behaviors that worked in 2000 no longer work in 2005....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2009 at 6:39 am
No. You can't use mysql code IN SQL 2000. You could install mysql along side SQL 2000 on the same server, but you can't run one inside of the other.
I...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2009 at 6:36 am
Viewing 15 posts - 17,596 through 17,610 (of 22,219 total)