Viewing 15 posts - 16,666 through 16,680 (of 22,219 total)
Nah, let's keep it on here. If the article wasn't clear, this can help to explain the issues for someone else.
No, don't put in the name of a single server....
"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
August 25, 2009 at 7:34 pm
j.bradshaw (8/25/2009)
"There is an alias included in the parameter, SqlServer3, that's probably not the same on your system. You'll need to replace this with the appropriate setting...
"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
August 25, 2009 at 3:26 pm
SQLBOT (8/25/2009)
download SQL Toolbelt and use SQL Compare to build your schema & assign appropriate security, then use SQL Data Compare to fill up some...
"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
August 25, 2009 at 12:09 pm
To selectively move parts of the structure and parts of the data you will have to perform manual tasks to create something that can be transmitted. There are number 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
August 25, 2009 at 11:30 am
The problem is in your code, not in the TSQL. You have to be able to retrieve the error message from the error.
"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
August 25, 2009 at 11:25 am
Mel Harbour (8/25/2009)
One of the things that we're looking into at the moment involves ways in which we can improve the site navigation. I mean this in the broadest...
"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
August 25, 2009 at 11:10 am
j.bradshaw (8/24/2009)
Well, I have several beginner's...
"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
August 25, 2009 at 7:45 am
I'd suggest the Red Gate Tool Belt for SQL Server. Great stuff, Data compare, SQL compare, SQL Prompt...
"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
August 24, 2009 at 12:46 pm
It really depends on too many factors for me to comment. What service pack do you have installed? I had a lot of problems with the Tuning Advisor until 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
August 24, 2009 at 9:59 am
Jack Corbett (8/24/2009)
Dave Ballantyne (8/24/2009)
Ive got a bad feeling about thishttp://www.sqlservercentral.com/Forums/Topic775882-338-1.aspx?Update=1
Ah, that's a good one. I think the issue with that one is due to language. I think...
"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
August 24, 2009 at 6:48 am
Dave Ballantyne (8/24/2009)
Ive got a bad feeling about thishttp://www.sqlservercentral.com/Forums/Topic775882-338-1.aspx?Update=1
That's no moon. It's a space station.
"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
August 24, 2009 at 5:48 am
So, to get the number of rows you'd just modify the query to do a count
SELECT COUNT(*)
FROM table
WHERE col = '2'
It's just a straight aggregate function. If 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
August 24, 2009 at 5:48 am
The data I initially tested with was distributed about the same as yours. I was using AdventureWorks.SalesOrderDetail & the ProductID. 870 has 4,688 rows & 897 has 2 rows. But...
"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
August 21, 2009 at 1:02 pm
TheSQLGuru (8/21/2009)
"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
August 21, 2009 at 12:02 pm
TheSQLGuru (8/21/2009)
"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
August 21, 2009 at 11:15 am
Viewing 15 posts - 16,666 through 16,680 (of 22,219 total)