Viewing 15 posts - 7,366 through 7,380 (of 8,415 total)
It may be too late for the current project, but one of the best ways I have found to promote good types of 'code re-use' inside SQL Server is to...
August 4, 2009 at 5:58 am
shiv (8/3/2009)
In my transaction two locks occured IE(Inetent Lock, Exclusive)
Intent-Exclusive locks normally show up as IX.
They are taken on higher levels of an object as an optimization.
Books Online explains it...
August 4, 2009 at 5:23 am
Microsoft have re-invented the SPID - it now refers to the session ID of the current user process.
Books Online
August 4, 2009 at 5:16 am
So...today's SSC newsletter - entitled {title} - features Gain Space Using XML Data
You can all relax in the knowledge that everything will be smaller and faster if we store it...
August 4, 2009 at 5:09 am
This script is closely based on that in the article.
I would strongly encourage the author of this article to try it out 🙂
Nice idea for an article, but size and...
August 4, 2009 at 4:53 am
There is a very fine line between basing an article on a book (Inside Microsoft SQL Server 2005: The Storage Engine - by Kalen Delaney) and plagiarizing it.
August 3, 2009 at 7:31 pm
RBarryYoung (8/1/2009)
Man! I've had about all I can take of this guy.Grrrr... :angry:
Hmmm. Not sure how I missed that very interesting thread - though it's a bit late...
August 3, 2009 at 4:14 am
Jeff Moden (8/2/2009)
msdb.dbo.sp_delete_backuphistory
That procedure has been a nightmare for as long as I can remember. Although one can often extract reasonable performance (relative to the shipped version) with...
August 3, 2009 at 3:51 am
Hey Jan,
It looks like a puzzle or test question to me, so there may not be a real requirement at all 🙂
Jack's solution seems to cover the key points, so...
August 3, 2009 at 1:56 am
Amit (7/30/2009)
The only conclusion to all this discussion is that Strored Procedures should be used to call functions...
Not if you read the thread properly, no.
A number of solutions, including dynamic...
July 30, 2009 at 5:52 am
Having read your reply, I'm not sure you read mine...?
July 29, 2009 at 2:45 am
Good stuff Greg and binko - look forward to seeing the results.
July 28, 2009 at 5:09 pm
Greg Edwards (7/28/2009)
32 bit or x64 bit?Did you limit the memory SQL server can use? Could be the OS and SQL fighting for memory.
Greg E
Just read your post Greg. ...
July 28, 2009 at 7:52 am
Cool. Just in case it turns out to be useful, have a read of the following article by the CSS SQL Server Team if you get a moment:
It would...
July 28, 2009 at 7:40 am
It could be many things, but assuming you haven't forgotten to mention anything really important, one possibility is that the problem relates to one or more caches getting a bit...
July 28, 2009 at 4:37 am
Viewing 15 posts - 7,366 through 7,380 (of 8,415 total)