Viewing 15 posts - 211 through 225 (of 1,065 total)
The simple answer is that SQL Server will make sure that only one row exists for a given value if you declare the index as UNIQUE, otherwise you can have...
February 17, 2011 at 1:40 am
GilaMonster (2/16/2011)
Beware mixing implicit and explicit transactions. Too easy to commit one time too few
Been there, done that, got the t-shirt.
Went to lunch whilst one commit short of a...
February 16, 2011 at 7:29 am
Grant Fritchey (2/16/2011)
but I think I'm right on this one if implicit transactions are on.
I also thought that if you executed a procedure on a connection with implicit transactions on,...
February 16, 2011 at 7:14 am
Grant Fritchey (2/16/2011)
February 16, 2011 at 6:55 am
SELECT @value1=column1 ,@value2=column2 from table where table.id = @id
Don't forget to define the parameters as output in both the stored procedure and the calling script.
February 15, 2011 at 5:05 am
If your search this and other forums you will find a lot of posts from people who have had trouble backing up over a network.
I have had similar trouble in...
February 15, 2011 at 1:03 am
Don't know if anything is possible for the CPUs, but for the memory, isn't this simply a case of specifically setting the "Minimum Server Memory", but leaving the "Maximum Server...
February 14, 2011 at 3:15 am
mister.magoo (2/12/2011)
This interested me, so I wrote a TVF for it
Only one word to describe your solution mistermagoo... Elegant
I like it.
February 13, 2011 at 6:19 am
Most articles I have read would point to anything > 95% being good, so I don't think you have a problem.
February 11, 2011 at 4:53 am
Are you having any particular issues that you think are related to the amount of lock memory?
If not, leave it alone... SQL Server generally does a good job of balancing...
February 11, 2011 at 3:37 am
Nothing wrong with your solution, but...
Used in small numbers you may not notice anything, but the performance of UDFs that return a scalar value can be an issue when executed...
February 11, 2011 at 1:52 am
Are you also including a GRANT statement when you try to create the function?
That error message would indicate that you are trying to grant EXECUTE permission to the function, but...
February 10, 2011 at 8:30 am
carlo 47463 (2/10/2011)
February 10, 2011 at 4:55 am
crazy4sql (2/10/2011)
I have found one thread here discussing on same topic.http://www.sqlservercentral.com/Forums/Topic842499-146-1.aspx
Thought worth to share with
If you read through the whole of the thread and read Gail's (GilaMonster) last post,...
February 10, 2011 at 4:16 am
crazy4sql (2/10/2011)
Please familiarise yourself about lock escallation and isolation level. You will know your answer yourself and then my reply will also make sense. 🙂
I've never heard of nolock causing...
February 10, 2011 at 3:38 am
Viewing 15 posts - 211 through 225 (of 1,065 total)