Viewing 15 posts - 48,586 through 48,600 (of 49,552 total)
Sure. Please post the entire piece of code, especially what's inside the cursor loop and I'll give it a shot.
Without knowing what you're doing with the cursor, it's near impossible...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 3, 2007 at 12:06 am
What are you trying to do with the cursor? Post the entire code if possible, there's probably a better way.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2007 at 1:45 am
I used to code review everything, but I don't have time any longer. The load's spread among a small group who do know well-performing code. However stuff slips through.
On the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2007 at 12:49 am
I've found that our DBA's don't (have to) do much in the area of performance tuning code, only do cursory reviews of code, don't do much when it comes to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2007 at 12:10 am
SELECT
@@Servername
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 28, 2007 at 4:35 am
Agreed
I found the short scenarios worse than the long ones. The time available for each scenario is proportional to the number of questions. In the ones with more questions I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 28, 2007 at 3:38 am
OK, let's give this a try...
SELECT
dbo.USERS_LOGIN.UL_CONTACT_SURNAME + ', ' +...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 28, 2007 at 3:26 am
It's possible, but a little tricky. which of the rows that have the full name of Jim smith would you want returned?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 28, 2007 at 3:02 am
We're not using NTLM anywhere.
The Kerberos patch is my prime suspect too, but why would a kerberos patch cause SQL Native Access Client to no longer be able to retrieve...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 28, 2007 at 2:19 am
Update
Rolling back the security patches fixed the problem.
Now, out of four security patches, for the telephone service, remote desktop, plug and play and kerberos, which could have caused this...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 28, 2007 at 12:01 am
Could you post the C# code where you call the proc?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2007 at 1:28 am
PinAnt
Could you post the structure and data your two original tables and what you want as a result.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2007 at 6:45 am
I assume the FileID is the identity column. Try this for the insert statement.
insert wms_TrnRecoveryDetails ([User_ID],[FileName], FileModifiedDate, Filesize, system, Bookid, stageid, Divisionid, wmsid, Activityid, jobcode)
values (@User_ID, @Filename, @FileModifiedon, @Filesize, @System,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2007 at 5:05 am
Check the server name and check the login name being used.
That message usually means that the server name specified is not a running sql server or that the login...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 18, 2007 at 1:31 am
Possibly due to security. When you run the package manually, it runs under your credentials. When its scheduled it runs under the service account of SQL Agent.
It could be connections...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 15, 2007 at 1:15 am
Viewing 15 posts - 48,586 through 48,600 (of 49,552 total)