Viewing 15 posts - 48,661 through 48,675 (of 49,552 total)
Your wild cards are a little too wild. Keywords LIKE '%c%' will match any of the following. 'Access','Visual Basic','C#', 'Javascript','Cobol',etc
That may be the cause of your 'ghosts'
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
May 24, 2007 at 12:52 am
The same way you'd use it outside a stored proc, or anywhere else for that matter
SET <variable> = dbo.<functionname>(<parameter list> )
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
May 24, 2007 at 12:37 am
And please don't post multiple threads regarding the same problem
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=367811
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
May 22, 2007 at 7:03 am
Are the tables in Access or in SQL? * is the access wildcard. % is the sql equivalent.
p.s. using wildcards like you are will almost guarentee terrible performance with large...
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
May 22, 2007 at 6:52 am
That query should be fine, and there should be no need for locking hints.
Please can you post the enire trigger code and the schema of TableA?
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
May 22, 2007 at 5:54 am
There is one? That's news. Could you drop me a private message wit it please?
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
May 18, 2007 at 7:28 am
Or when the query includes a half-written stored proc. See the OP's latest posting.
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
May 18, 2007 at 7:03 am
Between works quite well.
Think about what it means for an ip address to be in a range.
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
May 18, 2007 at 1:52 am
60000 rows is small. Shouldn't have trouble changing the schema for that.
Otherwise, substrings and comparisons.
The commented out stored proc has the right idea with the substrings. You'll just have 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
May 18, 2007 at 1:22 am
Nolock has no effect in an update statement. It only affects read locks.
Could you post the trigger's code and, if possible the deadlock graph (obtained either using profiler, or from...
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
May 18, 2007 at 1:14 am
More homework?
(http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=366682)
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
May 18, 2007 at 1:08 am
Or, since we're using SQL 2005, we can use a CTE
;
WITH LotsOfDates(TheDate) AS (
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
We stand on the bridge and no one may pass
May 18, 2007 at 12:49 am
Can you post the query please? Table structure and sample data also, if possible.
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
May 17, 2007 at 11:27 pm
Don't post your homework here like that again. Homework is supposed to be for you to do to learn something, not for other people to do for you.
You learn nothing...
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
May 17, 2007 at 6:25 am
Maybe. Won't be the first time.
I used to do student marking when I was at university. The markers had a habit of doing an internet search for code if...
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
May 17, 2007 at 6:18 am
Viewing 15 posts - 48,661 through 48,675 (of 49,552 total)