Viewing 15 posts - 1,576 through 1,590 (of 5,504 total)
Without knowing what the functions used in the query actually look like it's close to impossible to help you any further...
All I can say is: maybe the good old divide'n'conquer...
May 12, 2011 at 2:58 pm
Here are a few steps I would take to kill that *cough* c.u.r.s.o.r.:
1) store the result of Declare OPIS_Cursor Cursor ... in a temp table since it'll be used in...
May 12, 2011 at 12:59 pm
duplicate post. no replies please.
Original post: http://www.sqlservercentral.com/Forums/FindPost1107782.aspx
May 12, 2011 at 12:22 pm
duplicate post. no replies please.
Original post: http://www.sqlservercentral.com/Forums/FindPost1107782.aspx
May 12, 2011 at 12:19 pm
The issue is that you most probably have a string with a lenght >14 but without a '.' in between. This will lead to substring(server,1, -1) leading to the error...
May 10, 2011 at 4:49 pm
The easiest solution would be a calendar table with (at least) the date and the corresponding fiscal year.
The query then simply would be
SELECT COUNT(*)
FROM dbo.calendar
WHERE...
May 10, 2011 at 1:19 pm
Based on your sample data, what would be your expected result and what have you tried so far?
May 10, 2011 at 1:10 pm
The subqueries to populate [Regular] and the like most probably will perform a index scan rather than a seek due to the functions involved (RTRIM(TSP.TspCode) = RTRIM(CodCode)).
Maybe a CROSS APPPLY...
May 7, 2011 at 5:55 am
You eventually also might be able to perform the calculation on the SQL Server side. Depends on the complexity of the calculation.
May 6, 2011 at 4:03 pm
TheSQLGuru (5/6/2011)
May 6, 2011 at 3:18 pm
Did you try to run it from SSMS directly and as it's posted in here using a new query window?
It could be there is a transaction open before your BEGIN...
May 6, 2011 at 9:35 am
You might want to use outer joins between semester, grade and students table.
May 6, 2011 at 9:26 am
Is that really the type of query you're running?
If so, I simply would use
SELECT TOP 1 [EmployeeKey],[ParentEmployeeKey],[EmployeeNationalIDAlternateKey],[ParentEmployeeNationalIDAlternateKey]
,[SalesTerritoryKey],[FirstName],[LastName],[MiddleName],[NameStyle],[Title],[HireDate],[BirthDate],[LoginID]
,[EmailAddress],[Phone],[MaritalStatus],[EmergencyContactName],[EmergencyContactPhone],[SalariedFlag]
...
May 6, 2011 at 9:22 am
I'm talking about a clustered index on field8 and a nonclustered index like
CREATE NONCLUSTERED INDEX ncindx1 ON table1 (field3,field2) include (field1)
May 5, 2011 at 12:34 pm
Where is your clustered index?
Also, you could test if it helps to move field2 from include to the actual index.
Would you please attach the actual execution plan as .slplan file?...
May 5, 2011 at 11:56 am
Viewing 15 posts - 1,576 through 1,590 (of 5,504 total)