Viewing 15 posts - 571 through 585 (of 617 total)
I'm not entirely sure what you are asking, however in general if you are doing performance tuning like that you can take the Profiler results and store them into a...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 24, 2007 at 8:57 am
Pseudo code Jeff, Pseudo code.
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 24, 2007 at 8:50 am
Ok, maybe its because I have no idea what a golf leaderboard is supposed to look like but I thought it was DENSE_RANK.
IE an answer might be
Joe 277 1
John 277...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 23, 2007 at 7:44 am
To the best of my knowledge that really is the best way to do it. If the columns are indexed that should go fairly quickly though.
Kenneth Fisher
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 22, 2007 at 3:22 pm
If you are pulling a file from excel it could have been loaded into it orriginally. Also the small squares arn't always carrage returns.
There are some functions out...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 12, 2007 at 10:19 am
Ok .. just to see try
select * from upload where LTRIM(RTRIM(people_code_id)) ='P000008270'
Also confirm that the string 'P000008270' is correct in this particular query. You may be dealing...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 12, 2007 at 9:15 am
Its possible you have some weird ascii character that may be invisible but still there. Its an unusual thing to have happen but it does happen. Try running...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 12, 2007 at 9:02 am
Because you have to have some kind of condition to test on. If you did a NOT EXISTS (SELECT * FROM TABLE1) with no condition then the where clause...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 11, 2007 at 3:32 pm
select distinct p.first_name
,p.last_name
,p.people_code_id
from people as p
inner join peopletype as pt
on p.people_code_id=pt.people_code_id
where p.deceased_flag='n'
and pt.people_type='alum'
AND NOT EXISTS (SELECT * FROM Upload WHERE Upload.First_Name = p.First_Name
AND Upload.Last_Name = p.Last_Name
AND Upload.People_Code_Id = p.People_Code_Id...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 11, 2007 at 3:17 pm
Once you have the excel data into a table do something like this :
INSERT INTO ExcelTable
SELECT Field1, Field2, ...
FROM DBTable
WHERE KeyInfo NOT IN (SELECT KeyInfo FROM ExcelTable)
At least that...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 11, 2007 at 2:59 pm
I'm not sure if this is the best approach or not but I would use a DTS package. Load the excel file into a temporary table. Update it...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 11, 2007 at 2:50 pm
If it makes you feel any better debugging sp_executesql can be a royal pain.
Here is a quicky sample
declare @tablename nvarchar(50)
declare @sql nvarchar(1000)
SET @tablename = 'sysobjects'
set @sql = 'dbcc checktable (@tablename)'
exec...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 11, 2007 at 2:44 pm
Unfortunatly in SQL 2000 you can not convert from text directly. What enterprise manager is doing behind the sceens is creating a temp table, loading it with the data...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 11, 2007 at 2:24 pm
I would try changing the count(*) to a count(1). It is marganally faster. Also do you have any where conditions, groupings etc on the count? If so...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 11, 2007 at 1:06 pm
If the process you killed is a long running command .. say a large insert .. then when it is killed it does a rollback. If you do another...
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 10, 2007 at 11:58 am
Viewing 15 posts - 571 through 585 (of 617 total)