Viewing 15 posts - 17,611 through 17,625 (of 22,221 total)
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
WayneS (4/25/2009)
Company hired a VB developer to rewrite an application from Delphi to VB, but gave him rein over SQL. The rewrite was supposed 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 25, 2009 at 3:00 pm
Oh, yeah, I wasn't at all clear. I meant that you upgrade to a test server first, of course.
Yeah, it actually would be fun just to tear through the servers...
"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 24, 2009 at 11:45 am
Sorry I didn't back sooner. Gail has already suggested the two things I would have, snapshot isolation and tuning the query & indexes. I'm pretty sure this is the answer....
"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 24, 2009 at 11:42 am
I don't believe there's a way to hint table access. You can supply hints to the queries that access this database, but if you have ad hoc queries or client...
"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 24, 2009 at 9:10 am
From the upgrades I've done, follow Gail's advice. The Upgrade Advisor will identify all the coding issues on the database side of the upgrade.
However, it's possible to have written a...
"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 24, 2009 at 8:41 am
Personally, I'd suggest you'd be better off collecting this information from Performance Counters in the Performance Monitor utility rather than using the DMV. It doesn't capture OS level information, and...
"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 24, 2009 at 8:39 am
Purchase a really large server...
Seriously though, you need to evaluate the amount of storage you'll require on a single box. You need to understand which databases can share drives and...
"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 24, 2009 at 8:35 am
FNS (4/24/2009)
An SQL job will restore the database at a specified time (weekly). This db shouldn't be in use as it's test and will...
"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 24, 2009 at 8:27 am
Ah, different world. I think you're right.
"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 23, 2009 at 12:49 pm
I use Team System Database Edition. You don't connect to the .mdf/.ldf files with that tool either. You connect to a database through a connection string, or you have a...
"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 23, 2009 at 11:52 am
You're trying to open the file. You can't.
You need to provide a server and instance name as part of the connection string for Visual Studio. It's the same server name...
"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 23, 2009 at 11:19 am
I'm sorry, I don't have my abstracts in a readily digestible format anywhere. Something else to do next time.
However, if you register as a speaker you can look at all...
"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 23, 2009 at 8:28 am
GSquared (4/23/2009)
You just gotta love posts like these:http://www.sqlservercentral.com/Forums/Topic703170-338-1.aspx
http://www.sqlservercentral.com/Forums/Topic703094-147-1.aspx
"Here's a pile of something brown & smelly. Turn it into shiny gold for me... Now!"
"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 23, 2009 at 8:01 am
Viewing 15 posts - 17,611 through 17,625 (of 22,221 total)